Automatically Update Chart(s) with new data.

[Merlyn]

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?

 

[Barb Reinhardt]

Jon Peltier has a nice description of how to do that here

http://www.peltiertech.com/Excel/Charts/DynamicLast12.html

HTH,
Barb Reinhardt

 

[Jon Peltier]

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

 

[Merlyn]

Thanks!

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
_______

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?

 

[Merlyn]

Thanks!

Jon Peltier has a nice description of how to do that here

http://www.peltiertech.com/Excel/Charts/DynamicLast12.html

HTH,
Barb Reinhardt

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?