Detailed tutorial on displaying coordinate axes and grid lines in excel 2010

Time: 2020-02-03Source: Huajun Software TutorialAuthor: Qiuye PPT

Excel2010 software has many advantages and is very popular among office partners. Today I will share a detailed tutorial on displaying coordinate axes and grid lines in Excel2010. Let’s take a look at it. I believe it will be helpful.

Open excel2010 and see a chart with the grid lines and vertical (value) axis removed.

How to display coordinate axes and grid lines in Excel 2010?

Switch to the "Layout" option of "Chart Tools", click the "Axis" button, and select the "Show Default Axis" option of "Main Vertical Axis" from the drop-down menu.

How to display coordinate axes and grid lines in Excel 2010?

Then click "Gridlines" and select the "Main Gridlines" option in "Main Horizontal Gridlines" in the drop-down menu.

How to display coordinate axes and grid lines in Excel 2010?

Return to the Excel table and you can see that the chart has changed.

How to display coordinate axes and grid lines in Excel 2010?

For those of you who have just come into contact with the excel2010 software, after learning the detailed operation of displaying coordinate axes and grid lines in excel2010 in this article, do you think it will be easier to operate it in the future?

Related articles更多>>

Popular recommendations