Home >Topics >excel >How to change the abscissa number in Excel to what you set yourself

How to change the abscissa number in Excel to what you set yourself

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-04-28 16:17:4550871browse

Setting method: First open the excel table that needs to be operated, use the right mouse button to click the abscissa of the chart; then click "Select Data" in the pop-up right mouse button menu and select "Edit"; finally select the previous column OK value, click "OK".

How to change the abscissa number in Excel to what you set yourself

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open Excel.

How to change the abscissa number in Excel to what you set yourself

Right-click the abscissa of the chart, and then click Select Data.

How to change the abscissa number in Excel to what you set yourself

After selecting the data source, click Edit.

How to change the abscissa number in Excel to what you set yourself

After clicking Edit, select the listed value, and then click OK.

How to change the abscissa number in Excel to what you set yourself

#After clicking OK, you can change the abscissa of the chart to the value you set.

How to change the abscissa number in Excel to what you set yourself

Related learning recommendations: excel tutorial

The above is the detailed content of How to change the abscissa number in Excel to what you set yourself. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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