The quickest way to change an axis in Excel

Right-click directly on the axis numbers or labels you want to change, then select Format Axis from the menu that appears. A panel opens on the right side of your screen with options to adjust the scale, add labels, change the number format, or rotate text. This is the fastest route for most axis changes.

If you're working with a newer version of Excel (2016 and later), you'll see a panel with icons at the top—click the one that looks like a bar chart to access axis-specific settings. Older versions show tabs like Axis Options and Number across the top of the dialog box instead.

The axis you're changing depends on which one you clicked. In a standard chart, the horizontal axis is called the category axis (or X-axis), and the vertical axis is the value axis (or Y-axis). Click the one you need to modify.

Key Takeaways

  • Right-click the axis itself—not the chart background or data bars—and select Format Axis to open the editing panel.
  • The value axis (vertical) controls the numeric scale and range; the category axis (horizontal) controls labels and their spacing.
  • You can set a fixed minimum and maximum value to zoom in on a specific range or prevent the scale from shifting when data changes.
  • Axis labels can be rotated, resized, or reformatted to show currency, percentages, or fewer decimal places without changing the underlying data.

Changing the numeric scale on the value axis

The value axis (the vertical one in most charts) shows the numbers your data represents. To change how high or low it goes, right-click those numbers and select Format Axis. Look for the section labeled Axis Options or the icon that looks like a bar chart.

You'll see fields for Minimum and Maximum. By default, Excel sets these automatically based on your data. If you want to zoom in on a smaller range—say, showing only 0 to 100 instead of 0 to 500—type the numbers you want. Leave either field blank if you want Excel to calculate it automatically.

You can also adjust the Major unit, which controls the spacing between the numbered tick marks. If your axis shows marks at every 10 units but you'd rather see them at every 25, change that number here. This makes the chart easier to read without changing any data.

Rotating or reformatting axis labels

Axis labels often overlap or run off the edge, especially on the category axis (horizontal). Right-click the labels and select Format Axis, then look for Text Options or Alignment.

To rotate text, find the Rotation field and enter a number between -90 and 90 degrees. A 45-degree angle often fixes overlapping labels without making them unreadable. You can also change the font size or color here if the labels are too small or hard to see.

If your axis shows numbers you want to display differently—like showing 1000 as "1K" or adding a dollar sign—go to the Number tab or section. Choose a category like Currency or Percentage, and Excel reformats the display without changing the actual values in your spreadsheet.

Changing category axis labels and order

The category axis (horizontal in most charts) shows the names or dates of your data groups. If you want to change the order they appear in, you'll need to rearrange the data in your spreadsheet itself—the axis just reflects what's there.

However, you can change how the labels look. Right-click the category axis and select Format Axis. Under Axis Options, you'll find Label Position, which controls whether labels sit below the axis, above it, or at the tick marks. You can also set Interval between labels to show every label, every other one, or every fifth one if your chart is crowded.

To reverse the order (so categories run right to left instead of left to right), check the box for Categories in reverse order in the same panel.

Removing or hiding an axis

If you don't want an axis to show at all, right-click it and select Delete or Format Axis, then look for an option to hide or turn it off. In newer Excel versions, this is usually a checkbox labeled Show axis or similar.

Hiding an axis removes the numbers and labels but keeps the chart itself. This is useful if you're creating a straightforward visual and don't need the scale to be visible. The data is still there—you're just not displaying the reference numbers.

Using the axis title to label what the axis measures

An axis title is different from axis labels. Labels are the individual numbers or categories; the title is a single phrase that describes what the whole axis represents (like "Sales in Dollars" or "Month").

To add or edit an axis title, click the chart to select it, then look for a Chart Elements button (a plus sign) in the top right corner. Click it and check the box next to Axis Titles. A text box appears on each axis; click it and type your title.

To format the title—change its font, size, or angle—right-click the title text itself and select Format Axis Title. This opens the same panel you use for axis labels, so you can rotate it or change the font size if needed.

Fixing common axis problems

If your axis scale jumps unexpectedly when you add new data, it's because Excel recalculates the automatic minimum and maximum. Fix this by setting fixed values: right-click the axis, select Format Axis, and enter specific numbers in the Minimum and Maximum fields. Now the scale stays put even if your data changes.

If numbers on the value axis are hard to read because they're too close together, increase the Major unit to show fewer tick marks, or rotate the category axis labels 45 degrees. If the axis label text is cut off at the edge of the chart, make the chart wider or reduce the font size of the labels.

If you accidentally deleted an axis and can't get it back, click the chart and look for the Chart Elements button (plus sign). Check the box next to Axes to restore it.

Frequently Asked Questions

How do I make the axis start at a number other than zero?

Right-click the value axis (the one with numbers), select Format Axis, and enter a different number in the Minimum field. For example, if your data ranges from 50 to 100, you can set the minimum to 50 so the axis doesn't waste space showing 0 to 50. Be aware this can make small differences look larger.

Can I have two different scales on the same chart?

Yes, if you have two data series that measure different things (like revenue and customer count). Right-click one of the data series (the bars or line itself, not the axis), select Format Data Series, and choose Secondary Axis. A second axis appears on the right side with its own scale. This is useful when one series has much larger numbers than the other.

Why are my axis labels overlapping?

Your chart is too narrow or your labels are too long. Try rotating the labels 45 degrees (right-click the axis, Format Axis, set Rotation to 45), making the chart wider, or reducing the font size. You can also show every other label by adjusting the Interval between labels setting.

How do I change the axis from linear to logarithmic?

Right-click the value axis, select Format Axis, and look for Axis Options. Check the box for Logarithmic scale. This compresses large ranges of numbers so they're easier to compare. Use this when your data spans several orders of magnitude—for example, comparing countries with populations from 1 million to 1 billion.

What's the difference between the category axis and the value axis?

The category axis (usually horizontal) shows the groups or labels in your data—like months, product names, or regions. The value axis (usually vertical) shows the numbers being measured—like sales amounts or temperatures. You change them differently because they control different things.