Fix Excel 2016 Scatter Charts Using Point Numbers Instead of X Values
Question details
The user needs one series in an Excel 2016 scatter chart to use the selected X values rather than sequential point numbers.

- 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.
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.
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.
Select the chart, open Chart Design > Change Chart Type, and confirm that the affected series uses an XY (Scatter) chart type.
Right-click the chart and select Select Data. Under Legend Entries (Series), select the affected series and click Edit.
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.
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.

Repair and update Microsoft Office
Try this if the series settings and source data are correct but Excel still plots point numbers.
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. Open the workbook: Open WPS Spreadsheets and use Open to select the Excel workbook.
- 2. Check the data: On the worksheet, locate the intended X and Y columns and correct unintended blanks or numbers stored as text.
- 3. Create or inspect the chart: Select the X and Y data and choose Insert > Chart > Scatter, or select an existing scatter chart.
- 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. 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.

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.




