Secondary Axis in Excel

Robert K 60 Reputation points
2026-07-10T21:39:06.2+00:00

How do I define a secondary axis for a series in Excel? Where do I look on the ribbon?

Microsoft 365 and Office | Excel | For home | Windows
0 comments
Answer accepted by question author
Jeronimo Fuerte 45,750 Reputation points Independent Advisor
2026-07-10T22:22:57.2866667+00:00

To assign a data series to a secondary axis in Excel:

  1. Select the chart.
  2. Select the data series you want to place on the secondary axis.
  3. Go to the Chart Design tab on the ribbon.
  4. Select Change Chart Type.
  5. Choose Combo.
  6. Check the Secondary Axis box next to the desired series, and then select OK.

You can also right-click the data series, select Format Data Series, and under Series Options, choose Secondary Axis.

Please note that the Chart Design and Format tabs only appear on the ribbon after you select the chart.

Was this answer helpful?

3 people found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.