Creating a Combination chart

A Combination chart is an extension of a Dual axes chart, where instead of having the measures shown using a single mark, we can have different marks. So, for example, in the preceding Dual axes chart, we have both Sales and Profit shown as Lines. We may want to show Sales as a bar and Profit as a line. If we do that, then the chart that will be created will be called as a Combination chart. In simple words, a Combination chart is nothing but a Dual axes chart with multiple marks.

Let us see how to create a Combination chart.

Getting ready

For creating a Combination chart, we will first duplicate the Dual axes chart and then convert it into a Combination chart. The steps are as follows.

How to do it…

1. Firstly, we will duplicate the Dual axes chart sheet and rename it to Combination chart.

2. Once we do that, we will look at the Marks card. Refer to the following image:

   

3. In the Marks card section, notice that there are three sub-sections called All, SUM(Sales) and SUM(Profit...