Chart & Visualization Issues

Fix Excel Scatter Plot Cannot Select X and Y Values Together

Camila MilosovichCamila Milosovich Nov 3, 2026 870 views

Question details

The user is unable to select both X and Y values simultaneously when adding a data series to an Excel scatter plot because the Y values input field becomes unresponsive.

How to Fix Excel Scatter Plot Cannot Select X and Y Values Together
Product
Microsoft Excel
Device & OS
not provided
Scenario
Adding a new data series to an XY scatter chart via the Select Data Source dialog box.
Observed behavior
The Series Y values box turns white and becomes unselectable immediately after selecting the Series X values, forcing the user to close and reopen the dialog box to continue editing.
Before you start

Ensure that the chart type you are working with is strictly an 'XY (Scatter)' chart, and verify that your selected data ranges contain only compatible numeric values without hidden errors or text strings.

Solution 1Recommended

Input X and Y Ranges Sequentially in the Select Data Source Dialog

Follow a strict selection sequence and clear default values to prevent the data selection fields from locking up.

Often, the dialog box freezes or disables fields because the default array '={1}' in the Y values field is not cleared properly, or the cursor loses focus. A careful, sequential approach usually bypasses this glitch.

1
Open Select Data Source

Right-click your scatter chart and choose 'Select Data...' from the context menu to open the Select Data Source dialog box.

2
Add a New Series

Click the 'Add' button under the Legend Entries (Series) section on the left.

3
Select X Values

Click inside the 'Series X values' field and highlight your desired X range on the spreadsheet.

4
Clear and Select Y Values

Immediately click inside the 'Series Y values' field, backspace or delete the default '={1}' value completely, and highlight your corresponding Y range before clicking OK.

Input X and Y Ranges Sequentially in the Select Data Source Dialog
Tip for Seamless Selection: You can also try typing the cell references manually (e.g., =Sheet1!$B$2:$B$10) instead of dragging the mouse to prevent the dialog from losing focus.
Free Microsoft Office alternative

Create Scatter Plots Seamlessly in WPS Spreadsheet

If Microsoft Excel continues to freeze or lock up during chart creation, consider switching to WPS Office. WPS Spreadsheet offers a lightweight, bug-free charting experience with full support for advanced scatter plots, completely free of charge.

  1. 1. Open Your File in WPS: Launch WPS Spreadsheet and open your existing Excel workbook.
  2. 2. Insert Scatter Chart: Highlight your data, navigate to the Insert tab, and click the Scatter Chart icon.
  3. 3. Easily Edit Data Series: Right-click the chart and choose 'Select Data' to fluidly add or modify X and Y series without interface freezes.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Intuitive and stable chart creation wizard without locking dialog boxes.Free and lightweight, requiring significantly fewer system resources.Familiar user interface makes switching effortless.
QA img-9

Frequently Asked Questions

Why does my scatter plot Y values box say '={1}' by default?

Excel automatically populates the Y series field with a default array '={1}' so that the chart has placeholder data and doesn't throw an error before you select your actual data. You must delete this default value entirely before selecting your Y values range.

Can I select non-contiguous ranges for X and Y values?

Yes, you can hold down the Ctrl key while selecting cells to include non-contiguous data. However, you must ensure both the X and Y series end up with the exact same number of data points, or the scatter plot will fail to generate.

What should I do if my scatter plot plots X and Y as two separate series?

This happens if you accidentally inserted a Line Chart instead of an XY (Scatter) chart. Line charts treat both columns as Y values against a generic X-axis. To fix this, right-click the chart, select 'Change Chart Type', and choose 'XY (Scatter)' to plot the values on both axes correctly.