Chart & Visualization Issues

Add a Secondary Axis with a Different Scale in Excel

Ayan MasoodAyan Masood Nov 13, 2026 870 views

Question details

Add a secondary vertical axis to an Excel chart so two data series can use different scales.

Add a Secondary Axis with a Different Scale in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the series

Click the chart, then click the data series you want to plot against the secondary axis.

2
Open series settings

Right-click the selected series and choose Format Data Series.

3
Enable the secondary axis

Under Series Options, select Secondary Axis. A second vertical axis should appear on the right side of the chart.

4
Adjust the scale

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.

Assign the Data Series to a Secondary Axis in Excel
Check the series and chart type: If Secondary Axis is unavailable, check that you selected a data series rather than the chart background and that the chart type supports a secondary axis.
WPS Spreadsheets

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. 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select your Excel workbook.
  2. 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. 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. 4. Set the scale: Right-click the secondary vertical axis, choose Format Axis, and adjust the bounds and number format as needed.
  5. 5. Save the workbook: Choose File > Save or Save As to keep the updated chart.
Display chart series with different ranges on separate vertical scales.Open and edit Microsoft Excel XLSX and XLS files.Adjust axis bounds and number formats from chart formatting controls.
microsoft office alternative - wps office

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.