A
Aurora
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
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