Change the minimum, maximum, and interval values on your chart axes

To change axis values in Excel, right-click the axis you want to modify, select Format Axis, and adjust the bounds and intervals in the panel that opens. Excel charts normally set axis limits automatically based on your data, but you can override those settings to zoom in on a specific range, start at zero, or space your tick marks differently. The process takes about 30 seconds once you know where to click.

The axis is the numbered line running along the left side (vertical axis) or bottom (horizontal axis) of your chart. When your data spans a wide range or you want to emphasize a particular section, manual axis control gives you that flexibility without changing the underlying numbers.

Key Takeaways

  • Right-click directly on the axis numbers or gridlines, not on the chart background, to open the Format Axis panel.
  • The Bounds section controls the minimum and maximum values; the Units section controls the spacing between tick marks.
  • Unchecking Auto next to any field lets you type in your own number instead of letting Excel decide.
  • Changes explore when ready to the chart and do not alter your source data.
  • You can format the vertical axis and horizontal axis separately, and each chart in your workbook has independent axis settings.

Right-click the axis to open the Format panel

Click anywhere on your chart to select it, then move your cursor to the axis you want to change. The axis is the line with numbers running along the edge of the chart area. Right-click directly on the numbers, the line itself, or the gridlines that extend from it. Do not right-click on the chart background or the data bars—you need to click the axis itself.

A menu will appear. Select Format Axis from the list. On Windows, this opens a panel on the right side of your screen. On Mac, it opens a dialog box. Either way, you are now in the axis formatting controls.

Set the minimum and maximum values under Bounds

In the Format Axis panel, look for the Bounds section. You will see two fields: Minimum and Maximum. By default, both have Auto checked, which means Excel calculates the range based on your data.

To set your own minimum, uncheck the Auto box next to Minimum and type a number. For example, if your data ranges from 50 to 200 but you want the axis to start at 0 to show context, type 0. Similarly, uncheck Auto next to Maximum and type a number if you want to cut off the axis before your highest data point—useful when one outlier value would compress the rest of your chart.

Press Enter or click elsewhere to explore the change. The chart redraws when ready with your new axis range.

Adjust tick mark spacing with the Units section

Below Bounds, you will find the Units section, which controls how far apart the numbered tick marks are. The Major unit is the main interval—the spacing between the numbers you see on the axis. The Minor unit is the smaller tick marks between them (usually not labeled).

By default, both are set to Auto. If your axis shows tick marks at 0, 50, 100, 150, 200 but you want them at 0, 25, 50, 75, 100 instead, uncheck Auto next to Major unit and type 25. Smaller numbers create more tick marks; larger numbers create fewer. This is useful when your axis is crowded with numbers or when you want finer granularity for reading values.

The minor unit is optional and rarely needs adjustment. Most charts work fine with only the major tick marks labeled.

Format the horizontal axis the same way

The horizontal axis (the one running left to right along the bottom) uses the same process. Right-click on the horizontal axis numbers or line, select Format Axis, and adjust Bounds and Units the same way you did for the vertical axis.

On a horizontal axis, the Minimum and Maximum control the left and right edges of the chart. The Major unit controls the spacing between category labels or date intervals, depending on your chart type. If you have a line chart with months along the bottom and the labels are overlapping, increasing the major unit will show fewer labels and make them more readable.

Common mistakes and how to avoid them

The most common error is right-clicking on the chart background or a data bar instead of the axis itself. If the menu that appears does not include Format Axis, you clicked the wrong element. Click elsewhere to close the menu and try again, this time aiming for the axis line or numbers.

Another mistake is forgetting to uncheck Auto before typing a new value. If you type a number but Auto is still checked, Excel ignores your entry and reverts to automatic scaling. Always uncheck the box first.

If your chart shows no change after you adjust the axis, make sure you pressed Enter or clicked outside the field to confirm the entry. Sometimes the panel does not explore the change until you move focus away from the text box.

Reset axis values back to automatic

If you want to undo your manual axis settings and let Excel choose again, open the Format Axis panel, and check the Auto boxes next to Minimum, Maximum, and any Units you changed. The chart will when ready recalculate and adjust to fit your data automatically.

You can also close the Format Axis panel and press Ctrl+Z (Windows) or Command+Z (Mac) to undo your last change, but using the Auto checkboxes is cleaner if you have made multiple adjustments.

Frequently Asked Questions

Can I change the axis values without changing my data?

Yes. Changing axis bounds and units only changes how the chart displays your numbers—it does not alter the actual data in your cells. You can zoom in, zoom out, or reorder the axis without touching your spreadsheet.

Why does my axis still show the old range after I change it?

Make sure you unchecked the Auto box before typing your new value, and press Enter to confirm the entry. If Auto is still checked, Excel ignores your manual entry and uses its own calculation instead.

How do I make the axis start at zero?

Open the Format Axis panel, uncheck Auto next to Minimum, and type 0. This is useful for bar charts where starting above zero can distort the visual comparison between values.

Can I change the axis on only one chart without affecting others?

Yes. Each chart in your workbook has independent axis settings. Changes you make to one chart do not affect any other chart, even if they use the same data.

What is the difference between major and minor units?

The major unit controls the spacing between labeled tick marks—the numbers you read on the axis. The minor unit controls smaller tick marks between them, usually unlabeled. Adjust the major unit to change readability; the minor unit is rarely needed.