How to Fix Excel Edit Series Not Showing Separate X and Y Values
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.

- 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.
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.
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.
Click anywhere on your existing line chart in the spreadsheet to select it.
Navigate to the 'Chart Design' or 'Design' tab on the top ribbon and click the 'Change Chart Type' button.
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.
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.

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. Prepare Data: Highlight your columns containing the respective X and Y data points in WPS Spreadsheet.
- 2. Insert Chart: Go to the 'Insert' tab on the ribbon and click on the 'Scatter' chart icon.
- 3. Choose Subtype: Select your desired scatter chart style (e.g., points only, straight lines, or smooth lines).
- 4. Modify Values: Right-click the chart, choose 'Select Data', and easily modify distinct X and Y values for any data series.

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.




