The series, Tableau charts has always focused on one thing, helping Tableau users learn how to create different charts and graphs hence equipping them with different techniques of telling each data story.
Inspired by the spirit of this series, we’ll learn how to build a dumbbell chart in Tableau. Using some dummy data on roofing structures by province in Kenya, connect to Tableau app and follow the guide below.
Step 1: Build a simple dual chart.
Drag dimension field Province to the rows shelf.
Drag measure field Percent to columns shelf. (Note, the field is aggregated by SUM() ).
Hold down CTRL key and drag SUM(Percent) to the column shelf next to the same aggregated field.
See resulting view.
Step 2: Add color to the chart.
Under marks card, select both the two charts.
Drag dimension field Roof Structure to the color shelf.
Step 3: Introduce Roof Structure to the path.
Doing some formatting we’ve.
From this chart, insights can be drawn without much struggle. For instance, one can spot that the Central & Rift Valley province have the highest percent use of both the roof structures. Use of Asbestos sheets tops in all the provinces except in Central province where use of Corrugated iron sheets surpasses that of Asbestos sheets.
I hope this article adds to your resource of some of the best techniques you can use to tell your data story. Thanks for reading.