Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically shift chart data range
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically shift chart data range
Excel 2007
With PivotCharts linked to PivotTables. Updates all PTs (and PivotCharts) using a reference PT. http://c0718892.cdn.cloudfiles.racks.../04_12_10.xlsm |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically shift chart data range
On Apr 16, 12:54*pm, Herbert Seidenberg
wrote: Excel 2007 With PivotCharts linked to PivotTables. Updates all PTs (and PivotCharts) using a reference PT.http://c0718892.cdn.cloudfiles.racks.../04_12_10.xlsm Believe me, I'd love to update all these things to pivot charts instead of standard charts, but I've got a kind of 'don't mess with what has worked so far' mentality here to deal with. Also, we're running Excel 2003, so I don't have 2007 at my disposal. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically shift chart data range
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 "Sean Clayton" wrote: 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? . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically shift chart data range
On Apr 19, 9:40*am, Hugo Jorgensen
wrote: 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 "Sean Clayton" wrote: 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? .- Hide quoted text - - Show quoted text - In most cases, it's from a new column with more than one row, but yes, every chart needs to start with a new column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
seeking help on how to automatically shift an average range as new data is added | Excel Discussion (Misc queries) | |||
repost: seeking help on how to automatically shift an average range as new data is added | Excel Discussion (Misc queries) | |||
How to have a chart automatically adjust range as I add data entri | Excel Discussion (Misc queries) | |||
How to have a chart automatically adjust range as I add data entr. | Charts and Charting in Excel | |||
How can I make cell data automatically shift up when deleting | Excel Discussion (Misc queries) |