Format a chart to automatically update with last 26 data points?

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

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 <[email protected]>,
[email protected] 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
>