Fix Excel Scatter Plot Cannot Select X and Y Values Together
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.

- 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.
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.
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.
Right-click your scatter chart and choose 'Select Data...' from the context menu to open the Select Data Source dialog box.
Click the 'Add' button under the Legend Entries (Series) section on the left.
Click inside the 'Series X values' field and highlight your desired X range on the spreadsheet.
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.

Test Excel in Safe Mode and Run Office Repair
If the dialog box is genuinely freezing due to software conflicts or corrupted program files, running Safe Mode and an Office Repair can resolve it.
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. Open Your File in WPS: Launch WPS Spreadsheet and open your existing Excel workbook.
- 2. Insert Scatter Chart: Highlight your data, navigate to the Insert tab, and click the Scatter Chart icon.
- 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.

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.




