• Bernard

Tableau Charts: Divergent bar chart - Makeover

Updated: Sep 3, 2020

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 better, 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.

Useful: Learn how to create a simple divergent bar chart in Tableau

Next, I will need to create a Level of Detail (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


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.

Helpful: 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 join our mailing list by subscribing below.

Thank you for reading.


Top 35 Data Visualization Widgets

Take your data visualization skills to the next level with this FREE guide!!

FREE Tableau Desktop Course for Beginners

Get started with Tableau, a data visualization tool that allows you connect to nearly any data and create interactive visualizations.