All,
I have an Excel sheet that has about 6 years worth of data in it, and I add new data every week. I have many charts set up to display the data. What I would really like is to have the charts set up to automatically display the last 52 weeks of data only.

Right now I go into each chart, one at a time, and right click on "format axis", go to the scale tab, and enter new date ranges for the range.

Using Microsoft Excel 2000

Thanks,
RubberToe