Show Missing Excel Chart Series on Primary and Secondary Y-Axes
Question details
Show all line chart series by assigning them to the appropriate primary or secondary Y-axis.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A line chart uses the primary Y-axis for positive values and the secondary Y-axis for negative values.
- Observed behavior
- Some series appear in the legend but are not visible because they are assigned to an axis that does not show their values.
Identify the missing series in the chart legend and check their source values. Note which Y-axis and scale should display each series.
Assign Missing Series to the Correct Y-Axis in Excel
Use this method when a series appears in the legend but is plotted on the wrong axis.
Click the chart, open the Chart Format tab, and use the Current Selection drop-down to choose the missing series.
Click Format Selection to open the Format Data Series pane, then select Series Options.
Under Plot Series On, select Primary Axis for a positive-value series that belongs on the primary scale. Select Secondary Axis for a series that belongs on the secondary scale.
If the series is still hidden, right-click its Y-axis, choose Format Axis, and check that the Minimum and Maximum bounds include the series values. Set the bounds to Auto if appropriate.
Use the Current Selection drop-down to select each remaining missing series and check its axis assignment.

Adjust Chart Series Axes in WPS Spreadsheet
Open your workbook in WPS Spreadsheet and use the series formatting options to place chart data on the appropriate primary or secondary axis.
- 1. Open the workbook: Open WPS Spreadsheet, select Open, and choose the Excel workbook containing the chart.
- 2. Select a chart series: Click the chart and select the series you want to adjust. If it is difficult to see, use the chart formatting controls to select the series by name.
- 3. Change its axis: Right-click the selected series, choose Format Data Series, and under Series Options select Primary Axis or Secondary Axis.
- 4. Check the chart and save: Review the chart to confirm the series is visible, adjust the Y-axis bounds through Format Axis if needed, and select Save.

Frequently Asked Questions
Why is a chart series in the legend but not on the chart?
The series may be assigned to a Y-axis whose bounds do not include its values. Select the series through Chart Format > Current Selection, then check its axis assignment in Format Data Series.
How do I select a series that I cannot see?
Click the chart, open the Chart Format tab, and choose the series by name from the Current Selection drop-down. Click Format Selection to edit it.
Do negative values have to use the secondary axis?
No. Negative values can appear on either axis as long as that axis includes them. In Format Axis, check the Minimum and Maximum bounds for the assigned axis.
What should I check if changing the axis does not reveal the series?
Right-click the assigned Y-axis and choose Format Axis to check its bounds. Also use Chart Design > Select Data to verify that the series points to the intended source cells.




