Rolling 13 Month Charts

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

column charts with set set of data 0
Excel 2007 Line Chart - Chart line to go directly to next value 3
Excel 2007 charts: want to avoid zero values 1
Dates In Excel 5
rolling 3 month tracking 3
Plotting against Date (collating months) 2
Summary Worksheet. 1
Year end Data from multiple worksheets 1

Top