Automatically adjusting X axis date range

[RubberToe]

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

[olasa]

One option is to use a Scroll Chart. Here is an example.
A similar scroller can also be used to make a zoom in/out function. It basically use =OFFSET() formula to accomplish this effect.

HTH
Ola