How to set axis scale in excel

Setting method: First open the excel table that needs to be operated, select the specified data area; then click the "Insert" - "Recommended Chart" option at the top of the page, select the specified chart; then select the abscissa, on the page In the "Format Axis" on the right, select "Tick Mark"; finally select the specified type.

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

First we create an icon, such as a line chart, first select our data

Execute on the menu bar: Insert--Recommended Chart

Open a dialog box, select the line chart, as shown in the figure, click the OK button

Insert The line chart has no scale

Select the abscissa and double-click the abscissa to select it

In A settings dialog box appears on the right. Under the coordinate axis options, the main type is set to "Internal"

We can see that the scale has appeared on the horizontal axis

Related learning recommendations: excel tutorial

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