Copy the series formula, select the plot area of the other chart, click in
the formula bar, paste the series formula, and click Enter. Note, if this
series formula is for series 1, it will take position 1 in the new chart,
moving the other series back in the order. However, before you click Enter,
you can edit the pasted formula, so change to a higher plot index).

An alternative is to copy one chart, select the second, and use Paste
Special with the Formulas option. This pastes all series in the copied chart
after all series in the chart they are pasted into.

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


"hmm" wrote in message
...
I want to consolidate pairs of charts into one chart with two series, call
them A and B. Rather than doing the work all over to add series B to
chart
A, I would simply like to copy B's SERIES() function in the formula bar
and
paste it into A's formula bar.

While working in a formula bar is often a convenient way to change an
existing series, I have not found a way to add a new series to a chart.
Can
it be done, and how?