How to Fix Excel Using Numbers Instead of Text for X-Axis Labels
Question details
The user needs Excel to display text category labels on the X-axis instead of numeric ordinal values, especially when an XY Scatter chart is in use.
- Product
- Microsoft Excel / WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- Creating or editing a chart that uses text categories for the X-axis.
- Observed behavior
- Excel plots the X-axis categories as numbers rather than the text labels, most often because the chart type is an XY Scatter chart.
Select the chart and open the Chart Design tab to identify the current chart type. If the chart is an XY Scatter chart, it requires numeric X values and is the most common reason for this behavior.
Check the Chart Type and Switch to a Line, Column, or Bar Chart
Use this solution first when Excel shows numbers instead of text for X-axis labels; most cases occur because the active chart is an XY Scatter chart.
An XY Scatter chart requires numeric X values. If the source range contains text, Excel may plot ordinal numbers such as 1, 2, and 3 for the categories. Line, Column, and Bar charts can display text category labels directly.
Click the chart whose X-axis labels are currently showing numbers instead of text.
Go to the Chart Design tab on the ribbon, then click Change Chart Type.
Select Line, Column, or Bar from the chart type list, pick the preferred subtype, and click OK.
Check the chart to confirm that the text entries from the source range now appear as X-axis labels.
Edit the SERIES Formula to Include the X-Value Range
Use this when the chart type supports an explicit X-value range and you need to map the axis to the text source range manually.
Fix X-Axis Text Labels in WPS Office Spreadsheet
Open the Excel workbook in WPS Office Spreadsheet and use the same Chart Design tools to switch to a categorical chart type or edit the SERIES formula. WPS Office is free, lightweight, and preserves .xlsx chart data while providing a familiar Office-style interface.
- 1. Open the workbook in WPS Office Spreadsheet: Launch WPS Office Spreadsheet and open the Excel workbook that contains the chart with numeric X-axis labels.
- 2. Select the chart and open Chart Design: Click the chart, go to the Chart Design tab on the ribbon, and click Change Chart Type.
- 3. Switch to a categorical chart type: Choose Line, Column, or Bar chart, then click OK so the text categories are used as X-axis labels.
- 4. Save the updated workbook: Save the file as .xlsx or your preferred format to keep the chart change.
Frequently Asked Questions
Why does Excel show numbers instead of text for X-axis labels?
This usually happens when the chart is an XY Scatter chart. Scatter charts require numeric X values, so text categories may be replaced with ordinal numbers. Switch to a Line, Column, or Bar chart from Chart Design > Change Chart Type to display text labels.
How do I edit the SERIES formula to show text X-axis labels?
Select the data series, then edit the SERIES formula in the formula bar to include the X-value range before the Y-value range. For example: =SERIES(,Sheet1!$L$10:$L$15,Sheet1!$M$10:$M$15,2).
Can an XY Scatter chart use text categories as X-axis labels?
No. An XY Scatter chart requires numeric X values. To show text categories on the X-axis, use a Line, Column, or Bar chart instead.
Will changing the chart type affect my source data?
No. Changing the chart type only changes how the data is displayed. The worksheet data and series values remain unchanged.
Does WPS Office Spreadsheet have the same chart type options as Excel?
Yes. WPS Office Spreadsheet opens .xlsx workbooks and includes Chart Design > Change Chart Type, so you can apply the same fix without converting the file.
