Combination graph let you display different types of data in different ways on the same chart. You may display columns, lines, areas all on the same combination chart and below blog you will see how it is easy to Create Combined Graph in Tableau only you need to make sure what dimension you need to consider for what.
What is use of Combined chart?
Combined charts combine more than one chart type in the single chart. One way you can use a combined chart is to show actual values in columns together with a line that shows a goal or target value.
Another example, Sales can be presented by bar or margin can be presented as line chart in single chart. So that user can compare both at a time looking at single chart. This is useful when you have to compare actuals with targeted value.
Below dataset use to create combined graph in Tableau.
Steps:
- First step is to drag region in Column and Measures values in Rows
- It will show all measures available in dataset in Marks Area
- You need to remove those measure which don’t needed for Bar graph (like in below image only we have left Total Cost and total profit)
- Now drag Total Revenue next to the Measures Values in Rows
- And change into Dual Axis
- In Marks Area change Measures value into Bar chart
- In Marks Area change Total Revenue into Line chart
- As you can see above image Total Cost and Total Profit is as stack bar
- To convert it you need to off the stack marks option from Analysis menu.
- Now drag Measures name on colours and size option in Marks Area as shown below Image
- After that, tableau will automatically change the colour and size of 2 bar.
- If you like you can change the size and colour according to your choice.
- At the end change the line colour in Red to make the final combined chart.
Watch Video Guide:
Below are the few more chart can be created in tableau, steps wise guide for easy to design.