Ways to add a line chart to an Excel column chart

How to add a line chart to an Excel column chart is an Excel chart problem with very high rate of questioning, although it is not difficult, but still have a lot of students will not, today in this paper, an example of text to explain in Excel column chart to add a line chart method.

"Example" in the actual and plan comparison table shown below, requires the production of charts, actual and planned number of column charts, the completion ratio with line chart.

Production steps

1, select the Datasheet, Insert tab-column chart.

2, selected in the Ratio series, right-click menu, click "Set data series format."

3, change to the secondary axis.

4, select the completion rate series, click Insert-Line chart.

Add a line chart complete, as shown in the following illustration.

Add: If you need to set a series that is not as large as this example data (the completion ratio is far less than the actual and planned), you do not have to set the secondary axis.