Combine/Merge 7 charts into one

[Lise]

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

 

[Jon Peltier]

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