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.