Chart & Visualization Issues

Show Actual X Values in an Excel Scatter Plot

Steven ParkerSteven Parker Nov 22, 2026 868 views

Question details

Show the actual numeric X values in an Excel scatter plot instead of sequential numbers.

How to Show Actual X Values in an Excel Scatter Plot
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.
Before you start

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.

Solution 1Recommended

Assign numeric X values to an XY Scatter chart

Use this method when the chart uses sequential positions instead of the intended X values.

1
Arrange the data

Enter the X values in one column and the matching Y values in the next column, with each pair on the same row.

2
Check the X values

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.

3
Convert text to numbers

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.

4
Create the scatter chart

Select both data columns, then choose Insert > Scatter (X, Y) and select a scatter chart style.

5
Verify the series ranges

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.

Assign numeric X values to an XY Scatter chart
Axis ticks versus data values: Excel chooses axis tick marks based on the scale, so not every X value necessarily appears as a tick label. Add X-value data labels if you need to display each point's exact value.
Create scatter charts in WPS

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. 1. Open your worksheet: Open WPS Spreadsheets and use Open to select your Excel workbook, or create a new spreadsheet.
  2. 2. Arrange the values: Enter numeric X values in one column and the corresponding Y values in the adjacent column.
  3. 3. Insert a scatter chart: Select both columns, then choose Insert > Chart and select an XY Scatter chart.
  4. 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.
Plot paired X and Y values in a scatter chartOpen and edit Microsoft Excel XLS and XLSX filesWork with spreadsheet data in a familiar interfaceUse WPS Office for free
microsoft office alternative - wps office

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.