Fix an Excel Scatter Plot Using Row Numbers Instead of Data Values
Question details
The user needs an Excel scatter plot to use GDP per capita values on the horizontal axis instead of row positions.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Plot health expenditure percentage against GDP per capita using an XY scatter chart.
- Observed behavior
- The horizontal axis uses serial numbers or row positions instead of the GDP per capita data.
Identify the GDP per capita and health expenditure percentage columns and confirm that corresponding values are on the same rows. Check that the cells contain numbers rather than imported text.
Assign X and Y Values to the Existing Scatter Series
Use this method to correct the data ranges in an existing Excel scatter plot.
Right-click the chart and select Select Data.
Under Legend Entries (Series), select the series and click Edit.
In Series X values, select the numeric GDP per capita cells, excluding the column header.
In Series Y values, select the corresponding health expenditure percentage cells. Click OK, then OK again.

Create a Scatter Plot from Numeric Data Columns
Create a new chart when the existing chart has the wrong type or data ranges.
Plot GDP and Health Expenditure in WPS Spreadsheets
Use WPS Spreadsheets to create an XY scatter chart from paired GDP per capita and health expenditure values.
- 1. Open the data: Open your workbook in WPS Spreadsheets and locate the GDP per capita and health expenditure columns.
- 2. Arrange the columns: Place numeric GDP per capita values in the left column and their corresponding health expenditure percentages in the adjacent right column.
- 3. Select the data: Select both columns, including their headers if present.
- 4. Insert a scatter chart: Choose Insert > Scatter and select a chart style. Check that GDP per capita appears on the horizontal axis.

Frequently Asked Questions
Why does my Excel scatter plot show row numbers on the X-axis?
The series may not have a valid X-value range assigned. Right-click the chart, choose Select Data, edit the series, and set Series X values to the GDP per capita cells.
What is the difference between a line chart and an XY scatter chart?
A line chart generally treats horizontal-axis entries as categories, while an XY scatter chart uses numeric X and Y pairs. To change the chart, right-click it, choose Change Chart Type, and select XY (Scatter).
How can I check whether imported values are stored as text?
Select the data cells and look for Excel's number-stored-as-text warning. If it appears, use the warning menu's Convert to Number option, then check the chart again.
Should the X and Y ranges include column headers?
When editing Series X values and Series Y values in Select Data, select only the data cells. The two ranges should cover corresponding rows and have the same number of values.




