How to Do Combination Charts in Excel 2007

1. Launch Microsoft Excel and open the spreadsheet containing data by selecting 'Open' under the Office ribbon, selecting the desired file and clicking the 'Open' button.
2. Check that the data is organized in columns, with the first column containing the categories and the second and third columns containing values.
3. Highlight all three columns by selecting the top of the first column and the bottom of the third column by clicking the mouse button and holding it down to highlight before releasing the mouse button.
4. Click the 'Insert' tab in the top toolbar and click the button for the desired chart type in the 'Charts' group (such as 'Column'). Note: additional options will be displayed for that chart type; select a thumbnail image for the desired presentation of the first data series (the second column).
5. Check that the chart is inserted on the same sheet as the data.
6. Click the second set of data on the chart from the third column (the second colored set of data).
7. Right-click the data series and select 'Format Data Series.'
8. Select the category in the left-hand frame for 'Series Options.'
9. Click the option for 'Secondary Axis' in the section, 'Plot Series On' and click the 'Close' button.
10. Click the 'Insert' tab in the top toolbar.
11. Select a chart type in the 'Charts' group for the selected data series (such as line). Note: additional options for the selected chart type will be displayed; select the thumbnail to present the data series in the third column.