Tableau Charts: Divergent bar chart - Makeover

May 6, 2019

This is a makeover of the previous article on divergent bar chart. So, why re-do this chart? What is it different from the previous one? I know those are the questions lingering in your mind. The perfect response would be, this new amendment helps interpret this chart well, especially when difference between metrics being compared is small.

Divergent bar chart helps users compare a dimension against two measures. But you’ll note that, when the existing different between these measure fields being compared is small, the visual difference can be lost. Therefore, this article introduces proportional comparison aspect to help interpreting data in such scenarios. This is enabled by plotting the maximum value of the two fields being compared.

I will be using data on Superstores, to compare Sales for East & West Region for different product Sub-Category’s.

Therefore, here is my calculations for the two measure fields I will be using.

 

Using the previous article’s procedure, I will create a simple divergent bar chart, shown below.

Learn how to create a simple divergent bar chart in Tableau

Next, I will need to create an LOD calculation to help select the maximum Total Sales between East & West Region for each product Sub-Category.

Now for the left side metrics.

  • Choose bar under the marks card

  • Drag the calculated field - Max Total Sales - to the left side of the Columns shelf

  • Reverse the axis

  • Change axis to dual axis

  • Synchronize the axis

Next

Select the bar supported by this new calculated field – chose ‘white’ color or ‘Background color’ for your case, add a border line – for this case – black border line.

Repeat the same for the metrics on the right side as shown below;

Executing this we’ve;

Comparing this with the previous divergent chart, you’ll agree with me that this provides an extra detail on where metrics fall compared to the maximum of the comparison pair – just like for the case of bar-in-bar chart.

Learn how to create a bar-in-bar chart in Tableau

I hope this article was helpful to you. To receive such articles on data visualization with Tableau.

Kindly subscribe to the emailing list, and you’ll be the first to know when we post.

Thanks for reading.

 

Share on Facebook
Share on Twitter
Please reload

Featured Posts
Please reload

YOU MIGHT ALSO LIKE
Please reload