Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

How To Add Secondary Axis In Excel Charts In Simple Steps

How To Add Secondary Axis In Excel Charts

Steps For Adding A Secondary Axis In Your Chart

Follow these simple steps to create a dual axis.

Method 1

  • Select the data series for which you want to add a secondary axis.

How To Add Secondary Axis In Excel Charts

  • Right Click on it & Go to Format Data Series → Series Option → Activate Secondary Axis.

Activate A Secondary Axis

  • Now, you have a two scales in your chart.

Activate A Secondary Axis

Alternate Method

  • Select the data series for which you want to add a secondary axis.
  • Go to Format Tab → Current Selection → Format Selection → Format Data Series → Series Option → Activate Secondary Axis.

click to format selection to add a secondary axis

Conclusion

You can add a secondary axis in your chart while creating a combo chart in your excel sheet.

More Tips

Back To Blog