Chart & Visualization Issues

Fix an Excel Scatter Plot Using Row Numbers Instead of Data Values

Maira MehtabMaira Mehtab Nov 18, 2026 871 views

Question details

The user needs an Excel scatter plot to use GDP per capita values on the horizontal axis instead of row positions.

Fix an Excel Scatter Plot Using Row Numbers Instead of Data Values
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.
Before you start

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.

Solution 1Recommended

Assign X and Y Values to the Existing Scatter Series

Use this method to correct the data ranges in an existing Excel scatter plot.

1
Open the data source

Right-click the chart and select Select Data.

2
Edit the series

Under Legend Entries (Series), select the series and click Edit.

3
Set the X values

In Series X values, select the numeric GDP per capita cells, excluding the column header.

4
Set the Y values

In Series Y values, select the corresponding health expenditure percentage cells. Click OK, then OK again.

Assign X and Y Values to the Existing Scatter Series
Check the chart type: If the chart is a line chart, right-click it and choose Change Chart Type, then select XY (Scatter). A line chart uses categories rather than paired numeric X and Y values.
Create scatter plots in WPS Office

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. 1. Open the data: Open your workbook in WPS Spreadsheets and locate the GDP per capita and health expenditure columns.
  2. 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. 3. Select the data: Select both columns, including their headers if present.
  4. 4. Insert a scatter chart: Choose Insert > Scatter and select a chart style. Check that GDP per capita appears on the horizontal axis.
Plot numeric GDP per capita values against health expenditure percentages.Open and edit Microsoft Excel XLS and XLSX files.Use familiar spreadsheet and chart tools.Create charts with a free office suite.
microsoft office alternative - wps office

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.