How to create double vertical coordinates in Excel?

The dual-coordinate chart has one more vertical axis than the ordinary chart. The left axis is the primary coordinate axis and the right axis is the secondary coordinate axis. Let's take a look at how to make a two-coordinate chart in Excel?

Input data: When entering data, you need to add "year" after the number of the year, so that you can directly generate a suitable chart after selecting the data; select all data (including labels and numbers)

Execute Insert-Chart-Line Chart, select "Line Chart with Data Markers" to generate a line chart

Select the red data column, Right-click and select "Set Data Series Format"

Select "Secondary Coordinates" in the pop-up dialog box; generate a dual-coordinate graph

Recommended: "excel tutorial"

The above is the detailed content of How to create double vertical coordinates in Excel?. For more information, please follow other related articles on the PHP Chinese website!