Automatic update of graph for 13 weeks

[mursin]

Hi,

I have a worksheet with 52 work weeks on it. Each week I enter in new data
and I want my graph to update for the latest 13weeks....

Does anyone know how to do this??

 

[Andy Pope]

Hi,

Have a look at the technique described by Jon Peltier, which you should be
able to adapt for your data set are required period numbers.
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Cheers
Andy