To show text instead of numeric values along an Excel chart’s horizontal axis, use a category chart such as a line or column chart, then assign the cells containing your labels: select the chart and choose Chart Design > Select Data > Horizontal (Category) Axis Labels > Edit. An XY (Scatter) chart requires a numeric x-axis, so changing its axis labels alone will not turn that scale into text categories.
Why Excel Shows Numbers on the X-Axis
The result depends mainly on the chart type. Excel uses two different kinds of horizontal axes. A category axis displays labels such as product names, months, or stages. A value axis displays numbers on a numerical scale. Column, bar, and line charts commonly use categories for one axis; XY scatter charts use value axes for both x and y.
This difference matters because a scatter chart positions each point according to its actual x-value. If the x-values are 1, 2, and 10, the point at 10 is much farther from the point at 2 than the point at 1. A line chart with a category axis instead places each listed category in sequence. Those positions are evenly spaced, even if the labels happen to be numbers.
For example, a table of weekly sales with labels Monday, Tuesday, and Wednesday will usually make sense as a line or column chart. A table of elapsed time and temperature, where the exact numerical distance between measurements matters, is usually better as a scatter chart. Excel may show 1, 2, and 3 on a scatter chart if it has no usable numeric x-values, or if the selected data range did not include the intended x-values.
Choose the Right Chart Type
Before changing settings, decide whether the x-axis represents named groups or a continuous numerical measurement. This is more than a cosmetic choice: changing from a scatter chart to a category chart can change the spacing and interpretation of the data.
- Choose a category chart when each x-value is a label or an ordered group, such as departments, survey responses, or named months. Line and column charts are common choices.
- Choose an XY scatter chart when x-values are measurements and their actual numerical spacing matters, such as distance, time in seconds, or concentration.
- Use a date axis when appropriate if the labels are real dates and the chart should reflect the time intervals between them. A date axis can space dates according to elapsed time rather than treating every row as an equally spaced category.
A common misconception is that any chart can use arbitrary text as a true numerical-axis label. A scatter axis has a numeric scale; assigning cells as category labels does not replace that scale. If you need named labels and equal spacing, use a category chart. If you need numerical spacing and want extra text near points, keep the scatter chart and add data labels instead.
Change a Scatter Chart to a Text-Label Chart
In Excel for Microsoft 365 on Windows, use these steps when the data should be plotted as categories rather than as numerical x-coordinates:
- Select the chart to show the chart-specific ribbon tabs.
- Choose Chart Design > Change Chart Type.
- Select Line or Column, as appropriate, and choose a suitable subtype.
- Select OK. Check the plotted series, since changing chart type changes how Excel interprets the horizontal values.
- If the labels are still wrong, choose Chart Design > Select Data. Under Horizontal (Category) Axis Labels, choose Edit, select the worksheet cells containing the labels, and choose OK.
For example, suppose A1:A4 contains Week, Week 1, Week 2, Week 3, while B1:B4 contains Revenue, 120, 155, 138. Create a line or column chart from A1:B4. If the chart instead displays 1, 2, and 3, open Select Data and set the horizontal category label range to A2:A4. Keep the header in row 1 as the series name, not as one of the category labels.
On Excel for Mac, the chart tools and Select Data controls are available, but ribbon layout and dialog appearance can vary by release. Select the chart and look for the Chart Design tab and its Change Chart Type or Select Data commands. Excel for the web also supports chart editing, though some chart-formatting controls may be more limited than the Windows desktop version.
Set the Category Labels from Worksheet Cells
If the chart type is already a line or column chart, the issue is often the source range rather than the axis format. In the Select Data dialog, check both the series values and the horizontal category labels. The series should usually point to the numeric measurements, while the category label range should point to the text or date cells that describe those measurements.
For instance, if A2:A5 contains North, South, East, and West, and B2:B5 contains 18, 24, 21, and 16, use A2:A5 as the category labels and B2:B5 as the values for the series. If Excel has included only B2:B5, it may create default labels such as 1 through 4. Selecting the correct label range tells Excel what each plotted value represents.
Also check whether the chart’s data is oriented the wrong way. If Excel treated rows as separate series when you intended columns to be separate categories, select the chart and choose Chart Design > Switch Row/Column. This can help with a compact table whose labels run across a row rather than down a column. Review the legend and plotted values afterward; switching orientation changes the series arrangement, not just the appearance of the axis.
Text Axis, Date Axis, and Numeric Labels
For a category chart, Excel may treat date-like labels as dates and space them using a date scale. To review that behavior, right-click the horizontal axis, choose Format Axis, and look under Axis Options for the axis type choices. Depending on the chart and the data, Excel can offer options such as a text axis or date axis. Select a text axis when each entry should occupy one category position; use a date axis when real date intervals should affect spacing.
Be careful when the cells merely look like dates. Text such as Jan, Feb, and Mar can function as category labels, while actual date values can be interpreted as dates. That distinction can explain why labels are skipped, spaced unexpectedly, or displayed in a different format than expected. If the order matters, arrange the source rows in the intended order; a category chart generally follows the order of the source labels rather than sorting the categories for you.
If you want the numbers themselves to appear as labels on a category axis, a line or column chart can do that too. The values 1, 2, and 10 will be treated as three categories with equal spacing, not as positions on a continuous scale. This is useful for ordered stages or codes, but not for measurements where the distance between values carries meaning.
Common Problems and How to Diagnose Them
- The chart still shows 1, 2, 3. Confirm it is a category chart, then use Select Data to set the horizontal category label range. A scatter chart will not use that range as a text axis.
- The labels are missing or include a header. Check the selected label range starts at the first data label and does not accidentally include a title or blank cell. Make sure the header row is identified as a series name where applicable.
- Some labels appear blank. Look for blank cells, merged cells, or a label range that is shorter than the plotted data. A one-to-one relationship between category labels and plotted points makes charts easier to interpret.
- Numbers are being treated as labels. Excel can treat numeric entries in a category chart as category names. That is expected when the chart uses a category axis. Switch to a scatter chart only if those values should determine numerical positions.
- The axis shows dates at odd intervals. Review whether Excel selected a date axis. Choose a text axis for equally spaced categories, or retain a date axis if calendar spacing is important.
- Changing chart type changes the story. Compare the plotted points before and after the change. A scatter chart preserves numerical x-distance; a category chart spaces the listed labels evenly. Choose according to what the data means, not just which appearance looks familiar.
One other source of confusion is a horizontal bar chart. In that chart type, the category labels are normally on the vertical axis and the numerical values extend horizontally. So if the goal is to put text along the bottom edge, a bar chart may not be the chart orientation you want; a column chart typically places categories along the horizontal axis.
Alternatives When You Need Both Numbers and Text
If the data genuinely needs a scatter chart but readers also need names, preserve the numerical x-axis and add labels to the plotted points. Select a data series, use the chart’s Chart Elements control to add Data Labels, and format the labels to show useful information. In Microsoft 365, the Format Data Labels pane may offer Value From Cells for choosing worksheet cells as label text. The available choices depend on chart type and Excel version. You can keep x-values or y-values visible as well, or turn off labels that would clutter the chart.
Another option is to use a small table or a clearly labeled note alongside the chart, especially when the number of points is large. Avoid placing text boxes manually for every point if the data changes often: manually positioned text can become misaligned when the chart is resized or updated. If a scatter chart’s x-values are actually category codes, consider whether a category chart better communicates the data in the first place.
Frequently Asked Questions
How do I change the X-axis from numbers to words in Excel?
Use a line or column chart, then choose Chart Design > Select Data > Horizontal (Category) Axis Labels > Edit and select the cells containing the words. This will not convert a scatter chart’s numerical x-axis into a text axis.
Can an Excel scatter plot use text on the X-axis?
A scatter plot uses numerical x-coordinates, so it cannot use arbitrary text as its true horizontal scale. Use a category chart for text categories, or keep the scatter plot and use data labels to show names beside points.
Why does Excel show 1, 2, 3 instead of my labels?
Excel may not have included the label cells in the chart source, or the chart may be an XY scatter chart. Set the category label range in Select Data for a line or column chart, or change the chart type if the data represents categories.
Can I keep the numeric spacing and display text labels?
Not as ordinary category labels on a scatter chart axis: its positions are controlled by numbers. Keep the scatter chart and add text as data labels, or use a category chart if equal spacing is acceptable.
Should I use a text axis or a date axis?
Use a text axis when each label is a separate category that should be evenly spaced. Use a date axis when the labels are actual dates and the time between dates should affect their spacing.
Related
- Excel Shortcut to Insert Another Row in Windows and Mac
- Excel Shortcut to Select to the End of a Column
- Excel Shortcut to Select Cells to the End of a Column
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Pie Chart Speedometer in Excel: Build a GaugeTo make a pie chart speedometer in Excel, build a doughnut chart from the measured value, the unused…
- Excel Dashboard Best Practices for Clear, Reliable ReportsBuild an effective Excel dashboard by defining the decisions it should support, organizing its source data in a…
- EBITDA Waterfall Chart in Excel: Build It Step by StepTo make an EBITDA waterfall chart in Excel, list opening EBITDA, each positive or negative driver, and closing…
- Excel Stacked Bar Chart: Change Series Order EasilyTo change the series order in an Excel stacked bar chart, select the chart and choose Chart Design…
- Refresh Pivot Table on Open in Excel: Setup & LimitsYes. In Excel for Microsoft 365 on Windows, right-click a PivotTable, choose PivotTable Options, open the Data tab,…
- Excel Donut Chart Progress: Build a Progress RingTo make an Excel donut chart show progress, give it two values: the amount complete and the amount…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.