Chart & Visualization Issues

Fix an Excel Secondary Axis Chart That Plots a Series Too High

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 870 views

Question details

The user needs an Excel chart to plot a series at its own value rather than adding it to another series.

Fix an Excel Secondary Axis Chart That Plots a Series Too High
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.
Before you start

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.

Solution 1Recommended

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.

1
Open chart type settings

Select the chart, then go to Chart Design > Change Chart Type.

2
Choose regular lines

Select Combo and choose Line, not Stacked Line, for each series that should be plotted independently.

3
Assign the axes

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.

4
Check the result

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.

Change the stacked line chart to a regular line chart
Axis scales can differ: A point's vertical position depends on the scale of its assigned axis. Read secondary-axis series against the axis on the right, not the primary axis on the left.
Free Microsoft Office alternative

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.

Create and edit spreadsheet charts using a familiar interfaceCompatible with Microsoft Excel formats such as XLSX and XLSFree and lightweight for everyday spreadsheet workOpen existing workbooks to make the transition easier
microsoft office alternative - wps office

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.