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

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