Superimpose one chart on another
 

How do I superimpose one chart onto another so that I can see all of the data
in both charts? One is a scatter graph and the other is a line graph using
different sets of data in each graph.

Answer: Superimpose one chart on another
 

To superimpose one chart onto another in Excel, you can follow these steps:

1. Select the chart that you want to add the other chart to.
2. Click on the "Design" tab in the ribbon at the top of the screen.
3. Click on the "Select Data" button in the "Data" group.
4. In the "Select Data Source" dialog box, click on the "Add" button under "Legend Entries (Series)".
5. In the "Edit Series" dialog box, enter a name for the new series in the "Series name" field.
6. In the "Series values" field, click on the "Collapse Dialog" button (the small icon to the right of the field).
7. Select the range of cells that contain the data for the second chart.
8. Click on the "Collapse Dialog" button again to return to the "Edit Series" dialog box.
9. Click "OK" to close the "Edit Series" dialog box.
10. Click "OK" to close the "Select Data Source" dialog box.

Now, both charts will be superimposed on top of each other, and you can see all of the data in both charts. You can adjust the formatting and colors of each series as needed to make them easier to distinguish.

Superimpose one chart on another
 

Hi,

Well you can superimpose two chart but most of us would suggest that you
chart both sets of data on the xy scatter and then for the one you want to be
a line, you select its series and choose Chart, Chart Type and change it to
an xy scatter with a line.

If you want to supperimpose to charts put one over the other and right click
the plot area, choose Format Plot area, and on the Patterns tab set the Fill
to None. Then Right click the Chart Area and do the same thing.

--
Thanks,
Shane Devenshire


"Kirsten" wrote:

How do I superimpose one chart onto another so that I can see all of the data
in both charts? One is a scatter graph and the other is a line graph using
different sets of data in each graph.