See
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html
specifically example 2.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I am trying to make a chart that will pull the most recent 26 weeks of data
automatically so I won't have to go in and change the range every single
week. I am adding the newest data to the right of the the existing data and
would like to have the chart just to the right of the most recent data.

If you have any suggestions please let me know.

Thanks!

David