Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting Graphs - making me crazy! | Excel Discussion (Misc queries) | |||
HYPERLINK GRAPHS | Charts and Charting in Excel | |||
Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
Copying Charts and graphs to another worksheet with formulas | Excel Worksheet Functions | |||
Help! My graphs sneezed! | Charts and Charting in Excel |