Fix an Excel Secondary Axis Chart That Plots a Series Too High
Question details
The user needs an Excel chart to plot a series at its own value rather than adding it to another series.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A line chart uses primary and secondary axes to display multiple data series.
- Observed behavior
- A gray series appears too high because the stacked line chart adds it to a preceding series.
Check the source values for each series and select the chart so you can inspect its chart type. Identify which series should use the primary axis and which should use the secondary axis.
Change the stacked line chart to a regular line chart
Use a regular line chart to plot each series independently, then assign the appropriate axis to each series.
A stacked line chart adds series values together. For example, a value of 177 stacked on 132 can appear at 309 rather than at its independent value.
Select the chart, then go to Chart Design > Change Chart Type.
Select Combo and choose Line, not Stacked Line, for each series that should be plotted independently.
In the Combo chart settings, select the Secondary Axis checkbox for the series that needs it. Leave the other series on the primary axis, then click OK.
Compare the plotted points with the source cells. If the chart still looks misleading, right-click an axis, select Format Axis, and review its bounds and units.

Work with spreadsheet charts in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel workbooks in WPS Spreadsheet to review data and charts as you move between office suites.

Frequently Asked Questions
Why is my Excel line plotted above its actual value?
The chart may use a stacked line type, which adds a series to the preceding series. Select the chart and open Chart Design > Change Chart Type to check whether Stacked Line is selected.
How do I put a series on the secondary axis?
Select the chart, open Chart Design > Change Chart Type > Combo, and select Secondary Axis for the series you want to plot against the right-hand axis.
Does a secondary axis prevent lines from being stacked?
No. Axis assignment and chart type are separate settings. Choose a regular Line chart instead of Stacked Line when you want series to plot independently.
Why does a line still look high after I switch chart types?
The primary and secondary axes may have different scales. Read the series against its assigned axis, or right-click that axis and choose Format Axis to review its bounds and units.




