Chart & Visualization Issues

How to Fix Excel Edit Series Not Showing Separate X and Y Values

Chanuka GeekiyanageChanuka Geekiyanage Nov 2, 2026 869 views

Question details

The user is unable to find separate input fields for X-values and Y-values in the Edit Series dialog when modifying an Excel chart.

How to Fix Excel Edit Series Not Showing Separate X and Y Values
Product
Excel
Device & OS
not provided
Scenario
Editing data series in an existing chart to assign specific X and Y values.
Observed behavior
The Edit Series dialog only shows options for the series name and series values, lacking distinct X-value and Y-value input fields.
Before you start

Verify the type of chart you are currently using, as different chart types handle axis data uniquely. Ensure your data table contains distinct numeric columns for both X and Y values before modifying the chart.

Solution 1Recommended

Change Chart Type to XY Scatter

Convert the existing line chart to an XY Scatter chart, which inherently supports independent X and Y values for each data series.

Line charts treat the horizontal axis as a shared category axis for the entire chart, meaning you cannot set individual X-values for each data series. An XY Scatter chart maps two numeric variables against each other, unlocking the separate X-values and Y-values fields within the Edit Series dialog.

1
Select the Chart

Click anywhere on your existing line chart in the spreadsheet to select it.

2
Open Change Chart Type

Navigate to the 'Chart Design' or 'Design' tab on the top ribbon and click the 'Change Chart Type' button.

3
Select Scatter Chart

In the dialog box, select 'X Y (Scatter)' from the list of chart types. If you want the visual appearance of a line chart, choose the 'Scatter with Straight Lines' or 'Scatter with Smooth Lines' subtype.

4
Edit the Data Series

Right-click the newly formatted chart and select 'Select Data'. Choose your data series and click 'Edit'. You will now see the separate 'Series X values' and 'Series Y values' input fields.

Change Chart Type to XY Scatter
Retaining Visual Styles: Scatter charts with straight or smooth lines look identical to standard line charts but give you complete mathematical control over the X and Y coordinates.
Advanced Data Visualization

Create and Edit Scatter Charts Easily with WPS Spreadsheet

WPS Spreadsheet provides intuitive tools for creating professional XY Scatter charts. You can seamlessly manage multiple data series, assign specific X and Y values, and customize your visualizations.

  1. 1. Prepare Data: Highlight your columns containing the respective X and Y data points in WPS Spreadsheet.
  2. 2. Insert Chart: Go to the 'Insert' tab on the ribbon and click on the 'Scatter' chart icon.
  3. 3. Choose Subtype: Select your desired scatter chart style (e.g., points only, straight lines, or smooth lines).
  4. 4. Modify Values: Right-click the chart, choose 'Select Data', and easily modify distinct X and Y values for any data series.
100% compatible with Microsoft Excel (.xlsx) formats and chart types.Intuitive chart creation and easy-to-use 'Select Data' dialogs.Free, lightweight, and features a familiar user interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my line chart only let me edit horizontal category axis labels?

Line charts are strictly designed to plot continuous data over equal intervals or categories. As a result, they share a single horizontal category axis for all series. You can only set the category labels once for the entire chart, rather than setting specific numeric X-values per series.

Can I plot multiple series with completely different X-values on the same chart?

Yes, but you must use an XY Scatter chart instead of a Line chart. Scatter charts plot independent pairs of numerical data, allowing each individual data series to have its own unique set of X-values and Y-values.

Will my scatter chart look like a line chart if I change the type?

Yes. When converting, you can choose the 'Scatter with Straight Lines' or 'Scatter with Smooth Lines' chart sub-type. This provides the exact visual appearance of a traditional line chart while retaining the technical ability to edit X and Y values separately.