View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Shane Henderson Shane Henderson is offline
external usenet poster
 
Posts: 1
Default 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