Change the source data in multiple charts

  • Thread starter Thread starter rfogator
  • Start date Start date
R

rfogator

I have a monthly report that I publish that has a large number of charts
attached to it. Every month I go in and manually change the source
data in each individual chart. The columns are the only thing that
change in the source data, the rows remain the same.
Is there a way to automate the process or make a blanket change to the
columns in the source data to eliminate this tedious process??????
 
I have a monthly report that I publish that has a large number of charts
attached to it. Every month I go in and manually change the source
data in each individual chart. The columns are the only thing that
change in the source data, the rows remain the same.
Is there a way to automate the process or make a blanket change to the
columns in the source data to eliminate this tedious process??????
Click to expand...

If Bernard's suggestion does not match your wish, I'd suggest recording a
macro that changes the chart in the way you like. You'll probably have to
edit the macro to make it do exactly what you want on each chart, but the
macro recorder will get you a long way. And if/when you try the macro
recorder, come back with questions as you get along.
 
I got tired of doing this by hand, so I wrote a little macro to handle
it. You can change any parts of text in the series formulas, much the
same as Find-Replace works in the worksheet. To change the columns, I
find it's safest to include the dollar signs, i.e., change $C$ to $D$,
so you don't accidentally rename a worksheet or something.

http://www.geocities.com/jonpeltier/Excel/Charts/ChgSrsFmla.html

- Jon
 
Back
Top