Home >Topics >excel >How to set x-axis and y-axis in excel chart

How to set x-axis and y-axis in excel chart

coldplay.xixi
coldplay.xixiOriginal
2021-01-15 11:19:35121354browse

How to set the x-axis and y-axis in excel chart: first open excel and select the table to insert, click on all charts x, y scatter plot; then select a style to insert, click on the chart element; finally check the coordinate axis and coordinate title, and edit the title.

How to set x-axis and y-axis in excel chart

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

How to set the x-axis and y-axis in excel chart:

1. Open the excel table, select the data in the table-insert;

How to set x-axis and y-axis in excel chart

2. Next, click on all charts;

How to set x-axis and y-axis in excel chart

3. Then, click on the x, y scatter chart;

How to set x-axis and y-axis in excel chart

4. Next, select a style;

How to set x-axis and y-axis in excel chart

5. Then, click Insert;

How to set x-axis and y-axis in excel chart

6. After the insertion is successful, click on the chart element next to it;

How to set x-axis and y-axis in excel chart

7. Next, check the coordinate axis and title;

How to set x-axis and y-axis in excel chart

8. Next, edit the title and set it to the x-axis and y-axis, as shown below;

How to set x-axis and y-axis in excel chart

Related learning recommendations : excel tutorial

The above is the detailed content of How to set x-axis and y-axis in excel chart. 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