Display Letters on an Excel Scatter Chart X-Axis
Question details
The user wants to display letters such as A through J along the x-axis of an Excel chart.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Plot y-values as individual points while using letters to identify positions on the horizontal axis.
- Observed behavior
- An XY scatter chart uses numeric x-values rather than text category labels on its horizontal axis.
Place the letters in one column and their corresponding numeric y-values in an adjacent column. Check whether the points should be evenly spaced: a category axis does not preserve unequal numeric x-intervals.
Use an Excel Line Chart with Markers and Letter Labels
Use this approach to show evenly spaced letter categories with points that resemble a scatter chart.
A line chart uses a category axis, so it can display text labels. Hiding the connecting line leaves the markers visible.
Select the cells containing the letters and their corresponding y-values, including headers if available.
Choose Insert > Line or Area Chart > Line with Markers.
If the letters do not appear on the x-axis, right-click the chart and choose Select Data. Under Horizontal (Category) Axis Labels, select Edit, choose the cells containing the letters, and select OK.
Right-click the plotted series and choose Format Data Series. Under Fill & Line, select Line > No line, and keep the markers enabled.

Show Letter Categories with Markers in WPS Spreadsheet
Use a line chart with markers in WPS Spreadsheet, then hide the connecting line to display points against letter categories.
- 1. Open your worksheet: Open the workbook in WPS Spreadsheet and arrange the letters and corresponding y-values in adjacent columns.
- 2. Insert a line chart: Select the data range, then choose Insert > Chart and select a line chart with markers.
- 3. Check the axis labels: If needed, use the chart’s Select Data option to set the horizontal category labels to the cells containing your letters.
- 4. Hide the line: Select the plotted series, open Format Data Series, and set the line to No line while leaving the markers visible.

Frequently Asked Questions
Why can’t I use letters as x-values in an Excel scatter chart?
An XY scatter chart uses a numeric horizontal axis. To display text categories such as A through J directly on the axis, use a line chart with markers instead.
How do I make a line chart look like a scatter chart?
Right-click the data series, choose Format Data Series, and set Line to No line. Leave the markers enabled so the individual points remain visible.
How do I change the letters shown on the horizontal axis?
Right-click the chart and choose Select Data. Under Horizontal (Category) Axis Labels, select Edit and choose the cells containing the labels you want.
Will a line chart preserve unequal spacing between numeric x-values?
No. A category axis spaces labels evenly. If the distances between numeric x-values matter, use an XY scatter chart, which positions points according to their numeric x-values.




