Chart & Visualization Issues

Why Excel Scatter Chart Horizontal Axis Labels Cannot Be Changed

Khadija KhanKhadija Khan Nov 22, 2026 868 views

Question details

The user wants country names to appear as horizontal axis labels on an Excel scatter chart.

Why Excel Scatter Chart Horizontal Axis Labels Cannot Be Changed
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user is trying to select country names as horizontal axis labels, as in another chart.
Observed behavior
Excel does not allow the country-name range to be used as category labels on the scatter chart's horizontal axis.
Before you start

Check that the chart is an XY (Scatter) chart and that the country names are in worksheet cells. Decide whether the chart must retain numeric X positions or can use evenly spaced categories.

Solution 1Recommended

Use a Line or Column Chart for Country Axis Labels

Use a category chart when country names should appear on the horizontal axis and exact numeric X spacing is not required.

An XY scatter chart uses a numeric value axis for X values, not a category axis. A line or column chart can use country names as category labels, but its categories are normally evenly spaced.

1
Change the chart type

Select the chart, open Chart Design > Change Chart Type, and choose Line or Column.

2
Select the country labels

Open Chart Design > Select Data. Under Horizontal (Category) Axis Labels, select Edit, choose the cells containing country names, and click OK.

3
Check the plotted series

In Select Data, review the series and edit its values if necessary so the chart plots the intended data for each country.

Use a Line or Column Chart for Country Axis Labels
Spacing will change: A category chart does not preserve the scatter chart's numeric X-axis spacing. Use a helper series if the numeric positions must remain intact.
Free Microsoft Office alternative

Create Charts in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with charts as you move between office suites.

Create and edit spreadsheet charts, including scatter chartsCompatible with Microsoft Excel XLSX and XLS filesFamiliar interface for working with worksheet dataFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I select country names as scatter chart axis labels?

An Excel XY scatter chart uses numeric X values on a value axis, so it does not use a category-label range like a line or column chart.

How can I change the numeric X values in a scatter chart?

Select the chart, open Chart Design > Select Data, select the series, and choose Edit. Change the Series X values range to the numeric cells you want to plot.

Can country names appear near the axis without changing chart type?

Yes. Add a helper scatter series near the bottom of the plot, then use Format Data Labels > Value From Cells to display country names. These are data labels, not actual category-axis labels.

Will a line chart preserve the scatter chart's X-axis spacing?

Usually not. A line chart normally spaces categories evenly, while a scatter chart positions points according to their numeric X values.