+ Reply to Thread
Results 1 to 2 of 2

Using "offset" functionality in graphs. HOW?

  1. #1
    ZEB
    Guest

    Using "offset" functionality in graphs. HOW?

    I have created worksheets which utilize "offset" functionality, so that on a
    weekly basis I only have to change a single value and multiple tables I have
    set up automatically change to roll with changes in dates.

    Now I have set up graphs to reflect the data, but find myself updating
    ranges inside the graphs weekly. I would like to use the same type of
    functionality so that the single field update I do ALSO changes the graph
    ranges. I tried to use the "offset" functionality in the source date - value
    section of the graph, but received an error message that the function is not
    allowed.

    If there is a way to update graph ranges using "offset" or some other
    functionality, please let me know. Thanks.

  2. #2
    Jon Peltier
    Guest

    Re: Using "offset" functionality in graphs. HOW?

    This page has examples and links to more examples of dynamic charts which
    use OFFSET among other functions to define the data:

    http://peltiertech.com/Excel/Charts/Dynamics.html

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    http://PeltierTech.com
    _______


    "ZEB" <ZEB@discussions.microsoft.com> wrote in message
    news:6C94BD01-6528-4D31-9002-4F7F4CFEC6F7@microsoft.com...
    >I have created worksheets which utilize "offset" functionality, so that on
    >a
    > weekly basis I only have to change a single value and multiple tables I
    > have
    > set up automatically change to roll with changes in dates.
    >
    > Now I have set up graphs to reflect the data, but find myself updating
    > ranges inside the graphs weekly. I would like to use the same type of
    > functionality so that the single field update I do ALSO changes the graph
    > ranges. I tried to use the "offset" functionality in the source date -
    > value
    > section of the graph, but received an error message that the function is
    > not
    > allowed.
    >
    > If there is a way to update graph ranges using "offset" or some other
    > functionality, please let me know. Thanks.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1