How to set uneven coordinate axis scale in Excel

#How to set uneven coordinate axis scale in excel?

1. Add auxiliary columns

Recommendation: "excel tutorial"

1. Click on the chart tool - select data.

2. Add data series.

X-axis series value—that is, the scale value you need

Y-axis series value—is a number of 0 corresponding to the above.

As shown in the picture, if you want to add several scales, there will be several points. These points are scatter plots.

2. Add data labels

3. As shown in the figure, click Set Axis Format - Label Position - None

Remove the original coordinate axis.

4. Select the added point - right click - add data label. Then move the data labels to the axes.

#5. Beautify the chart.

The above is the detailed content of How to set uneven coordinate axis scale in Excel. For more information, please follow other related articles on the PHP Chinese website!