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

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - How do I create a rolling average chart, adding most recent data? (https://www.excelbanter.com/charts-charting-excel/53861-how-do-i-create-rolling-average-chart-adding-most-recent-data.html)

Doug@NxEdge

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.

Jerry W. Lewis

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

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.

All times are GMT +1. The time now is 03:00 PM.