See Jon Peltier's article on Dynamic Charting. His example is for 12 months,
but you can easily modify it for any time frame.

http://peltiertech.com/Excel/Charts/DynamicLast12.html

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Judy" wrote:

I have a spreadsheet tracking documents through their approval cycle. I

need to produce a chart weekly, always showing the most recent 3 weeks of
data. So, the chart needs to drop off the oldest week, and add the newest
week's values, showing the totals in each stage of review, comparing the
current week and the past 2 weeks. Here's a sample of my spreadsheet:

A B C D
E F
1 Week of Author Review 1 Review 2 Review 3 Approved
2 5/28/2009 24 130 25 8 194
3 6/4/2009 20 134 26 1 200
4 6/11/2009 15 135 11 4 201
5 6/18/2009 20 150 9 6 202
6 6/25/2009 15 153 8 8 206

I tried recording a macro to Remove the earliest date's values (5/28 in
example above) and to Add the lastest date's values (6/18 above) to the
chart; the macro works for the first time I have to update, but that's the
only week it works. For the following week (6/25 above), the macro does
remove the 6/4 week of values fine, but it still just adds the new week as
the 6/18 week.

Is there an easier way to update my chart weekly or do I have to do it
manually each week?

Thanks for any help,

Judy