Copying data from one chart to another - how?

  • Thread starter Thread starter Alan_Partridge
  • Start date Start date
A

Alan_Partridge

I have many graphs - all plotting on similar scales but using different
data. Is there any way I can simply copy one set of data from one graph
and paste it into another graph so that I can avoind going through all
the hassle plotting each curve again? I want to have graphs showing
different combinations of the same data and have hundreds of curves to
plot so this could be a huge timesaver...

Cheers.
 
This might help. Select the series you want to copy, then select the SERIES
formula in the formula bar, and copy that. Select the other chart's plot
area, and paste. This creates a new series in the second chart that is based
on the formula.

You can copy a chart, then select another chart, and use Paste Special from
the Edit menu. This allows you to paste either the formats or the formulas
from the first chart onto the second. This pastes all the series, not just
one at a time as the first technique does.

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


"Alan_Partridge"
 
Back
Top