Chart & Visualization Issues

How to Set X and Y Values in an Excel XY Scatter Chart

Maira Mehtab Oct 21, 2026 868 views

Question details

The user needs to specify the exact X and Y data ranges for an Excel XY scatter chart that is currently displaying as blank.

How to Set X and Y Values in an Excel XY Scatter Chart

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a custom XY scatter chart where the X and Y axes data ranges need to be manually assigned for accurate plotting.
Observed behavior: The inserted XY scatter chart appears blank, and the specific menu to input the X-axis and Y-axis data ranges is not immediately obvious to the user.

Before you start

Ensure that your dataset contains compatible numeric data for both the X and Y axes, arranged in clearly defined columns or rows without blank cells.

Solution 1Recommended

Manually Select Data Ranges for X and Y Axes

Use the Select Data menu to manually assign specific cell ranges to your chart's X and Y axes, fixing the blank chart issue.

When Excel cannot automatically detect the relationship between your columns, it may insert a blank scatter chart. Manually defining the data series allows you to explicitly tell Excel which cells belong on the horizontal axis and which belong on the vertical axis.

Access the Select Data Menu

Right-click the blank scatter chart and choose 'Select Data' from the context menu.

Edit the Data Series

In the Select Data Source dialog box, select the data series you want to modify in the left pane, then click the 'Edit' button. If no series exists, click 'Add'.

Define X-Axis Values

In the Edit Series window, click inside the 'Series X values' box and drag to highlight the cells on your worksheet containing your horizontal axis data.

Define Y-Axis Values

Click inside the 'Series Y values' box, delete any existing content (such as '={1}'), and highlight the cells containing your vertical axis data. Click 'OK' to apply.

Manually Select Data Ranges for X and Y Axes

Data Compatibility: Scatter charts strictly require numerical data for both axes. Ensure there are no text strings or hidden characters in your data ranges, as this can cause the chart to remain blank or display incorrectly.

Create scatter charts easily

Create and Edit XY Scatter Charts Easily with WPS Spreadsheet

WPS Spreadsheet offers a highly intuitive interface for data visualization. You can quickly generate XY scatter charts and assign your X and Y values without navigating complex menus.

1. Open your data file: Launch WPS Spreadsheet and open your dataset containing the numeric values.
2. Insert a scatter chart: Highlight your data, navigate to the 'Insert' tab on the ribbon, and click the 'Scatter' chart icon to insert the graph.
3. Configure X and Y ranges: If you need to adjust the ranges, right-click the chart, choose 'Select Data', and easily define your X and Y data series.

Fully compatible with Microsoft Excel (.xlsx) files and chart formats.Intuitive Select Data interface for effortless X and Y axis configuration.Rich library of customizable chart styles and templates.Free and lightweight office suite for Windows, Mac, and Linux.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my Excel scatter chart showing only one data point?

This often happens if Excel misinterprets your data range and plots the X and Y axes as a single value. Right-click the chart, choose 'Select Data', and ensure your X and Y values are mapped to the correct separate columns.

How do I add titles to my X and Y axes in a scatter chart?

Select your chart, click the '+' icon (Chart Elements) that appears next to the chart, and check the 'Axis Titles' box. You can then click on the text boxes that appear on both axes to type your custom titles.

Can I plot multiple data series on the same scatter chart?

Yes. Right-click the chart and choose 'Select Data'. Click the 'Add' button in the Legend Entries (Series) section, and then define the new name, X values, and Y values for your second data series.

Excel & Data Problems