| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#4
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? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I automatically update a text box in a chart? | Charts and Charting in Excel | |||
| how do i get the data in a chart to automatically update? | Charts and Charting in Excel | |||
| how do i update a chart area automatically | Charts and Charting in Excel | |||
| Format a chart to automatically update with last 26 data points? | Charts and Charting in Excel | |||
| How do I automatically update chart source data links for moved fi | Charts and Charting in Excel | |||
Linear Mode
