Add a Secondary Axis with a Different Scale in Excel
Question details
Add a secondary vertical axis to an Excel chart so two data series can use different scales.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A chart contains two related data series with substantially different measurement ranges.
- Observed behavior
- The chart should display one series against a secondary vertical axis with a suitable scale.
Open the workbook and select a chart containing the data series you want to compare. Identify the series that needs its own scale; a 2-D chart with two or more series is a typical choice.
Assign the Data Series to a Secondary Axis in Excel
Use Format Data Series to place the series with a different range on its own vertical scale.
Click the chart, then click the data series you want to plot against the secondary axis.
Right-click the selected series and choose Format Data Series.
Under Series Options, select Secondary Axis. A second vertical axis should appear on the right side of the chart.
Right-click the new vertical axis and choose Format Axis. Under Axis Options, adjust the bounds and units as needed, then use Number to set the appropriate format.

Add a Secondary Vertical Axis from Chart Design
Use the chart element menu to add the axis, then verify which series is assigned to it.
Create a Secondary Chart Axis in WPS Spreadsheets
Use WPS Spreadsheets to assign a chart series to a secondary axis and adjust its scale for comparison with another series.
- 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select your Excel workbook.
- 2. Select the chart series: Click the chart, then right-click the data series that needs a different scale and choose Format Data Series.
- 3. Choose the secondary axis: In the series formatting options, select Secondary Axis. The wording or location of this setting may vary by WPS version.
- 4. Set the scale: Right-click the secondary vertical axis, choose Format Axis, and adjust the bounds and number format as needed.
- 5. Save the workbook: Choose File > Save or Save As to keep the updated chart.

Frequently Asked Questions
How do I change the range of the secondary axis?
Right-click the secondary vertical axis and choose Format Axis. Under Axis Options, set the minimum and maximum bounds and adjust the units if needed.
Why can't I select Secondary Axis for my chart?
Make sure you right-clicked a data series and opened Format Data Series, not the chart background. Some chart types do not support a secondary axis; try a supported 2-D chart type.
Can I format the secondary axis as a percentage?
Yes. Right-click the secondary axis, choose Format Axis, and select Percentage under Number. Check that the underlying values are appropriate for percentage formatting.
How do I remove a series from the secondary axis?
Right-click the series, choose Format Data Series, and select Primary Axis under Series Options.




