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?