Add a secondary axis to an Excel chart

Excel Chart application is very extensive, primary and secondary axis is also a regular in the production of charts, because 2 kinds of data of different contrast, can not be reflected on an axis, then the secondary axis is particularly important, can be more clearly intuitive display. So let's look at the specific how to achieve it?

First open the Excel worksheet where you want to create the chart, and the data is designed against your own tabular data.

Select all data and then click Insert Column Chart;

Right Arrow red Column chart (i.e. year-on-year growth data) Select ' Set number series format '

Select secondary axis

The secondary axis appears on the right, because the chart is not good, right-click Red Chart Select ' Change series chart type '

Select a red chart type in a line chart

The chart structure that you want to build is now formed, and the display of the added value is more appropriate

Right-column and line chart select ' Add Data label ', adjust the position of the number to display the full chart.