Excel Chart Horizontal Axis Labels: How to Set Them

In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Select Data, then under Horizontal (Category) Axis Labels choose Edit and select the worksheet cells to use. Horizontal axis labels identify the categories along the bottom of many charts; in a scatter chart, however, the horizontal axis uses numeric X values rather than category labels.

What horizontal axis labels show

Horizontal axis labels tell readers what each plotted position represents. A column chart might use months, product names, or regions along its bottom edge, while its vertical axis shows sales or another measured value. Excel often takes the labels from the first column or row of the selected data when it creates a chart, but the source range can be changed afterward.

Axis labels are different from an axis title. Labels are the individual values or names along the axis, such as January, February, and March. An axis title is a separate description of the whole axis, such as Month or Revenue ($). To add an axis title, select the chart and use Chart Design > Add Chart Element > Axis Titles, then choose the horizontal axis option and type the title.

They are also distinct from a chart legend. A legend identifies data series, such as Actual and Forecast; horizontal axis labels identify the categories or positions to which those series correspond. Keeping these roles clear makes it easier to diagnose a chart that appears to show the wrong information.

Set or change the label range

Use the chart’s data-selection dialog when the labels are missing, incorrect, or drawn from the wrong worksheet cells. On Windows, click the chart first so its chart tabs appear, then follow these steps:

Choose Chart Design > Select Data.
In the Select Data Source dialog, find Horizontal (Category) Axis Labels and click Edit.
Select the worksheet range containing the intended labels. You can drag across the cells or enter a range reference in the axis label range box.
Click OK, then click OK again to close the data-source dialog.

For example, if column A contains the months in A2:A13 and columns B and C contain two series of figures, set the horizontal label range to A2:A13. The chart will use those month names beneath the plotted values. If the chart uses data from another sheet, include the sheet name in the reference or select the cells directly in the worksheet.

The dialog also lets you check whether Excel has interpreted the data layout correctly. Switch Row/Column changes whether rows or columns are treated as separate series; it is not a substitute for selecting the right axis label range, but it can resolve a chart that has categories and series reversed.

Use worksheet cells as the source

Axis labels are usually linked to worksheet cells rather than typed into the chart as independent text. Changing the text in a source cell therefore normally changes the corresponding chart label too. This link is useful when labels need regular updates or when the chart should reflect a revised report.

When building a chart, select the labels and data together, including the header row or column if it identifies the series. For example, a table with Month in A1, Actual in B1, and Forecast in C1, followed by monthly data, gives Excel clear headings and category values. If you add a new month below a normal cell range, the chart might not include it automatically. Converting the data to an Excel table with Insert > Table often makes chart data expand when you add rows, although the resulting chart layout should still be checked.

For labels that need a different display from the source data, create a separate helper column. If dates are stored as real Excel dates but you want short labels such as Jan or Feb, a helper column can contain formatted text or formulas that return the preferred wording. Select that helper range as the axis labels. This keeps the underlying dates available for calculations while giving the chart a more compact presentation.

Dates, categories, and axis type

Excel can display a horizontal axis as a category axis or, in supported chart types, as a date axis. A category axis spaces each category evenly. A date axis positions dates according to elapsed time, which can make gaps in a timeline visible. For example, monthly observations with one month missing may be spaced evenly as categories, while a date axis reflects the actual time interval.

To inspect the setting, right-click the horizontal axis and choose Format Axis. In the pane, look under Axis Options for the axis type controls available to that chart. A date-axis choice may not be offered for every chart type or data arrangement. If Excel treats date entries as text, it may not offer the expected date behavior; check that the worksheet cells contain actual dates rather than strings that only look like dates.

Date axes can also show unexpected intervals or labels when the date range is long. In Format Axis, available bounds and units can be adjusted for the chart. A sensible interval—for example, showing one label per quarter rather than every day—can reduce clutter. Avoid changing the axis in a way that hides meaningful gaps or implies a timing pattern the data does not support.

Format labels for readability

If labels overlap or are difficult to read, right-click the horizontal axis and choose Format Axis. The pane offers options that depend on the chart and Excel version. Under Axis Options, you may be able to change the interval between labels; showing every second or third label can help with a long list, though it does not remove the underlying categories from the data.

For long category names, widen the chart, shorten the source labels, or use a horizontal bar chart so the names can sit beside the bars. Rotating labels is another option: in the Format Axis pane, open Text Options > Text Box and adjust the text direction or custom angle when those controls are available. Angled text may fit more words, but it can be harder to scan than concise labels.

Use consistent date formats and capitalization.
Keep labels concise, and explain abbreviations where readers may not know them.
Allow enough chart width for the number of categories.
Use a chart title or axis title to provide context instead of repeating it in every label.

Formatting the source cells does not always control how category labels appear. If the axis uses text categories, Excel may display their text as written. If labels are numeric or date values, number-format controls in Format Axis may be relevant. When a desired format does not appear, check whether the source values are numbers or dates, or text that merely resembles them.

Why a chart may not show the labels you expect

A chart with numbers such as 1, 2, 3, or a single repeated label often has an incorrect axis range or data orientation. Open Chart Design > Select Data and verify the horizontal label range. Also check that it contains the intended cells and has roughly the same number of entries as the plotted categories. In some chart types, Excel can display a generic sequence when it has no usable category range.

Blank cells, merged cells, and inconsistent source data can complicate category labels. A blank source cell may produce an empty-looking category, while merged headings can make it harder to select a clean continuous range. A practical fix is to arrange the data in a simple table with one header row, one category column, and no merged cells in the chart’s source area.

If labels appear as series names in the legend rather than categories along the bottom, check the selected chart data and try Switch Row/Column. If the chart is a PivotChart, its category labels are controlled by the PivotTable fields; change the relevant field arrangement or filter in the PivotTable rather than expecting the ordinary axis-label range control to work the same way.

Another common misunderstanding is expecting a scatter chart to use text labels along its horizontal axis. A scatter chart plots numerical X values, so its horizontal positions are determined by the X-value range for each series. To change them, use Chart Design > Select Data, select a series, choose Edit, and set its Series X values range. If each point needs a name, data labels can show text from cells where supported; that is separate from changing the X coordinates.

Choose the right chart and label strategy

The chart type determines what horizontal labels mean. Column, line, and area charts commonly use category labels or dates. A scatter chart uses numeric X values, while a bar chart places categories on the vertical axis and values horizontally. If the goal is to compare named groups, a bar or column chart may be appropriate; if the goal is to show the relationship between two measured quantities, a scatter chart is usually more suitable.

For many categories, prioritize legibility over squeezing every word onto the axis. A bar chart can accommodate long names, and a line chart with a date axis can communicate a timeline more clearly than a dense sequence of text labels. If you must show every category, consider a larger chart or a filtered view rather than shrinking the font until it is difficult to read.

On Excel for Mac, the chart-design tools and data-source controls are similar, but dialog layouts and some options can differ. Excel for the web also provides chart editing, though available formatting controls may vary. If a particular axis setting is not visible, open the workbook in the desktop version of Excel for Microsoft 365 and inspect the Format Axis pane.

Frequently Asked Questions

How do I add horizontal axis labels in Excel?
Select the chart, choose Chart Design > Select Data, click Edit under Horizontal (Category) Axis Labels, and select the cells containing the labels.

How do I change the horizontal axis labels without changing the data?
Use the axis label range in Select Data to point to a different set of worksheet cells. The plotted values can remain in their existing ranges while the categories use another label range.

Why are my Excel axis labels showing as numbers?
Excel may be using a default category sequence, the wrong cells, or a different row-versus-column orientation. Check the label range in Select Data and confirm that the selected cells contain the intended text or dates.

How do I rotate horizontal axis labels?
Right-click the axis, choose Format Axis, then look under Text Options > Text Box for text direction or custom-angle controls. The available choices depend on the chart and Excel version.

Can I use text labels on a scatter chart’s horizontal axis?
Not as category positions: a scatter chart’s horizontal axis represents numeric X values. Use a category chart if the positions should be evenly spaced names, or keep the scatter chart and use point data labels to identify individual observations.

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.