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