Excel Graph: How to Move the X-Axis to the Bottom

Charts & pivot tables · Updated November 18, 2026

To move an Excel chart’s x-axis to the bottom, select the vertical (y) axis, open Format Axis, and under Axis Options change Horizontal axis crosses to Axis value, entering the minimum value shown on the y-axis. If the axis line is already at the bottom but its labels are at the top, change the horizontal axis label position to Low instead.

Why the X-Axis Appears at the Top

In a typical line or column chart, the x-axis displays categories such as months or product names, while the y-axis displays numeric values. Excel normally places the horizontal axis where the vertical value axis crosses zero. When a chart includes negative numbers, or all its values are negative, that crossing can be somewhere inside the chart or at the top of the plot area rather than along its bottom edge.

The axis line and its labels are separate settings, which is why an axis can seem to be in the wrong place even when only the text has moved. For example, a line chart might have its horizontal line at the bottom while January, February, and March are printed above the graph. Conversely, the labels may be at the bottom while the axis line itself crosses through the data. Identify which part you need to move before changing settings.

This advice applies to common charts with a numeric vertical axis, including line and column charts. A bar chart is arranged differently: its categories run vertically and its numeric axis runs horizontally. Pie and doughnut charts have no axes to reposition.

Move the Axis Line to the Bottom

For a line or column chart with a numeric y-axis, use the vertical axis’s crossing setting. In Excel for Microsoft 365 on Windows, click the chart’s y-axis numbers, right-click, and choose Format Axis. In the Format Axis pane, open Axis Options and look for Horizontal axis crosses. Choose Axis value and enter the value at the bottom of the vertical scale.

  1. Select the chart, then click the vertical value axis. If selecting it is difficult, use the Format tab’s Current Selection list to choose the vertical axis.
  2. Right-click the selected axis and choose Format Axis to open the formatting pane.
  3. Under Axis Options, find Bounds and note the vertical axis’s minimum value. If Excel shows Auto, you can set a specific minimum first.
  4. Under Horizontal axis crosses, select Axis value and enter that minimum value.

For example, suppose a chart contains values of -6, -14, and -9. If you set the y-axis minimum bound to -16, enter -16 as the axis crossing value. The horizontal axis will then meet the vertical axis at the bottom boundary of the plotted scale. The example is illustrative: choose bounds that fit your data, rather than copying those numbers into an unrelated chart.

Choose Suitable Axis Bounds

Setting the crossing point and setting the scale limits are related, but they are not the same operation. The Bounds controls set the lowest and highest values displayed on the y-axis. The crossing value determines where the horizontal axis meets that scale. If the minimum bound is automatic, Excel may recalculate it as data changes, so a crossing value you entered might no longer sit exactly at the bottom.

For a stable layout, set the minimum bound to a sensible value and use the same number as the crossing value. In the example above, a minimum of -16 and a crossing value of -16 place the axis at the bottom. If the chart’s lowest observation is -14, the extra space below it also keeps the line from sitting directly on the chart border. Avoid choosing a bound so tight that it hides meaningful variation or makes the chart difficult to read.

For data that are all positive, Excel usually places the horizontal axis at the bottom already because zero is below the plotted values. If the chart uses a nonzero minimum, check the actual scale and crossing setting rather than assuming that zero will be visible. A crossing point outside the displayed bounds may not produce the visual result you expect.

Move Axis Labels Without Moving the Axis Line

If the axis line is where you want it but category labels appear at the top, change the label position. Click the horizontal axis labels, right-click, and choose Format Axis. In Axis Options, expand Labels, then set Label Position to Low. This puts the labels along the lower edge of the chart area without changing where the axis crosses the y-axis.

Use High to place labels along the top, or Next to Axis to keep them near the axis line. The exact visual result depends on the chart and where the axis crosses. A useful check is to look separately at the horizontal line and the text beneath or above it: if one is correct, change only the setting for the other.

This distinction often resolves the common question, “How do I move the x-axis labels to the bottom?” The answer may be Label Position: Low, not a new crossing value. Changing the crossing setting just to move labels can shift the line through the data and make the graph harder to interpret.

What to Do When the Setting Is Missing

The options shown in Format Axis depend on which axis and chart type you selected. For the standard procedure, select the vertical numeric axis, not the horizontal category labels. The y-axis’s Horizontal axis crosses control governs where the horizontal axis meets the vertical scale. If you select the horizontal axis instead, you may see a different control for where the vertical axis crosses it; that setting concerns the other axis.

  • Can’t select the y-axis? Click a y-axis number, or choose the vertical axis from the chart’s Current Selection list on the Format tab.
  • No numeric vertical axis? Check whether the chart uses a category axis or is a chart type without axes. Some chart types do not offer the same crossing controls.
  • Axis is still not at the edge? Check that the crossing value matches the plotted minimum bound, and confirm that you changed the vertical value axis rather than the category axis.
  • Labels remain at the top? Format the horizontal axis labels and set Label Position to Low.

In a bar chart, the category axis is vertical and the value axis is horizontal. If you mean that category names should appear at the bottom or that the value scale should sit at a particular edge, the relevant axis and label settings differ from those in a line chart. Also, reversing the order of categories can change which side the other axis appears on. Check the chart’s orientation before applying instructions for a line or column chart.

Windows, Mac, and Excel for the Web

The chart-formatting approach is similar in current Excel for Windows and Excel for Mac: select the relevant axis, open its formatting pane, and adjust the axis options. On Mac, the pane’s placement and some interface details can differ; use the chart’s formatting controls and select the vertical axis carefully. Keyboard shortcuts for opening context menus also differ between Windows and Mac, so right-clicking or using the Mac equivalent, Control-click, is a straightforward way to reach Format Axis.

Excel for the web also supports editing charts, though available controls can vary with the chart and the current web interface. If you cannot find the axis-crossing option in the browser, open the workbook in the desktop app and use the Format Axis pane there. The setting changes the chart’s presentation; it does not alter the source data in the worksheet.

Make the Change Easier to Maintain

Axis settings can affect how a chart reads after the data changes. If new values extend below your fixed minimum, they may be clipped from view. If values cross zero later, a horizontal axis pinned to the original minimum will remain at the chart’s lower boundary rather than moving to zero. That may be exactly what you want for a consistent layout, but it is worth checking the chart whenever its source data or scale changes.

Before finalizing the chart, consider these points:

  • Keep the scale wide enough to show every relevant data point.
  • Use a clear axis title and number format so readers understand the units and whether values can be negative.
  • Check that gridlines, data labels, and the axis line do not overlap in a confusing way.
  • If the chart is copied or reused, verify the crossing and label settings after changing its data range or chart type.

Moving the axis is a formatting choice, not a correction to the underlying numbers. For a chart that compares positive and negative values, an axis through zero can make the sign and magnitude easier to interpret. Putting it at the bottom can instead give the plot a familiar baseline or make category labels easier to read. Choose the position that best communicates what the data mean, and avoid implying that negative values start from a zero baseline when they do not.

Frequently Asked Questions

How do I move the x-axis to the bottom in Excel?
Select the vertical value axis, open Format Axis, and set Horizontal axis crosses to Axis value. Enter the y-axis minimum value.

Why is my Excel x-axis at the top?
The horizontal axis may be crossing the vertical scale at zero, and zero may be at the top because the chart’s values are negative. Set the crossing value to the minimum displayed y-axis bound.

How do I move only the x-axis labels to the bottom?
Select the horizontal axis labels, open Format Axis, and under Labels set Label Position to Low. This moves the labels, not the axis line.

Does this change my spreadsheet data?
No. Axis crossing and label position are chart-formatting settings. They change how the chart is displayed, not the values in the worksheet.

Can I use the same steps for a bar chart?
Not exactly. A bar chart places categories vertically and values horizontally, so first identify which axis or labels you want to reposition. The line-chart instructions apply to charts with a vertical numeric axis and a horizontal category axis.

Related

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.