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

D

Doug@NxEdge

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Charting Data Series 3
Dynamic stacked bar chart not working 3
How do I get my sizing handles back? Graph/data on same page. 1
How do I align a data table with the corresponding data? 1
how do I link a text box on a chart to a specific data point? 1
Standard Error Formula 1
Avoiding cells being included in a chart 4
Data disappears when I edit the chart. 1

Top