S
Sean Clayton
I posted this a couple of months ago, and the thread was dropped after
a couple of replies. Now I find myself needing to try again, so I'd
love if someone could offer advice.
I have a spreadsheet full of charts based on monthly data. The charts
are intended to show a year's worth of information, i.e., April 2009
to March 2010. There are a series of cells in the spreadsheet with the
chart that are autoupdated with new information that the charts are
based on.
Since there are so many of these charts to update each month, I'd like
to know if there is a way to have them automatically shift their date
ranges for each new month. For example, Chart A shows data from April
2009 to March 2010. Now that April is here, the chart needs to be
shifted to show data from May 2009 to April 2010. Is there a way to
accomplish this without having to manually update each chart?
Hugo Jorgenson said:
In answer, the chart will start _and_ end from a new column each
month; i.e., this month will begin with Aug 2009 and go to July 2010,
while next month will begin with Sept 2009 and go to Aug 2010.
I've tried to figure this out on my own, but I haven't had much
success. Could someone offer direction?
a couple of replies. Now I find myself needing to try again, so I'd
love if someone could offer advice.
I have a spreadsheet full of charts based on monthly data. The charts
are intended to show a year's worth of information, i.e., April 2009
to March 2010. There are a series of cells in the spreadsheet with the
chart that are autoupdated with new information that the charts are
based on.
Since there are so many of these charts to update each month, I'd like
to know if there is a way to have them automatically shift their date
ranges for each new month. For example, Chart A shows data from April
2009 to March 2010. Now that April is here, the chart needs to be
shifted to show data from May 2009 to April 2010. Is there a way to
accomplish this without having to manually update each chart?
Hugo Jorgenson said:
Hi Sean,
There is a way to do it without PivotTables. But in order to help you I need
to know one thing.
With OFFSET function and Name Ranges you can solve it. I can show you but
first you need to tell me about the data range you have today. Do you want
the chart to start from a new column or from a new row each month?
Hugo Jorgensen
In answer, the chart will start _and_ end from a new column each
month; i.e., this month will begin with Aug 2009 and go to July 2010,
while next month will begin with Sept 2009 and go to Aug 2010.
I've tried to figure this out on my own, but I haven't had much
success. Could someone offer direction?