Chart & Visualization Issues

Display Letters on an Excel Scatter Chart X-Axis

Maira MehtabMaira Mehtab Nov 20, 2026 868 views

Question details

The user wants to display letters such as A through J along the x-axis of an Excel chart.

Display Letters on an Excel Scatter Chart X-Axis
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the data

Select the cells containing the letters and their corresponding y-values, including headers if available.

2
Insert a line chart

Choose Insert > Line or Area Chart > Line with Markers.

3
Set the letter labels

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.

4
Hide the connecting line

Right-click the plotted series and choose Format Data Series. Under Fill & Line, select Line > No line, and keep the markers enabled.

Use an Excel Line Chart with Markers and Letter Labels
Category spacing: The letters are evenly spaced on a line chart. If the numeric distances between x-values matter, retain an XY scatter chart and use another labeling approach.
Create charts in WPS Spreadsheet

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. 1. Open your worksheet: Open the workbook in WPS Spreadsheet and arrange the letters and corresponding y-values in adjacent columns.
  2. 2. Insert a line chart: Select the data range, then choose Insert > Chart and select a line chart with markers.
  3. 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. 4. Hide the line: Select the plotted series, open Format Data Series, and set the line to No line while leaving the markers visible.
Display letter categories along a chart’s horizontal axisKeep markers visible without connecting linesOpen and edit Microsoft Excel XLSX filesCreate charts in a familiar spreadsheet interface
QA img-9

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.