How do I create a rolling average chart, adding most recent data?

Would like to create a chart where new data is added weekly to a data table
and the chart graphs this newest data and drops the oldest. Everytime I add
the data to the table, the graph moves the source data reference down so that
the original data is still displayed. Thanks.

Check out
http://peltiertech.com/Excel/Charts/DynamicLast12.html
Also there are several examples of dynamic range charts at
http://tushar-mehta.com

Jerry

Doug@NxEdge wrote:

> Would like to create a chart where new data is added weekly to a data table
> and the chart graphs this newest data and drops the oldest. Everytime I add
> the data to the table, the graph moves the source data reference down so that
> the original data is still displayed. Thanks.