Show Actual X Values in an Excel Scatter Plot
Question details
Show the actual numeric X values in an Excel scatter plot instead of sequential numbers.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to plot paired X and Y values, such as X values of 0.3, 1.5, and 3.
- Observed behavior
- The horizontal axis shows sequential numbers such as 1, 2, and 3 rather than reflecting the intended X values.
Place each X value beside its corresponding Y value, and check that both columns contain numbers. Note the cell ranges containing the X and Y values so you can verify the chart's data series.
Assign numeric X values to an XY Scatter chart
Use this method when the chart uses sequential positions instead of the intended X values.
Enter the X values in one column and the matching Y values in the next column, with each pair on the same row.
In an empty cell, enter =ISNUMBER(A2), replacing A2 with the first X-value cell. Fill the formula down to check the remaining values; FALSE means the value is not stored as a number.
Select any X values stored as text and use the warning icon's Convert to Number option, if available. Alternatively, select the cells and choose Data > Text to Columns > Finish.
Select both data columns, then choose Insert > Scatter (X, Y) and select a scatter chart style.
If an existing chart still uses sequential values, right-click the chart and choose Select Data. Select the series, click Edit, and set Series X values to the numeric X range and Series Y values to the matching Y range.

Label each scatter point with its exact X value
Use data labels when the axis scale is correct but you want to see the exact X value beside every point.
Plot numeric X values in WPS Spreadsheets
Use WPS Spreadsheets to arrange paired data and create an XY scatter chart that plots the numeric X values on the horizontal axis.
- 1. Open your worksheet: Open WPS Spreadsheets and use Open to select your Excel workbook, or create a new spreadsheet.
- 2. Arrange the values: Enter numeric X values in one column and the corresponding Y values in the adjacent column.
- 3. Insert a scatter chart: Select both columns, then choose Insert > Chart and select an XY Scatter chart.
- 4. Check the result: Review the horizontal scale and plotted points. If the positions are unexpected, check that the X cells contain numbers rather than text and recreate the chart from both columns.

Frequently Asked Questions
Why does my scatter plot use 1, 2, 3 for X values?
Excel may be using point positions because the intended X range was not assigned or its values are stored as text. Right-click the chart, choose Select Data, and edit the series to check its X values.
How can I check whether an X value is stored as a number?
Enter =ISNUMBER(A2) in an empty cell, replacing A2 with the X-value cell. TRUE indicates a number; FALSE indicates the value is not stored as a number.
Can the axis show every X value as a tick label?
An XY scatter axis uses a continuous numeric scale with regularly spaced ticks, so irregular values such as 0.3, 1.5, and 3 may not all appear as tick labels. Add data labels and select X Value to show the exact value of each point.
How do I change the horizontal axis scale?
Right-click the horizontal axis and choose Format Axis. Under Axis Options, adjust the bounds or major unit to change the displayed range or tick spacing.




