Manage appointments, plans, budgets — it’s easy with Microsoft 365.​

Charts

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 Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

×