Insert or delete a secondary axis in an Excel chart

Note: The following procedure applies to Office 2013 and newer versions. Looking for Office 2010 steps?

  1. Choose a chart to open Chart Tools.
  1. Click Design > Change Chart Type.
  1. Pick Combo > Cluster Column – Line on Secondary Axis.
  1. Pick Secondary Axis for the data series you prefer to emphasise.
  1. Choose the drop-down arrow and pick Line.
  1. Press OK.
%d bloggers like this: