Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts - Setting Data Area as a Variable
I have a set of monthly financial reports and associated charts.
I need all the charts to show data just up to the current month. Up to now I have had to manually adjust the data area chart by chart at the end of each month as I move the model from one month to the next. What I need is to simply adjust one cell to state the new month number and this will adjust the data areas for all the charts. I have been experimenting with the OFFSET function plugged into the chart data range but it seems that this is not allowed. Can someone suggest an 'easy' way around this problem -- JohnG |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts - Setting Data Area as a Variable
Hi,
You can not use the OFFSET function within the chart source dialog. Rather you need to create a named range which uses the offset function. More information can be found here, http://peltiertech.com/Excel/Charts/Dynamics.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "JohnG" wrote in message ... I have a set of monthly financial reports and associated charts. I need all the charts to show data just up to the current month. Up to now I have had to manually adjust the data area chart by chart at the end of each month as I move the model from one month to the next. What I need is to simply adjust one cell to state the new month number and this will adjust the data areas for all the charts. I have been experimenting with the OFFSET function plugged into the chart data range but it seems that this is not allowed. Can someone suggest an 'easy' way around this problem -- JohnG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create multiple charts using variable data? | Charts and Charting in Excel | |||
Variable Names in Source Data References in Charts | Charts and Charting in Excel | |||
Use values instead of labels on X-axis in Area/Stacked Area Charts | Charts and Charting in Excel | |||
Setting source data range with Charts | Charts and Charting in Excel | |||
Gridlines on Area/Stacked Area charts | Charts and Charting in Excel |