Disclaimer: Pardon me for the typos or any grammatical errors. Also let me know for any finer technicalities if I have missed.
Dual Axis Chart in Tableau
1 It is also called as combination charts. It involves two axes which are independent of each other & are used to compare two measures which have different scales.
2 For creating dual axes you need continuous data fields, For example Sales , revenue ,profit and date fields .
3 In the explanation I will use sample store data set which I have found free on google, you can use any data you want.
Dual Axis chart with two measures
1 We have Sales, Profit, and Sub-Category fields in our sample data set. We will use sales and profit for making dual axis chart.
2 For Creating Dual Axis chart first Drag Sub-Category into Columns.
3 And Drag Sales and profit into Rows.
4 Right Click on Second measure on rows sum(Profit) in our case and select Dual Axis .
5 Now you can see Dual Axis chart of Sales and Profit but if you notice both the measures have different marks cards & you can format two measures differently.
6 If we want to have a bar chart for Sales, click on the SUM(Sales) section on the Marks card and choose Bar from the drop down menu.
7 Also you can select Line Chart for Profit from Sum(Profit) section of marks card.
8 You can decide whether or not two axes should be synchronized.To do so, right click on the Profit axis and select Synchronize Axis.
9 And here our Bar & Line Dual Axis chart or Combination Chart is ready.
Dual Axis Map with two measures
1 To Create Dual Axis map select States into data pane .
2 Now select profit into colors ,and change chart to Map. This is a map for Profit.
3 Press control “ctr” and drag latitude next to latitude and we get two maps.
4 Now in the marks card of second map remove profit and drag sales into size and select circle from drop down also adjust the size ,color, border if you want .
5 Once you get two separate maps for Sales & Profit respectively, to make dual axis map we simply click on second latitude from rows and select Dual Axis.
6 And our Dual axis map for Sales & Profit is ready.
I hope that this helps you to understand how to create Dual Axis Chart & Map in Tableau.
You can also visit my channel to watch video of how I created Dual Axis Chart & Map on sample data set.
"https://www.youtube.com/watch?v=9XdCWY-YUOg"
Please comment below if you need information on any other topic in tableau.
No comments:
Post a Comment