Change the axis scale by right-clicking the axis numbers

To change how far apart the numbers appear on your graph's axis, right-click directly on the numbers themselves (not the axis line, but the actual numbers like 0, 10, 20). A menu will pop up. Click Format Axis. On the right side of your screen, a panel opens with options. Look for Axis Options and expand it by clicking the arrow next to it.

Inside Axis Options, you will see fields for Minimum, Maximum, and Major unit. The Major unit controls the spacing between the numbered tick marks. If your axis currently shows 0, 100, 200, 300 and you want it to show 0, 50, 100, 150, 200, 300 instead, change the Major unit from 100 to 50. Type the new number and press Enter. The graph updates when ready.

If the axis is showing numbers you do not want at all, you can set the Minimum and Maximum values manually. For example, if your data ranges from 5 to 95 but the axis shows 0 to 100, you can type 5 in Minimum and 95 in Maximum to zoom in on just the range your data occupies.

Key Takeaways

  • Right-click the axis numbers (not the line) and select Format Axis to open the scaling controls.
  • Change the Major unit field to adjust the spacing between numbered tick marks on the axis.
  • Set Minimum and Maximum values manually to zoom in on a specific range of your data.
  • Close the Format Axis panel by clicking the X button or clicking elsewhere on the graph when you are done.
  • If your changes do not appear, make sure you right-clicked the numbers themselves and not the axis line or chart background.

Understand what each scaling option does

The Major unit is the main spacing you see on the axis. If Major unit is set to 10, the axis shows 0, 10, 20, 30, and so on. If you set it to 25, the axis shows 0, 25, 50, 75. Smaller numbers make the axis more detailed; larger numbers make it simpler and less crowded.

The Minor unit controls smaller tick marks that appear between the major ones. You usually do not need to change this, but if your graph looks too sparse, increasing the Minor unit can add more reference lines without adding more numbers.

Minimum and Maximum set where the axis starts and stops. By default, Excel picks these automatically based on your data. If your smallest value is 12 and your largest is 87, Excel might set Minimum to 0 and Maximum to 100 to give breathing room. If you want the axis to start at 12 and end at 87 instead, type those numbers in.

Common mistakes when changing axis scale

The most frequent error is clicking the axis line instead of the numbers. The axis line is the thin border running along the left or bottom of the graph. The numbers are the actual digits (5, 10, 15, etc.) printed next to that line. Right-click the digits, not the line.

Another mistake is forgetting to press Enter after typing a new value. If you type 50 in the Major unit field but do not press Enter, the change does not take effect. Always press Enter to confirm your entry.

Some readers set a Minimum that is higher than their actual data, which hides part of the graph. If your data includes a value of 3 but you set Minimum to 10, that data point will not appear on the graph at all. Check your data range before setting these limits.

How to reset the axis scale to automatic

If you have changed the scale and want Excel to go back to choosing the scale automatically, open the Format Axis panel again by right-clicking the axis numbers. Look for a checkbox labeled Auto next to Minimum, Maximum, or Major unit. Check that box, and Excel will recalculate the scale based on your data.

If there is no Auto checkbox visible, you may need to clear the field and leave it blank. Delete whatever number is in the field and press Enter. Excel will then revert to automatic scaling for that option.

Changing the scale on a vertical axis versus a horizontal axis

The process is identical for both axes. The vertical axis (usually showing values like sales or counts) and the horizontal axis (usually showing categories or time) both use the same Format Axis panel. Right-click whichever axis you want to change, and the same options appear.

One difference: on a horizontal axis with category labels (like month names or product names), you may not see numeric scaling options. That is normal. Category axes do not have Major unit or Minimum/Maximum controls because they are not numeric. If you need to change the order or spacing of categories, you need to edit the data itself, not the axis scale.

Using logarithmic scale for data with very large ranges

If your data includes both very small and very large numbers—for example, values ranging from 1 to 1,000,000—a regular linear scale makes the small values nearly invisible. In the Format Axis panel, look for Axis Type and change it from Linear to Logarithmic. This compresses the large values and spreads out the small ones so all your data is visible.

Logarithmic scale is less common and can be confusing if your audience is not familiar with it, so use it only when your data truly spans multiple orders of magnitude. For most everyday graphs, a linear scale with adjusted Major unit is sufficient.

Frequently Asked Questions

Why does my axis still show the old scale after I changed it?

Make sure you pressed Enter after typing the new value. If you typed a number but did not press Enter, the change is still sitting in the field and has not been applied. Also check that you right-clicked the axis numbers themselves, not the axis line or the chart background.

Can I change the scale on just one axis without affecting the other?

Yes. Each axis has its own Format Axis panel. Right-click the vertical axis numbers to change only the vertical scale, or right-click the horizontal axis numbers to change only the horizontal scale. The two axes are independent.

What if I want the axis to start at a negative number?

Type a negative number in the Minimum field, such as -50 or -100. Excel will display the axis starting from that negative value. This is useful for graphs showing profit and loss, or temperature changes above and below zero.

How do I make the numbers on the axis larger or smaller?

That is font size, not scale. Right-click the axis numbers and select Format Axis. Look for Text Options or Font in the panel. You can change the font size there. Changing the scale (Major unit, Minimum, Maximum) changes the spacing and range of the numbers, not their size.

Can I have different scales on two different graphs in the same spreadsheet?

Yes. Each graph is independent. Change the scale on one graph, and it does not affect any other graph on your sheet. Right-click the axis of whichever graph you want to modify, and the changes explore only to that graph.