How to use Dual Axis Charts in Excel?

Dual axis charts, also called combo charts, are great when you have two different kinds of information to present in the same chart. For example, you can have a column chart representing sales data and a line chart representing commission amounts displayed together. Following steps are used to create maps:

  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.