Hi

I currently have 7 charts with specific data I want to be able to merge all
onto one chart is this possible?

Thanks

Lise

You can add data from a worksheet to a chart, in several ways.

1. Copy the data, select the chart, use Paste Special to add the data as new
series.

2. Right click chart, choose Source Data, click on Series tab, click Add,
and indicate ranges for X and Y data as appropriate.

3. Copy a chart with data you want to add, select other chart, choose Paste
Special, and choose Formulas.

And more....

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


"Lise" wrote in message
...
Hi

I currently have 7 charts with specific data I want to be able to merge
all
onto one chart is this possible?

Thanks

Lise