Chart & Visualization Issues

How to Fix Excel Scatter Plot Using Two Series Instead of X and Y Values

Rana Garcia Oct 20, 2026 868 views

Question details

The user wants to create a scatter plot using one column for X values and another for Y values, but Excel is creating two distinct series on a single axis.

How to Fix Excel Scatter Plot Using Two Series Instead of X and Y Values

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a standard scatter plot visualization from two columns of data in a spreadsheet.
Observed behavior: Excel treats both selected columns as independent data series plotted against a default index, rather than assigning one column to the X-axis and the other to the Y-axis.

Before you start

Verify that both columns contain valid numeric data. If numbers are formatted or stored as text, Excel will fail to plot them correctly on a numerical X-axis.

Solution 1Recommended

Use the Switch Row/Column Option

Quickly reorient how Excel interprets your data table to correctly map the X and Y coordinates.

Often, Excel misinterprets the data layout based on the dimensions of the selected range. The Switch Row/Column feature forces Excel to swap how it reads the categories and series.

Select the Chart

Click anywhere on the incorrect scatter plot to activate the Chart Tools on the ribbon.

Open Chart Design Tab

Navigate to the 'Chart Design' tab that appears at the top of the Excel window.

Switch Row/Column

Locate the 'Data' group and click on the 'Switch Row/Column' button to swap the data orientation.

Check the Axis: The chart should instantly update to show a single series with proper X and Y axis mapping.

Solution 2

Manually Assign X and Y Series Data

Explicitly define which data ranges belong to the X and Y axes if the automatic plotting fails.

Solution 3

Convert Text Formatted Data to Numbers

Ensure Excel recognizes your coordinates as numerical values so it can build a mathematical scatter plot.

WPS Spreadsheet

Easily Create Accurate Scatter Plots with WPS Spreadsheet

WPS Spreadsheet provides an intuitive chart interface that automatically detects X and Y variables for scatter plots, making complex data visualization quick and error-free.

1. Open Your Data File: Launch WPS Spreadsheet and open the file containing your dataset.
2. Select the Data: Highlight the two columns containing your intended X and Y values.
3. Insert the Scatter Plot: Navigate to the 'Insert' tab on the top menu, click the 'Chart' icon, and select 'Scatter' from the list of chart types.
4. Confirm Axis Mapping: WPS Spreadsheet will instantly generate the chart, correctly mapping the first column to the X-axis and the second to the Y-axis.

Automatically identifies X and Y axes accurately upon selectionFully compatible with Microsoft Excel (.xlsx) data and chart formatsFeatures a clean, familiar interface with easy-to-use chart editing toolsLightweight, fast, and completely free to use

microsoft office alternative - wps office

Frequently Asked Questions

Why is my scatter plot showing a single line instead of dots?

This usually happens if you accidentally inserted a 'Line Chart' instead of a 'Scatter Plot'. Select your chart, go to the Chart Design tab, click 'Change Chart Type', and explicitly choose 'XY (Scatter)'.

How do I swap my X and Y axes on an existing scatter plot?

Right-click the chart and choose 'Select Data'. Click 'Edit' on your data series. Swap the cell references in the 'Series X values' box with those in the 'Series Y values' box, then click OK.

Why does my scatter plot group all data points onto a single X-axis value?

This occurs when Excel cannot read the X-axis data as numbers, often because the cells are formatted as text or contain hidden spaces. Convert the X-axis column to numeric formatting using the 'Format Cells' menu or the 'Convert to Number' alert.

Excel & Data Problems