In Excel, how do you add a secondary x-axis?

I created a bar chart in Microsoft Excel (v2016) and I am trying to create a secondary x-axis. Please help!

1 Answer

Relevance
  • Anonymous
    1 month ago

    Select a chart to open Chart Tools.

    Select Design > Change Chart Type.

    Select Combo > Cluster Column - Line on Secondary Axis.

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

    Select the drop-down arrow and choose Line.

    Select OK.

    • Login to reply the answers
Still have questions? Get your answers by asking now.