How to Combine a Graph

1. Open the Excel Program.
2. Click the 'File' tab on the command ribbon. A list of commands appears.
3. Click 'Open.' Select the workbook to open.
4. Click the 'Insert' tab on the command ribbon.
5. Click and drag on the categories and data cells for the chart.
6. Click the arrow next to the chart style in the 'Chart' group.
7. Click to select the preferred chart type, for example, '2-D Column.' The data converts to an embedded chart. The 'Chart Tools' ribbon appears with three tabs: 'Design,' 'Layout' and 'Format.'
8. Click the 'Design' tab on the 'Chart Tools' ribbon.
9. Click one data series on the chart to display as a different chart type. For example, one color column. If no data series is selected, the whole chart will change.
10. Click the 'Change Chart Type' button in the 'Type' group. The 'Change Chart Type' dialog window opens with a gallery of charts.
11. Click a different chart type. For example, 'Line.'
12. Click 'OK.' The selected data series converts to the new chart type. Two different chart types appear on the screen.
13. Edit the combined chart, if preferred. To bring a data series closer to the other data series, right-click one data series. A list of options appears. Click 'Format Data Series.' A 'Format Data Series' dialog window opens. Select the radio button for 'Secondary Axis.' Click 'Close.' The chart converts.