| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rolling data table??
Does anyone know how to make a data table continually show the last part of
your data? I have about 3yrs of a data table for each month, and I am wanting the chart and graph to show just the last 12mos each time I update it. Is there a formula, rather than just adjusting the series values? Thanks |
|
#2
|
|||
|
|||
|
Hi,
You can do this using named ranges. Jon Peltier has a few links to dynamic charts. http://peltiertech.com/Excel/Charts/...hartLinks.html I have an example of scrolling through your data set. http://www.andypope.info/charts/Scrolling.htm Cheers Andy Brandon wrote: Does anyone know how to make a data table continually show the last part of your data? I have about 3yrs of a data table for each month, and I am wanting the chart and graph to show just the last 12mos each time I update it. Is there a formula, rather than just adjusting the series values? Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| changing proportion of chart and data table | Charts and Charting in Excel | |||
Linear Mode
