| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Format a chart to automatically update with last 26 data points?
I am trying to make a chart that will pull the most recent 26 weeks of data
automatically so I won't have to go in and change the range every single week. I am adding the newest data to the right of the the existing data and would like to have the chart just to the right of the most recent data. If you have any suggestions please let me know. Thanks! David |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Format a chart to automatically update with last 26 data points?
See
Dynamic Charts http://www.tushar-mehta.com/excel/ne...rts/index.html specifically example 2. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am trying to make a chart that will pull the most recent 26 weeks of data automatically so I won't have to go in and change the range every single week. I am adding the newest data to the right of the the existing data and would like to have the chart just to the right of the most recent data. If you have any suggestions please let me know. Thanks! David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
| Update a chart immediately after inputting data into data source | Charts and Charting in Excel | |||
| Height (in points) of data point in chart above x-axis | Charts and Charting in Excel | |||
| How do I automatically update a graph after adding a data point | Charts and Charting in Excel | |||
| Data Points in Scatter Chart | Charts and Charting in Excel | |||
Hybrid Mode
