The operation process of adding secondary coordinate axis in excel2016

Open the data for which you want to create a secondary coordinate axis, select the data, then [Insert], select the histogram in the [Chart] functional area to get the preliminary graph.

Select the chart, in [Current Selection] under [Format] in [Chart Tools], select [Series [Growth Rate]], this is what we want to put next Axis data.

After selecting the [Growth Rate] series, right-click on it and select [Format Data Series] to get the settings window.

In the [Series Options] column that appears, select [Secondary Axis].

In the obtained graph, continue to select the [Growth Rate] series, right-click and select [Change Series Chart Format], and in the [Change Chart Type] that appears, select [Combination] , then select the second [Clustered Column Chart], then confirm, and you will get the graph you want.

Add a title, unit, change the horizontal axis value to year, and you will get a very standard chart.

If necessary, add data labels, data identifiers, etc. The result is as shown in the figure.

The above is the detailed content of The operation process of adding secondary coordinate axis in excel2016. For more information, please follow other related articles on the PHP Chinese website!