Limited data range

I update a data table weekly, but I would like a chart that only displays the
last 13 weeks of information. Is there any way to automate this, or would I
have to update the range manually every week? Thanks!!

This should help you:
http://www.peltiertech.com/Excel/Charts/Dynamics.html

"SEIMurf" wrote:

> I update a data table weekly, but I would like a chart that only displays the
> last 13 weeks of information. Is there any way to automate this, or would I
> have to update the range manually every week? Thanks!!