Chart & Visualization Issues

Fix Excel 2016 Scatter Charts Using Point Numbers Instead of X Values

Rana GarciaRana Garcia Nov 22, 2026 868 views

Question details

The user needs one series in an Excel 2016 scatter chart to use the selected X values rather than sequential point numbers.

Fix Excel 2016 Scatter Charts Using Point Numbers Instead of X Values
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
A scatter chart contains a series intended to plot Y values against a selected range of X values.
Observed behavior
Excel plots sequential point numbers instead of the selected X-axis values for one series.
Before you start

Locate the X and Y data ranges for the affected series and check that they contain matching numbers of data points. Note the chart's current type before changing its settings.

Solution 1Recommended

Assign the correct X values to the scatter chart series

Use this method to check the chart type, series ranges, and source data before repairing Office.

1
Check the chart type

Select the chart, open Chart Design > Change Chart Type, and confirm that the affected series uses an XY (Scatter) chart type.

2
Edit the affected series

Right-click the chart and select Select Data. Under Legend Entries (Series), select the affected series and click Edit.

3
Set the X and Y ranges

In the Edit Series dialog, set Series X values to the intended X-data range and Series Y values to the corresponding Y-data range. Click OK and check the chart.

4
Inspect the source data

Return to the worksheet and check the selected ranges for blank cells and numbers stored as text. Correct unintended blanks and convert text-formatted numbers to numbers, then inspect the chart again.

Assign the correct X values to the scatter chart series
Use numeric X values: An XY scatter series needs numeric X values. Make sure the X and Y ranges refer to corresponding data points.
Create an XY scatter chart

Plot X and Y values in WPS Spreadsheets

Use WPS Spreadsheets to create or edit a scatter chart from numeric X and Y data, and check the series ranges if the horizontal values are incorrect.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select the Excel workbook.
  2. 2. Check the data: On the worksheet, locate the intended X and Y columns and correct unintended blanks or numbers stored as text.
  3. 3. Create or inspect the chart: Select the X and Y data and choose Insert > Chart > Scatter, or select an existing scatter chart.
  4. 4. Check the series ranges: Use the chart's Select Data or Edit Series option to verify that the X values and Y values point to the intended ranges, then review the chart.
  5. 5. Save the workbook: Choose File > Save As and select an Excel format such as XLSX if you need to share the workbook with Excel users.
Plot numeric X values in an XY scatter chartOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interfaceCreate and review charts for free
microsoft office alternative - wps office

Frequently Asked Questions

Why does my scatter chart show 1, 2, 3 instead of my X values?

The series may have a missing or incorrect X-values range. Right-click the chart, choose Select Data, select the series, and click Edit to check Series X values.

How do I confirm that the chart is an XY scatter chart?

Select the chart and open Chart Design > Change Chart Type. Confirm that the affected series is set to an XY (Scatter) type.

Can numbers stored as text affect the X axis?

Yes. Check the cells in the series X-values range and convert any text-formatted numbers to numeric values, then review the chart.

What should I do if the X and Y ranges are correct but the chart is still wrong?

On Windows, try repairing Office through Control Panel > Programs > Programs and Features. You can also check for updates in Excel under File > Account > Update Options, if available.