Chart & Visualization Issues

How to Fix Excel Scatter Chart Using Row Numbers Instead of X Values

WPS Content Manager Oct 10, 2026 869 views

Question details

The user needs to correct a scatter chart that is incorrectly plotting sequential row numbers on the X-axis rather than the designated X-coordinate data column.

How to Fix an Excel Scatter Chart Showing Row Numbers Instead of X Values

Product: Excel
Device & OS: not provided
Scenario: Creating or updating a scatter chart with specific X and Y numerical coordinate data.
Observed behavior: The chart's X-axis displays row order numbers instead of referencing the actual intended numerical data column for the X values.

Before you start

Ensure your dataset is organized into adjacent columns without empty rows, and clearly label your X and Y columns with distinct headers to help the software automatically identify the data correctly.

Solution 1Recommended

Edit and Reassign the Data Source Series

Manually editing the chart's data source ensures Excel explicitly maps the correct columns to the X and Y axes instead of defaulting to row numbers.

When Excel cannot determine which column represents the X-axis, it defaults to using the row index (1, 2, 3, etc.). Explicitly setting the Series X and Y values resolves this issue.

Open the Data Source dialog

Right-click anywhere on the scatter chart and select "Select Data" from the context menu.

Edit the data series

In the "Select Data Source" dialog box, click on your data series listed under "Legend Entries (Series)" and click the "Edit" button.

Assign Series X values

Clear the text in the "Series X values" field, then highlight the specific range in your worksheet containing your X coordinates (e.g., D6:D14).

Assign Series Y values

Clear the text in the "Series Y values" field, and select the corresponding Y coordinate range in your worksheet (e.g., E6:E14).

Apply changes

Click "OK" twice to apply the new data source ranges. Your chart should now reflect the correct X values.

Edit and Reassign the Data Source Series

Include Headers: If you are selecting a complete range for a new chart, ensure you include the header row (e.g., D5:F14) so the series names are generated automatically.

Solution 2

Adjust X-Axis Bounds to Automatic

If the data source is correct but the chart still looks incorrect, the axis scale or bounds might be manually constrained, hiding the actual X values.

Easily Create Scatter Charts in WPS Office

Use WPS Spreadsheet for Accurate Data Visualization

WPS Spreadsheet provides a highly intuitive interface for plotting data. Its intelligent chart wizard easily maps X and Y columns correctly by default, preventing issues like row numbers appearing on the X-axis.

1. Prepare your data: Open your dataset in WPS Spreadsheet and ensure your X and Y values are in adjacent columns.
2. Select the data range: Highlight the two columns containing your X and Y values, including their header names.
3. Insert the scatter chart: Go to the "Insert" tab on the top ribbon, click the "Scatter" chart icon, and select your preferred scatter style.
4. Verify data mapping: If any adjustments are needed, simply right-click the chart, choose "Select Data", and visually define your X and Y ranges in the pop-up dialog.

Smart chart creation wizard that accurately maps adjacent X and Y columns automatically.Full compatibility with Microsoft Excel (.xlsx) file formats, preserving all chart data.Free, lightweight, and fast alternative for seamless data analysis and visualization.Easy-to-use 'Select Data' interface for quick modifications to your chart ranges.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my scatter chart look like a line chart with row numbers?

You may have accidentally selected a "Line Chart" instead of a "Scatter Chart". Line charts treat the first column as category labels or default to sequential row numbers if they cannot parse the labels, rather than treating them as numerical X-values. Ensure you explicitly insert a "Scatter" chart type.

Can I use text values on the X-axis of a scatter chart?

No, scatter charts are strictly designed to plot numerical data on both the X and Y axes. If you attempt to use text values for the X-axis, the software will ignore the text and default to sequential row index numbers (1, 2, 3...). If your X-axis relies on text categories, use a Line or Column chart instead.

How do I switch the X and Y axes on my scatter chart?

To swap the axes, right-click the chart and choose "Select Data". Click your series and select "Edit". Manually swap the cell ranges defined in the "Series X values" and "Series Y values" boxes, then click OK.

Excel & Data Problems