Automatically Update Chart(s) with new data.
 

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?

Automatically Update Chart(s) with new data.
 

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

http://www.peltiertech.com/Excel/Cha...micLast12.html

HTH,
Barb Reinhardt

"Merlyn" wrote:

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?

Automatically Update Chart(s) with new data.
 

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?

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?

Automatically Update Chart(s) with new data.
 

Thanks!

"Barb Reinhardt" wrote:

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

http://www.peltiertech.com/Excel/Cha...micLast12.html

HTH,
Barb Reinhardt

"Merlyn" wrote:

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?