Lets see, 1st I am using Excel v97 sr2.

I have a basic line chart with dates across the bottom (each date is
days from the last), and days on the left edge (2,4,6,8,ect.). I a
charting leadtime on a weekly basis.
What I would like to do run a macro after I have entered my new dat
for the week to automatically update the chart. I want to display th
latest 12 weeks on the chart. It needs to add the new date, and dro
off the oldest one.

Any ideas on how I might accomplish this would be greatly appreciated.
I am an excel novice, so I am not sure if what I am asking for is eas
to do or impossible.

Thanks,
Kevi

--
Message posted from http://www.ExcelForum.com