how to globally change souce data on plot

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a x-y scatter chart with about 40 individual lines originating from
individual spreadsheet tab for each line. I need to clone this chart
multiple times, changing only the column references for the x and y
parameters. To accomplish this I currently go to "chart," "source data" and
manually change the x and y references for each line. Is there a way to
globally change the cell references for all line on the chart?
 
Back
Top