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 |
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 |
All times are GMT +1. The time now is 06:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com