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
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks