Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro to shift all source data in a chart by one row or column?
Hello all,
I have a spreadsheet which contains at least twenty years of data and twenty or thirty charts. Each year we update all of the charts to move the forecast period to the current year and the next five years. Because there is data well beyond the five year period, a dynamic range for the chart data would not work. Can anyone suggest if it is possible to write a macro which I can run on each chart to shift the source data for each series in the chart by one column or row to the right? Any suggestions would be gratefully received! Thanks in advance, Shane |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro to shift all source data in a chart by one row or column?
try this defined name formula where col C has properly formatted dates
=OFFSET(Sheet5!$C$1,MATCH(TODAY(),Sheet5!$C:$C),0, 5,1) -- Don Guillett SalesAid Software "Shane Henderson" wrote in message . com... Hello all, I have a spreadsheet which contains at least twenty years of data and twenty or thirty charts. Each year we update all of the charts to move the forecast period to the current year and the next five years. Because there is data well beyond the five year period, a dynamic range for the chart data would not work. Can anyone suggest if it is possible to write a macro which I can run on each chart to shift the source data for each series in the chart by one column or row to the right? Any suggestions would be gratefully received! Thanks in advance, Shane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste a chart and get the source data to be from the new worksheet | Charts and Charting in Excel | |||
Macro question | Excel Worksheet Functions | |||
Data Range Mess | Charts and Charting in Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Reference multiple cells in if statement | Excel Worksheet Functions |