How Excel makes a column-like line chart

In this paper, for example, Excel2007 and 2003, as shown in the following figure, to follow the above table to create the following column line diagram, I hope that the first three items are histogram display, the last "cumulative complete annual plan" for the polyline display.

Here we take a excel2007 example to explain how to operate, excel2003 principle, we will add later.

First select the entire Excel datasheet, then click the "Insert" tab in the Ribbon, and then click the lower triangle from the column chart to select the first in the two-dimensional column chart from the pop-up menu.

Select the legend for the cumulative complete annual plan% on the right of the diagram, and then right-click on it and choose Change Series icon type (Y) from the shortcut menu.

From the pop-up window below, select the first diagram in the line chart, and then click OK.

Again, select the legend for the cumulative complete annual plan% on the right, then right-click on it and choose Format Data Series (I) from the shortcut menu.

From the Format Data Series window that pops up, click the first item series options in the left pane, and then select secondary axis from the right pane.

The effect of setting the finish is shown in the following illustration.

Add, if you are using excel2003, set the same principle, first the data corresponding to the map to the line chart, and then set the secondary axis can be.

Excel2003 in the selection of data columns can not be selected on the legend, you may choose in the cylindrical map coordinate system. To do this, select the entire datasheet and then select Chart (H) from the Insert menu. Then follow the Icon Wizard to create a histogram, as shown in the following figure. Then select the cumulative complete annual plan% item in the bar chart, right-click on it, and choose icon Type (Y) from the shortcut menu ...

Select Line chart from the standard Type tab of the icon Type window, and then select the middle 10 percent line chart from the sub chart type (T), and then click OK.

Again, select the cumulative complete annual plan% item in the histogram, right-click on it, and choose Data series Format (O) from the shortcut menu.

From the pop-up window, under the Axes tab, select the secondary axis item, and then click the OK button.

Note : For more wonderful tutorials, please pay attention to the triple graphics tutorial channel,