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.
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)
The way around this is to have a different axis for profit margin. Here is how you can do this:
- Click on any of the Profit margin bar. This will select all bars for profit margin.
- Right-click and select Format Data Series.
- 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.
- Right-click and select Change Series Chart Type
- In the Change Chart Type dialogue box, select Line with Markers option.
- That’s It. You would have the chart. Format it the way you want.