The key to making a double Y-axis line chart in Excel is data organization and chart settings. First, prepare two sets of data with different units or large numerical differences, such as temperature and sales volume, and arrange them in columns; secondly, insert the line chart and click any line, right-click to select "Set Data Series Format" and check "Sub-Coordinate Axis", or set the combination chart by "Change Chart Type". Finally, adjust the style, including using different colors to distinguish two lines, marking the Y-axis units, changing one of the groups into a bar chart if necessary, and manually adjusting the numerical range of the secondary coordinate axes to avoid overlapping the figures, so that the chart is clear and easy to read.

It is actually not difficult to make a double Y-axis line chart in Excel. The key lies in the reasonable combination of data organization and chart types. Just master a few key points and you can get it done quickly.

Prepare your data

The double Y-axis diagram is suitable for displaying data with different units or large numerical ranges of data, such as temperature and sales, cost and revenue. You need to put these two sets of data in the same table, each column represents a variable.

For example:

The data arranged in this way is convenient for subsequent operations and it is easy to see the relationship between the two variables clearly.

Insert chart and set double axes

Select all data, including the title row, and then click the Insert tab and select Line Chart in the Chart area. At this time you will see two polylines displayed on a Y axis.

Next, the focus is:

• Click any line and right-click to select "Set Data Series Format"
• In the pop-up window, check "Second Coordinate Axis"
• At this time, you will find that there is a new Y axis on the right, corresponding to the fold line you just selected

You can also use "Change Chart Type" directly in "Character Tools-Design" to find "Combination Charts", and set one of the groups to "Sub-Coordinate Axis".

Adjust the style to make the chart clearer

Double Y-axis diagrams are easy to be dazzling, so pay attention to the following points:

• Use different colors for the two lines and indicate in the legend
• It is best to add unit descriptions for the two Y axes, such as the "temperature (℃)" on the left and the "sales (piece)" on the right.
• If the data gap is too large, you can consider setting one of them as a bar chart. The combination of polyline columns will be more intuitive

Sometimes two lines overlap, especially when the initial values ??are the same. At this time, you should manually adjust the minimum maximum value of the "secondary axis" to allow the figure to widen the gap and see it more clearly.

Basically that's it. There seems to be few steps, but the details of axis adjustment and color matching are the easiest to ignore. As long as the data is right, the chart will naturally become clear.

The above is the detailed content of how to make a line graph with two y-axes in excel. For more information, please follow other related articles on the PHP Chinese website!