Home > Topics > excel > How to set uneven coordinate axis scale in Excel

How to set uneven coordinate axis scale in Excel

藏色散人
Release: 2020-02-20 09:23:45
Original
31722 people have browsed it

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.

How to set uneven coordinate axis scale in Excel

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.

How to set uneven coordinate axis scale in Excel

2. Add data labels

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

Remove the original coordinate axis.

How to set uneven coordinate axis scale in Excel

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

How to set uneven coordinate axis scale in Excel

#5. Beautify the chart.

How to set uneven coordinate axis scale in Excel

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!

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template