Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I am using Excel 2003.
I have several graphs that have been changed from a 1 or 2 year pictures to a Rolling 13 month picture. Right now I have to go into the graph and reset the source data to refect the current 13 months. Ex: In March I am showing data for March- 2007 thru March 2008. Then in April, I have to change it to show data for April 2007 thru April 2008. Is there a way to automate this so that I do not have to physically change the data each month? Such as: Is there a way to create a macro or a way to set up the graph to automate this function. I would appreciate any help someone can give me. Aurora |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
12 month Rolling Total | Excel Worksheet Functions | |||
How to create a rolling 6 month average? | Excel Discussion (Misc queries) | |||
rolling 12 month average | Excel Worksheet Functions | |||
How do I set up 12-month rolling month cells in excel? | Excel Discussion (Misc queries) | |||
3 month rolling chart | Charts and Charting in Excel |