How to Create Combination Charts in Excel

Combination charts in Excel let you present and compare two different data-sets that are related to each other. For example, you may be interested in plotting the revenue figures of a company, and at the same time, also be able to show how the profit margin has changed. A combination chart (as shown below) is an apt way of doing this.Combination Charts in Excel

You can see that a revenue number is way higher than the profit margin (which is in %). In normal case, if you plot these two together, you would barely be able to see the profit margin in your chart (Something as shown below)

Combination Charts in Excel Primary Axis

The way around this is to have a different axis for profit margin. Here is how you can do this:

  1. Click on any of the Profit margin bar. This will select all bars for profit margin.
  2. Right-click and select Format Data Series.

Combination Charts in Excel - Select Format Data Series

  1. In the Format Data Series dialogue box, select Secondary Axis (in the Plot Series On group)
    • This will plot Profit Margin Data in a secondary Axis. You would be able to see a vertical axis on the right of the chart.

Combination Charts in Excel - Secondary Axis Selected

  1. Right-click and select Change Series Chart Type

Combination Charts in Excel - Select Change Series Chart Type Excel

  1. In the Change Chart Type dialogue box, select Line with Markers option.

Combination Charts in Excel - Select Different chart Excel

  1. That’s It. You would have the chart. Format it the way you want.
Related Tutorials: