Excel Chart: Move the Horizontal Axis to the Bottom

To move an Excel chart’s horizontal axis to the bottom, select the vertical value axis, open Format Axis, and set Horizontal axis crosses to the chart’s minimum value. If the axis line is already at the bottom but its labels are at the top, format the horizontal axis and set Label Position to Low instead.

Why the horizontal axis appears in the middle

In a column or line chart, the horizontal axis is usually drawn where the vertical value axis crosses it. When all plotted values are positive, that crossing is typically at the bottom of the plot area. When the data includes negative and positive values, Excel often places the horizontal axis at zero, which may be halfway up the chart. That is mathematically useful because zero separates negative values from positive ones, but it can make the chart harder to read when you want the horizontal axis along the lower edge.

Excel also separates an axis line from its labels. The line can cross the plot at zero while category names such as months or product names appear along the bottom, or the line can be at the bottom while the labels remain above it. These are separate settings, so identify which part you want to move before changing the chart.

These instructions apply to Microsoft Excel for Microsoft 365 on Windows. The same axis-crossing options are available in Excel for Mac, though the Format Axis pane may look slightly different. Excel for the web provides basic chart formatting, but if you cannot find the crossing control, open the workbook in the desktop app.

Move the axis line to the bottom

Click the chart, then click the vertical value axis. In a column chart, this is the axis with the numeric scale. If selecting the axis is difficult, use the Chart Format tab’s Current Selection list to choose the value axis.
Right-click the selected axis and choose Format Axis. The Format Axis pane opens at the side of the window.
In Axis Options, find Horizontal axis crosses. This setting controls where the horizontal axis intersects the vertical value axis.
Select Axis value and enter the value at the bottom of the vertical scale. For example, if the vertical axis minimum is -50, enter -50.

The horizontal axis should now cross at the lower edge of the plot area rather than at zero. If the axis does not move all the way down, check the vertical axis minimum: the crossing value must match the minimum bound or be lower than every plotted value.

For example, imagine a chart whose values range from -40 to 80 and whose vertical axis runs from -50 to 100. Setting Horizontal axis crosses to -50 places the horizontal axis at the bottom of that scale. Setting it to 0 leaves it at the zero line. If you later change the vertical axis minimum to -60, update the crossing value to -60 as well.

Keep the axis at the bottom as data changes

A chart’s scale may be set to Auto, which lets Excel choose its minimum and maximum based on the data. If the data changes, Excel may adjust the minimum. A crossing value that was previously the minimum can then sit slightly above the bottom. To keep the horizontal axis precisely at the lower edge, set a fixed minimum bound and use that same number for Horizontal axis crosses.

To set the minimum, select the vertical value axis, open Format Axis, and look under Axis Options for Bounds. Enter a suitable value in Minimum, then enter that same value in the Horizontal axis crosses field. Choose a lower bound that includes the smallest data point and leaves enough space for any intended chart context. A bound that is too high can hide negative values; an unnecessarily low bound can make differences look smaller than they are.

When new data may fall below your chosen minimum, either revisit the bound and crossing value or leave the scale automatic and check the chart after updates. A fixed scale is useful for consistent reporting across multiple charts, but it requires maintenance when the data range changes.

Move category labels without moving the axis line

If your main problem is that category names appear at the top, changing where the horizontal axis crosses may not be the right fix. Select the horizontal axis, open Format Axis, expand Labels, and set Label Position to Low. This places labels along the bottom edge even when the axis line itself remains at zero.

This distinction is especially useful for charts with negative values. Keeping the axis line at zero shows where values change from negative to positive, while placing labels at the bottom prevents category names from overlapping the plotted data. Label Position affects the text, not the position of the axis line, tick marks, or zero crossing.

If labels overlap or are difficult to read after moving them, consider rotating the text, widening the chart, or showing fewer category labels. Those adjustments can improve readability without changing the data scale or implying a different zero point.

How chart type affects the setting

The instructions above suit column, line, and area charts where the horizontal axis represents categories or dates and the vertical axis represents values. In these charts, the vertical value axis includes the Horizontal axis crosses control that determines where the horizontal axis line sits.

A bar chart is oriented differently: its categories run vertically, and its numeric value axis runs horizontally. If a bar chart’s horizontal value axis is not at the bottom, you may be thinking of the vertical category axis or of where the category axis crosses the value axis. The available crossing controls depend on which axis you select. Select the numeric horizontal axis to inspect its bounds, and select the category axis to control where the two axes intersect.

Scatter charts also use numeric values on both axes rather than a category axis. The horizontal axis is controlled through the vertical axis’s crossing setting, while the vertical axis’s position is controlled through the horizontal axis. This can make a scatter chart’s crossing options feel reversed compared with a simple column chart. Select the axis whose crossing setting is named in the Format Axis pane, then confirm which other axis that setting moves.

Common problems and how to fix them

The axis remains at zero: The crossing value may still be 0, or the wrong axis may be selected. Select the vertical value axis and check Horizontal axis crosses.
The axis moved, but labels did not: Set the horizontal axis Label Position to Low. Axis-line placement and label placement are independent.
The axis is close to the bottom but not on it: Match the crossing value to the vertical axis Minimum bound. If the minimum is automatic, it may change when the data changes.
The wrong pane or options appear: You may have selected the plot area, a data series, or the category axis instead of the value axis. Click the numeric scale, or use the Current Selection list on the Chart Format tab.
Some negative values disappear: The minimum bound is too high. Lower it so the chart includes the complete data range, then set the crossing value to the new minimum.
Labels or columns look reversed: Check whether the category order or value order has been reversed. Reversing categories can change the chart’s visual arrangement without changing the data; inspect Axis Options before changing crossing values.

Useful choices before changing the chart

There is no single best position for every chart. If readers need to compare positive and negative values, leaving the horizontal axis at zero makes the sign and magnitude easy to interpret. For a chart where the zero line is not important and category names should stay out of the data, moving the axis line to the bottom or moving labels to Low may be clearer.

Consider these factors before making the change:

Purpose: Keep a zero crossing when it communicates an important threshold. Move the line only when a bottom-aligned axis better supports the comparison.
Consistency: Use the same axis bounds and crossing position across charts that readers will compare side by side.
Data range: Confirm that the minimum includes every value. A chart should not conceal meaningful negative results merely to place the axis at the bottom.
Readability: If only the labels are inconvenient, move the labels rather than changing where the data axis crosses.

Moving an axis changes the chart’s visual layout, not the underlying values. Still, axis position can affect how readers interpret a graphic, especially when negative values are involved. Keep a visible zero reference where it matters, and make sure the scale remains clear.

Frequently Asked Questions

How do I move the x-axis to the bottom in Excel?
Select the vertical value axis, choose Format Axis, and set Horizontal axis crosses to the minimum value on that scale. If you only want the category labels at the bottom, set the horizontal axis Label Position to Low.

Why is my Excel horizontal axis in the middle of the chart?
It usually crosses the vertical axis at zero because the data includes both positive and negative values. Set the crossing value to the vertical axis minimum to move the line to the bottom.

Can I put the axis line at the bottom but keep the zero line?
Yes. Move the horizontal axis line to the minimum, then add a separate zero reference if the chart needs one. For example, you can add a series with zero values and format it as a line, taking care to use the same category positions and scale.

How do I move only the axis labels to the bottom?
Select the horizontal axis, open Format Axis, expand Labels, and choose Low for Label Position. This changes the label location without moving the axis line.

Does this work in Excel for Mac?
Yes. Select the value axis and open Format Axis; the relevant crossing and label controls are available in the desktop Mac version, although the pane layout can differ slightly from Windows. If a control is missing in Excel for the web, use Excel for Mac or Windows to make the adjustment.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.