software

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 quot;chart,quot; quot;source dataquot; 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?

This web page describes a technique to change series formulas en masse:

peltiertech.com/Excel/Charts/ChgSrsFmla.html

It provides a link to a workbook that contains a macro to change these
formulas.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

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