Excel – How to duplicate the Y-axis label of a chart to the other side

chartsmicrosoft excel

I have this chart in Excel with the Y-axis automatically placed on the left side of the chart.

Aside from inserting a textbox, is there any other way to duplicate that label to the other side or to the right side?

Best Answer

Add or remove a secondary axis in a chart in Excel:

  • 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.

Example Image