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