Automatic update of graph for 13 weeks
 

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??

Automatic update of graph for 13 weeks
 

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
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mursin" <u35883@uwe wrote in message news:7540e5778c97a@uwe...
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??