The quickest way to change Y-axis values

Right-click directly on the Y-axis numbers themselves (the vertical axis on the left side of your chart), then select Format Axis. A panel opens on the right side of your screen. Under the Axis Options tab, you can change the minimum value, maximum value, and the spacing between gridlines. Type in your new numbers and the chart updates when ready.

If you do not see the Format Axis panel, make sure you clicked on the axis numbers, not the axis line or the chart background. The axis numbers are the small text labels like "0", "10", "20" running up the left edge.

Key Takeaways

  • Right-click the Y-axis numbers and choose Format Axis to open the settings panel where you control the minimum, maximum, and interval values.
  • The Axis Options tab lets you set exact starting and ending values, which is useful when you want your chart to begin at a number other than zero.
  • Changing the interval (the gap between each gridline and label) makes your chart easier to read without altering the data itself.
  • Excel can automatically calculate these values, but you can override the automatic settings by typing your own numbers into each field.

Setting minimum and maximum values

The Minimum field controls where the Y-axis starts, and the Maximum field controls where it ends. By default, Excel chooses these automatically based on your data. If your data ranges from 5 to 95, Excel might set the minimum to 0 and the maximum to 100 to give some breathing room.

To change these: open the Format Axis panel (right-click the Y-axis numbers, select Format Axis), then look for the Minimum and Maximum fields under Axis Options. Uncheck the "Auto" box next to each one if it is checked, then type your preferred number. For example, if you want your chart to zoom in and show only values between 20 and 80, type 20 in Minimum and 80 in Maximum.

This is especially useful when comparing multiple charts side by side — setting the same axis range on both charts makes the visual comparison fair and clear.

Adjusting the interval between axis labels

The interval is the spacing between each number label on the Y-axis. If your axis shows "0, 10, 20, 30, 40", the interval is 10. If it shows "0, 5, 10, 15, 20", the interval is 5.

In the Format Axis panel, find the Major Unit field (this controls the main labels and gridlines) and the Minor Unit field (this controls smaller gridlines in between). Uncheck "Auto" next to Major Unit, then type the interval you want. For a chart showing sales data from 0 to 1000, you might set Major Unit to 100 so the labels read "0, 100, 200, 300" and so on.

Minor Unit creates finer gridlines without adding labels. If you set Major Unit to 100 and Minor Unit to 20, you will see a thin gridline every 20 units but labels only every 100 units. This keeps the chart readable without cluttering it.

Changing axis labels to percentages or currency

You can format the Y-axis numbers to display as currency, percentages, or decimals without changing the actual data. In the Format Axis panel, look for the Number tab (not Axis Options — this is a separate tab). Click the dropdown under Category and choose your format: Currency, Percentage, Number, or others.

If you choose Currency, you can pick your currency symbol (like $ or €) and how many decimal places to show. If you choose Percentage, Excel multiplies each value by 100 and adds the % symbol. The underlying data stays the same — only the display changes.

Reversing the Y-axis direction

By default, the Y-axis increases from bottom to top (0 at the bottom, higher numbers toward the top). Some charts look better with the axis reversed, so higher numbers appear at the bottom.

In the Format Axis panel under Axis Options, check the box labeled Values in reverse order. The axis when ready flips. This is common in charts showing rankings (where rank 1 should appear at the top) or in some scientific visualizations.

Fixing a chart when the axis values look wrong

If your Y-axis suddenly shows unexpected numbers or huge jumps between labels, the automatic settings may have recalculated based on new data. Right-click the Y-axis and select Format Axis, then check whether the Minimum, Maximum, and Major Unit fields still have "Auto" checked. If they do, Excel is choosing the values for you.

You have two choices: either accept Excel's automatic choice (which usually works well), or uncheck "Auto" and set your own values. If you set custom values and later add new data that falls outside that range, the axis will not expand automatically — you will need to adjust the Maximum field manually.

Another common issue: if your chart shows only a tiny portion of the data clustered at the bottom, your Minimum value is probably set too high. Lower it or switch it back to Auto.

Frequently Asked Questions

Can I change the Y-axis values without opening the Format Axis panel?

No, the Format Axis panel is the only way to set specific minimum, maximum, and interval values. You cannot drag the axis numbers to new positions or edit them directly like you would edit a cell. The panel is the standard method across all Excel versions.

What happens if I set a minimum value higher than my actual data?

Your data will still plot correctly, but it will appear near the bottom of the chart because the axis starts above the data range. For example, if your data is 5 to 50 but you set Minimum to 100, the data points will cluster at the very bottom. This is usually a mistake, but sometimes it is intentional for visual comparison.

Do changes to the Y-axis affect the underlying data in my spreadsheet?

No. Changing axis values only changes how the chart displays the data. Your original numbers in the cells remain unchanged. You can adjust the axis back and forth without losing anything.

Why does my Y-axis show decimal numbers when I only have whole numbers in my data?

Excel's automatic settings sometimes create intervals that result in decimal labels for clarity. If you prefer whole numbers only, open Format Axis, uncheck Auto for Major Unit, and set it to a whole number like 5 or 10 instead of letting Excel choose.

Can I have different Y-axis ranges on two charts in the same spreadsheet?

Yes, each chart has its own independent axis settings. Right-click the Y-axis on one chart and set its range, then right-click the Y-axis on the other chart and set a different range. The changes explore only to the chart you are working on.