| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combination chart with three data ranges | Charts and Charting in Excel | |||
| Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
| Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
