The quickest way to change an axis in Excel

To change an axis in Excel, right-click directly on the axis numbers or labels you want to modify, then select Format Axis from the menu. A panel opens on the right side of your screen where you can adjust the minimum and maximum values, change the scale, add or remove gridlines, or swap which axis displays your data. If you want to swap the axes entirely — putting categories on the vertical axis instead of the horizontal one — you need to edit the chart data range instead, which takes a few more steps.

The method depends on what you're trying to change. Adjusting the range of numbers that appear is different from relabeling the axis, which is different from swapping axes. This guide covers each one.

Key Takeaways

  • Right-click the axis itself (the numbers or labels, not the chart background) and choose Format Axis to adjust scale, minimum, maximum, and number formatting.
  • To change axis labels or titles, double-click the axis title text box directly, or right-click the axis and select Edit Axis Title.
  • Swapping which axis shows categories versus values requires you to edit the chart's data range through the Select Data option, not through axis formatting.
  • Changes you make to one chart do not affect other charts in your workbook — each chart's axes are independent.

Adjusting the minimum, maximum, and scale of an axis

When you right-click an axis and open Format Axis, the panel that appears has several tabs. The Axis Options tab is where you control the range of numbers displayed. By default, Excel sets the minimum and maximum automatically based on your data — if your smallest value is 5 and your largest is 87, the axis might run from 0 to 100.

To change this, look for the Bounds section. Uncheck the Auto box next to Minimum, then type a new starting number. Do the same for Maximum. If you want the axis to jump by different intervals — say, every 10 instead of every 20 — find the Units section and uncheck Auto next to Major, then enter your preferred interval. These changes take effect when ready on your chart.

If your axis shows dates or times, the same panel lets you change the date format or time interval. If it shows percentages or currency, you can adjust the number format in the Number tab of the same panel.

Changing axis titles and labels

The axis title is the text that describes what the axis represents — for example, "Sales Revenue" or "Month". To change it, double-click the title text directly on the chart. A text box appears around it and you can type a new title. Press Enter when you're done.

If there is no axis title yet, right-click the axis itself and look for Add Axis Title or Edit Axis Title (the exact wording varies by Excel version). Click it, and a text box appears where you can type.

The axis labels are the individual numbers or category names that appear along the axis — like "January," "February," "March" on a horizontal axis, or "0," "10," "20" on a vertical one. These labels come from your data range, so changing them means editing your source data, not the chart itself. If you want different labels, go back to your spreadsheet, find the cells that feed the chart, and change them there.

Swapping the horizontal and vertical axes

If you want to flip your chart so that categories run vertically instead of horizontally (or vice versa), you cannot do it through the axis formatting panel. Instead, right-click anywhere on the chart background and select Select Data. A dialog box opens showing which cells are your categories and which are your values.

In most charts, the categories appear on the horizontal axis and the values on the vertical axis. To swap them, you need to restructure which data Excel treats as categories and which as values. This is chart-type dependent — a bar chart (horizontal bars) already has categories on the vertical axis, while a column chart (vertical bars) has them on the horizontal axis. If you want to convert a column chart to a bar chart, right-click the chart, select Change Chart Type, and choose Bar.

Adding or removing gridlines on an axis

Gridlines are the faint lines that run across the chart to help you read values. They are tied to an axis — usually the vertical one. To add or remove them, right-click the axis and look for Add Gridlines or Delete Gridlines. In some Excel versions, you instead right-click the chart background, select Add Chart Element, then Gridlines, and choose which axis should display them.

You can also format gridlines — make them darker, dashed, or thicker — by right-clicking a gridline itself and selecting Format Gridlines. This opens the same formatting panel where you can change color, width, and style.

Reversing the direction of an axis

By default, the horizontal axis runs left to right and the vertical axis runs bottom to top. If you want to reverse this — so the vertical axis runs top to bottom, for example — right-click the axis and open Format Axis. In the Axis Options tab, look for a checkbox labeled Categories in reverse order or Values in reverse order. Check it, and the axis direction flips.

This is useful when you want to display data in a different order — for instance, showing the highest values at the top of a bar chart instead of at the bottom.

Changing the axis type (category, value, or date)

Excel usually detects the axis type automatically. A column of months becomes a date axis, a column of numbers becomes a value axis, and text becomes a category axis. If Excel guesses wrong, you can override it. Right-click the axis and open Format Axis. In the Axis Options tab, look for Axis Type and choose from Automatic, Text, Date, or Value.

Changing the axis type affects how Excel spaces the data points and labels. A date axis, for example, spaces points according to the actual time between dates, while a category axis spaces them evenly regardless of the date gap. If your dates are unevenly spaced and you want them to appear that way on the chart, use a date axis. If you want them evenly spaced, use a category axis.

Frequently Asked Questions

How do I change the axis scale to show negative numbers?

Right-click the axis, select Format Axis, and in the Bounds section, set the Minimum to a negative number — for example, -50. The axis will now display both negative and positive values. Make sure your data actually contains negative numbers, or the axis will display them but your chart will appear empty below zero.

Can I have different scales on the same chart?

Yes, but only if you have two different value axes. Create a chart with two data series, right-click one series, select Change Series Chart Type, and assign it to a secondary axis. Then right-click each axis separately and set different scales. This is useful when comparing data with very different ranges — like revenue in thousands and customer count in hundreds.

Why does my axis show weird numbers like 2.5E+08?

Excel is displaying numbers in scientific notation because they are very large. Right-click the axis, select Format Axis, go to the Number tab, and change the category from Scientific to Number. You can also reduce decimal places if the numbers are too long to read.

How do I remove an axis entirely?

Right-click the axis and select Delete Axis. The axis line, numbers, and title disappear, though the chart itself remains. This is rarely useful for the horizontal axis (you lose your category labels), but sometimes makes sense for the vertical axis if you only want to show gridlines.

Do changes to the axis affect the original data in my spreadsheet?

No. Changing an axis only changes how the chart displays the data. Your spreadsheet cells remain unchanged. If you want to permanently change the data itself, you must edit the cells directly.