How Can I Overlay Graphs?

1. Open the Excel worksheet that contains the data series.
2. Click and drag the cursor on the range of cells that will convert to a chart.
3. Select the “Insert” tab on the command ribbon.
4. Click the arrow in the lower-right corner of the “Charts” group to launch the dialog box. The “Insert Chart” dialog box opens with a gallery of sample charts.
5. Select a 2-D chart. For example, choose the bar, column or line.
6. Click “OK.” The worksheet data converts to an embedded chart. The “Chart Tools” ribbon appears.
7. Click one data series in the chart’s plot area.
8. Click the “Design” tab on the “Chart Tools” ribbon.
9. Click the “Change Chart Type” button in the “Type” group. A gallery of sample chart types appears.
10. Click the preferred 2-D chart type. The data series converts. Two different chart types display in the same chart area.
11. Edit the chart with the commands in the “Design,” “Format” or “Layout” tabs. The “Design” tab contains “Chart Styles” and “Chart Layouts.” The “Format” tab contains “Shape Styles” and “Shape Effects.” The “Layout” tab contains “Labels” and “Axes.”