Why Excel Scatter Chart Horizontal Axis Labels Cannot Be Changed
Question details
The user wants country names to appear as horizontal axis labels on an Excel scatter chart.

- 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.
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.
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.
Select the chart, open Chart Design > Change Chart Type, and choose Line or Column.
Open Chart Design > Select Data. Under Horizontal (Category) Axis Labels, select Edit, choose the cells containing country names, and click OK.
In Select Data, review the series and edit its values if necessary so the chart plots the intended data for each country.

Simulate Country Axis Labels with a Scatter Chart Helper Series
Use labels on an invisible helper series when the chart must retain numeric X positions.
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.

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.




