Table of contents

Add a secondary axis

Your browser does not support video.

Try it!

In Excel, you can add a secondary axis to your chart to show different values than the original axis.

  1. Select a chart to open Chart Tools.

  2. Select Design > Change Chart Type.

  3. Select Combo > Cluster Column - Line on Secondary Axis.

  4. Select Secondary Axis for the data series you want to show.

  5. Select the drop-down arrow and choose Line.

  6. Select OK.

Want more?

Add or remove a secondary axis in a chart in Excel

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!