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.
|