The Tableau Dual Combination Chart is very useful to visually compare one Measure against Other measures. In this article we will show you, How to create Dual Combination Chart in Tableau with example.
For this we are going to use the Data Source that we created in our previous article. Please visit Data Labels in Tableau Reports article to understand the Data Source.
Tableau Dual Combination Chart Example
In order to create a Tableau Dual Combination Chart First, Drag and Drop the Order Date from Dimensions Region to Columns Shelf.
Next, Drag and Drop the Sales Amount, and Total Product Cost from Measures Region to Rows Shelf. Since they are Measure values, both Sales Amount and Total Product Cost values are aggregated to default Sum. Once you drag them, Line Chart will be generated as we shown below.
Let me change this to Dual Combination chart. To do so, Please expand the Show Me window and select the Dual Combination Chart from it
TIP : We already explained the manual process of creating Dual Combination Charts in Tableau Dual Axis article. So please refer the same.
Once you select the Dual Combination from Show Me window, Dual Combination Chart will be displayed as shown in below screenshot.
You can Expand these Cards to change Sales Amount to Line, and Total Product Cost to Bar etc.
Let me change the Order date value from Year to All months present in each year to see more Bars, and detailed trend
Though it looks good but, if observe closely, the Maximum Axis values of Sales Amount is 1800K, where as Total Product Cost is 1000K.
If you have no problem, Leave as it is otherwise, Please select the Total Product Cost and select the Synchronize Axis.. option from the context menu
Now you can see the Dual Combination Chart with Synchronized Axis. You can also remove One axis
Add Data labels to Tableau Dual Combination Chart
To add data labels to Dual Combination chart, Please click on the Show Mark Labels button in the Toolbar.
Tableau Dual Combination Chart – Stacked
You can convert the existing Dual Combination Chart to Stacked Dual Combination chart. Let me add Country Name to Colors shelf
Highlight any block will show you the information of that particular slice.
Thank You for Visiting Our Blog