The fastest way to change an axis in Excel

Right-click the axis itself — the numbers or labels running along the bottom or left side of your chart — and select Format Axis. A panel opens on the right side of your screen with options to change the minimum and maximum values, the interval between tick marks, the number format, and the text orientation. This is the direct route for most axis changes.

If you need to change axis labels instead of the scale, right-click the axis and choose Edit Axis Labels. Excel will highlight the cells your chart is pulling from, and you can edit them there. The chart updates as soon as you press Enter.

For a chart that is not responding to right-click, click once on the chart to select it, then click once more on the specific axis you want to change. The axis will show selection handles at each end.

Key Takeaways

  • Right-click the axis numbers or labels directly and select Format Axis to open the full range of axis settings in a side panel.
  • Change the minimum and maximum values to zoom in on a specific range of your data, or adjust the interval to show fewer or more tick marks.
  • Edit Axis Labels lets you change the text that appears on the axis without altering the underlying data.
  • A secondary axis is useful when your chart compares two data series with very different scales, such as revenue in thousands and item count in single digits.

Changing the minimum and maximum values

The minimum and maximum fields in the Format Axis panel control what range of numbers your axis displays. By default, Excel sets these automatically based on your data. If your data ranges from 50 to 500 but you want the axis to start at 0, change the minimum to 0. If you want to zoom in on a narrow band — say, 200 to 300 — set those as your min and max.

To change these values, right-click the axis and select Format Axis. In the panel that opens, look for the Bounds section. You will see fields labeled Minimum and Maximum. Type the numbers you want and press Enter. The chart redraws when ready.

If you leave these fields blank or set them to Auto, Excel recalculates them every time your data changes. This is useful for live dashboards but can make it hard to compare charts side by side if the scales keep shifting.

Adjusting tick marks and gridlines

Tick marks are the small lines that cross the axis. The space between them is called the interval or major unit. By default, Excel picks an interval it thinks looks clean — often 10, 50, 100, or 500 depending on your data range. If your axis shows too many labels and they overlap, increase the interval. If you need more detail, decrease it.

In the Format Axis panel, find the Units section and look for Major. Type a new number — for example, 25 instead of 50 — and the tick marks and labels will space themselves accordingly. You can also set a Minor unit, which adds smaller tick marks between the major ones without adding labels.

Gridlines are the faint lines that run across the chart background, aligned with the tick marks. To show or hide them, click the chart, then go to the Chart Design tab at the top. Click Add Chart Element, hover over Gridlines, and choose the style you want.

Changing number format and decimal places

If your axis shows numbers like 1000000 and you want them to display as 1M, or if you want to add a currency symbol or change decimal places, the Number section of the Format Axis panel handles this. Right-click the axis, select Format Axis, and look for the Number category on the left side of the panel.

Choose a category from the list — Currency, Percentage, Number, or others — and the options below will change. For Currency, you can pick the symbol and decimal places. For Number, you can set how many decimal places to show. For Percentage, Excel will multiply your values by 100 and add the % symbol.

If you want a custom format — for example, showing values in thousands with a K suffix — you can type a format code in the Format Code field. Common codes include 0,"K" for thousands and #,##0.00 for numbers with commas and two decimal places.

Adding a secondary axis for two data series with different scales

When you have two data series that use very different units or ranges — such as monthly revenue in the thousands and customer count in the hundreds — a single axis makes one series hard to read. A secondary axis gives the second series its own scale on the right side of the chart.

To add a secondary axis, click the chart to select it. Right-click the data series you want to move to the secondary axis — the line or bars themselves, not the axis. Select Format Data Series. In the panel that opens, find Series Options and choose Secondary Axis. A new axis appears on the right, scaled to fit that series.

You can then format the secondary axis the same way as the primary one: right-click it, select Format Axis, and adjust the minimum, maximum, number format, and labels. Both axes will now be visible, each scaled to its own data.

Rotating or angling axis labels

When axis labels are long — such as product names or dates — they often overlap and become unreadable. Rotating them at an angle saves space and improves clarity. Right-click the axis labels and select Format Axis. In the panel, find the Text Options section and look for Alignment.

You will see a dial or a field labeled Custom Angle. Click and drag the dial to rotate the text, or type a number directly. Common angles are 45 degrees for a diagonal tilt or 90 degrees for vertical text. After you set the angle, click elsewhere on the chart to explore it.

If labels still overlap after rotating, you can also increase the space between the axis and the chart area by right-clicking the axis and adjusting the Label Distance setting in the Format Axis panel.

Switching between category and value axes

In a column or bar chart, the horizontal axis usually shows categories (product names, months, regions) and the vertical axis shows values (sales, units, percentages). Excel assigns these automatically based on how your data is arranged. If your chart has them backwards, you can swap them without rebuilding the chart.

Click the chart to select it. Go to the Chart Design tab at the top and click Select Data. In the dialog that opens, you will see your data range and series listed. Look for buttons or options to swap the axes or change which column is treated as categories. After you make the change, click OK and the chart redraws with the axes swapped.

Alternatively, you can right-click the chart and select Edit Data to open the data range editor, which shows you exactly which cells are being used for categories and which for values. Adjusting the range there will change which axis displays which data.

Frequently Asked Questions

Why does my axis not show all the numbers I expect?

Excel is likely hiding some labels to avoid overlap. Right-click the axis, select Format Axis, and in the Labels section, change the Interval Between Labels from Auto to 1. This forces every tick mark to show a label. If labels still overlap, rotate them or increase the chart size.

Can I use text labels instead of numbers on an axis?

Yes. The horizontal axis in a column or bar chart is usually a category axis and can display text. The vertical axis is a value axis and must show numbers. If you want text on the vertical axis, you would need to restructure your data or use a different chart type, such as a scatter plot with custom labels.

How do I remove an axis entirely?

Click the chart, go to the Chart Design tab, click Add Chart Element, hover over Axes, and select None. This hides both axes. You can also right-click a single axis and select Delete to remove just that one, though this is less common.

What does "Auto" mean in the Format Axis panel?

Auto means Excel is calculating that setting for you based on your data. When you type a specific number, you override Excel's choice. If you want to go back to Auto, delete the number you typed and leave the field blank, or click the Auto checkbox if one is visible.

Can I have different axis scales in two charts on the same sheet?

Yes. Each chart is independent. Format one chart's axis, then click elsewhere to deselect it, then click the other chart and format its axis separately. The scales will not affect each other.