|
Posted to microsoft.public.excel.charting
|
|
|
Automatically Update Chart(s) with new data.
Thanks!
"Jon Peltier" wrote:
You can make a chart based on dynamic ranges that update as the data range
changes. What you want is a variation on this:
http://peltiertech.com/Excel/Charts/DynamicLast12.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"Merlyn" wrote in message
...
I have charts which [I want to] automatically display a rolling 30 days of
data. I want the new day's data to be the right column and the oldest day
(31 days ago) to fall off the left side.
How do I do this?
|