How to draw a double ordinate axis in an Excel chart

For example, in a column chart, you have to show sales in the Northeast, to show the percentage of each month, if only one vertical axis, the "percentage" of the data series, can not be clearly displayed at this point, you will be able to use two vertical axes in the chart to easily solve the problem, the following steps.

(1) on the Excel 2010 worksheet, right-click anywhere in the chart, and select series ' percent ' in the chart element drop-down list box of the floating toolbar that appears.

(2) Press the "Ctrl" + "1" key combination to quickly open the Format Data Series dialog box, on the Series Options tab, in the series drawing in the Options area, select the secondary axis radio button to draw the current series on the secondary axis.

(3) Set the spacing to "80%" in the Category Spacing options area of the Series Options tab; Select the No Fill radio button on the Fill tab, select the Solid radio button on the Border Color tab, and set the color to red, and in the Border Styles tab, the dash type "Set to dash."

(4) When the data series formatting is complete, the two data series information to be displayed in the chart is clearly visible.