I have a chart displaying 2 years worth of data €“ each month is a data point.
I want to automatically drop the oldest data point and add the newest when I
start to enter data for the new month. I know how to change the data range
manually to do this. Can it be done automatically? Using Excel 2003 running
under XP Pro.
--
ray

Hi,

You can do this using named ranges. Yours would be a variation on the Last
12 months formula.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"rayteach" wrote in message
...
I have a chart displaying 2 years worth of data €“ each month is a data
point.
I want to automatically drop the oldest data point and add the newest when
I
start to enter data for the new month. I know how to change the data range
manually to do this. Can it be done automatically? Using Excel 2003
running
under XP Pro.
--
ray