To move Excel chart labels to the bottom, select the horizontal (x) axis, open Format Axis, then under Axis Options > Labels, set Label Position to Low. This places the category labels along the bottom of the plot area, even when the horizontal axis itself crosses the chart higher up.
Move the x-axis labels in Excel
In Excel for Microsoft 365 on Windows, the quickest way to open the relevant settings is to right-click the x-axis labels in the chart and choose Format Axis. If selecting the labels is difficult, click the chart first, then use the Format tab’s Current Selection list to choose the horizontal axis and click Format Selection.
- Select the chart, then select its horizontal axis labels. These are usually the dates, names, or other categories along the bottom or top.
- Right-click the selected axis and choose Format Axis. The Format Axis pane opens at the side of the worksheet.
- In the pane, select Axis Options if it is not already active, then expand Labels.
- Open the Label Position menu and choose Low.
Excel updates the chart immediately. If you want to return the labels to their usual relation to the axis line, select Next to Axis. To hide the labels without deleting the data or changing the chart series, choose None.
What Low, High, and Next to Axis mean
The Label Position setting controls where category text appears inside the chart’s plot area. Low puts it at the bottom, and High puts it at the top. Next to Axis places the labels alongside the horizontal axis line. That last choice is often the default, which is why labels can appear in the middle of a chart when the axis line crosses the plot area at zero.
These choices affect the labels, not the plotted values or the source data. Moving the labels to Low does not reverse the category order, change which series is plotted, or move the axis line. It is a display setting for the chart, so it is also safe to try and change back.
For example, imagine a column chart showing monthly profit and loss, with positive values above zero and negative values below it. Excel may draw the horizontal axis at zero, so month names set to Next to Axis appear across the middle. Choosing Low moves the month names to the bottom edge of the plot area while leaving the zero line in place.
Labels are not the same as the axis line
A common source of confusion is that the x-axis labels and the x-axis line are separate chart elements. Label Position changes the location of category names, dates, or numbers displayed as labels. It does not necessarily move the horizontal line where the value axis crosses the chart.
If the labels are at the bottom but you also want the axis line at the bottom, format the vertical value axis separately. Right-click the value axis, choose Format Axis, and look under Axis Options for Horizontal axis crosses. The available controls depend on the chart type and axis scale. For a value axis with negative and positive values, the axis commonly crosses at zero; changing that crossing can alter how the chart reads, so do it only when the line’s position is genuinely what you want to change.
Likewise, changing where the vertical axis crosses the category axis is not the same as moving the category labels. If labels are the problem, start with Label Position: Low rather than changing axis-crossing settings.
When this setting is useful
Low is particularly helpful when the chart has both positive and negative values, because the horizontal axis may run through the middle of the plotting area. It can also make a chart easier to read when a prominent zero line or reference line would otherwise cut through category names.
- Column or bar-style comparisons: Keep category names along the bottom while the value axis includes negative values.
- Line charts: Keep date or category labels at the lower edge even if the horizontal axis crosses at a nonzero value.
- Charts with a reference baseline: Separate the labels from a baseline that needs to remain visible within the data region.
For a conventional chart with only positive values, labels are already at the bottom in many layouts. In that situation, changing the setting may appear to do nothing. The position options are most noticeable when the axis line has been drawn somewhere other than the bottom.
Chart types and category labels
The instructions apply most directly to charts with a horizontal category axis, such as common column, line, and area charts. The labels may be text categories, dates, or values used as categories. A scatter chart is different: its horizontal axis is usually a value axis rather than a category axis, and its tick marks represent numeric positions. The options shown when formatting that axis may therefore differ from those for a category axis.
Excel also distinguishes between a chart’s horizontal and vertical axes and the series data. If the Format Axis pane shows number formats, bounds, or units rather than a Labels section, check that you selected the category axis rather than the value axis. You can click directly on one of the category labels, or choose the horizontal axis from the chart’s Current Selection list.
In charts with a secondary axis, take care to select the axis associated with the labels you mean to move. A chart can contain more than one value axis, but the category labels are still controlled by the category axis settings. If a chart has unusual formatting or a specialized chart type, the available options can vary.
Fix labels that still look misplaced
If choosing Low does not produce the expected result, check what Excel has selected and what you mean by bottom. These checks resolve most cases:
- Confirm the selected element. The pane should be formatting the horizontal category axis, not a data series, chart title, or vertical value axis.
- Check the chart area versus the plot area. Low places labels at the bottom of the plot area, which is the region where data is drawn. It does not promise a particular distance from the outer edge of the entire chart.
- Look for long or crowded labels. Long category names may wrap, overlap, or take up extra space even when they are correctly positioned. Widen the chart, reduce the font size, or use shorter source labels if readability is poor.
- Check for a reversed category order. If the categories run in an unexpected direction, changing Label Position will not fix their order. Look in the category axis options for the order setting and adjust it only if the order itself is wrong.
- Inspect other chart elements. A data table, legend, or axis title can occupy space near the bottom and make labels appear higher than expected. Adjust or remove the element that is taking up the space.
If the labels overlap the chart border, first make the chart taller or enlarge the worksheet area occupied by it. Rotating or staggering text can help in some charts, but those changes address crowding, not the axis position.
Excel on Mac and the web
In Excel for Microsoft 365 on Mac, select the chart’s horizontal axis and open Format Axis—for example, by Control-clicking the axis and choosing the formatting command. In the formatting pane, use the axis options and set Label Position to Low. The pane’s appearance and the route used to open it can differ slightly from Windows, but the setting has the same purpose.
Excel for the web has a more limited chart-formatting interface than the desktop application, and particular controls may not be available in every web editing view. If you cannot find Label Position, open the workbook in the Excel desktop app and make the change there. The chart formatting is stored in the workbook, so it remains visible when the file is opened elsewhere.
Frequently Asked Questions
How do I move x-axis labels to the bottom in Excel?
Right-click the horizontal category axis, choose Format Axis, expand Labels under Axis Options, and set Label Position to Low.
Why are my Excel chart labels in the middle?
The horizontal axis may cross the plot area at zero or another value, and the labels may be set to Next to Axis. Choose Low to move the labels to the bottom without moving the axis line.
Does Low move the x-axis line too?
No. It moves the category labels, not the horizontal axis line. Format the value axis and review its crossing setting if the line itself needs to move.
Can I put the labels at the top instead?
Yes. In the same Label Position menu, choose High. Choose Next to Axis to place them beside the axis line, or None to hide them.
What if I cannot find Label Position?
Make sure you selected the horizontal category axis. If the chart type uses a numeric horizontal value axis, or you are editing in Excel for the web, the options may differ. Try selecting the axis from the chart’s Current Selection list or opening the workbook in desktop Excel.
Keep the chart readable after moving labels
Once the labels are at the bottom, check that they remain legible and that the chart still communicates the intended comparison. A bottom position can improve clarity, but it does not solve every layout issue. Long dates, many categories, a legend below the plot, or a data table can compete for the same space.
For a clean result, use the least disruptive fix: set Label Position to Low if the labels are simply following an axis through the middle; resize the chart if the text is cramped; and change axis-crossing behavior only if the axis line itself should move. Keeping those controls distinct makes it easier to adjust the chart without accidentally changing its scale or meaning.
Related
- Excel Keyboard Shortcut to Add a Row (Windows & Mac)
- Excel Ungroup Columns Shortcut: Keys, Steps, and Fixes
- Excel Keyboard Shortcut to Zoom Out: Keys and Options
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Chart Title From Cell: Link, Format, and FixesTo link an Excel chart title to a cell, select the chart title, click the formula bar, type…
- Excel Chart: Add a Data Label to the Last PointTo label only the last point in an Excel chart, click the data series once, click its final…
- How to Make a Half-Round Chart in ExcelIn Excel for Microsoft 365, make a half-round chart by inserting a doughnut chart from your values plus…
- High-Level Gantt Chart Excel Template: Build a Clear ViewA high-level Gantt chart in Excel is a short project schedule that shows major phases or deliverables against…
- Excel Pivot Table Percent of Total: How to Show ItTo show a percent of total in an Excel pivot table, add the value field a second time,…
- Excel Sunburst Chart Data Layout: A Practical GuideFor an Excel sunburst chart, put each level of the hierarchy in its own column, from the broadest…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.