| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lock Chart Display to last 14 days (or data points)
I have some tables that are updated daily with a data point. I would
like the chart to just display the most recent 14 days without having to manually change the source data range each time a new point is added. Any ideas? Thanks |
|
#2
|
|||
|
|||
|
This page shows a chart of the most recent 12 months. Change a couple
constants, and it'll do your last 14 days: http://peltiertech.com/Excel/Charts/DynamicLast12.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ toilinthedark wrote: I have some tables that are updated daily with a data point. I would like the chart to just display the most recent 14 days without having to manually change the source data range each time a new point is added. Any ideas? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
| 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
