• Bernard

Tableau charts: Bar in bar chart

Updated: May 27

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 mission of this series, this article will demonstrate to you how to build a bar in bar chart using Superstores data sets pre-packaged with Tableau app, The goal here will be revisiting our earlier post on Divergent bar chart and see if we can tackle the same challenge using bar in bar chart. ( I know by the end of this article, you will agree with me that, bar in bar chart is a better chart for comparing two measures against a dimension when compared with divergent chart).

Like in our previous challenge, lets compute Sales for East and Central regions using the formula shown below.

Lets build our chart,..

  • Drag dimension Sub-Category to the Rows shelf.

  • Drag measure field East (Sales) to the Columns shelf.

  • Drag measure field Central (Sales) to the Columns shelf next to East (sales).

  • Right click on the right chart and choose Dual Axis.

Note, the resulting chart may change from bars to something different. To rectify this, chose bar under marks card for both the charts.

The last step is very simple, it involves making bars of the first chart thick and bars of the second chart thin. This is made possible by use of Size tab under the marks card.

Note in the 1st chart, the Size scroller is almost at the end (Signifying thick bars) while in the 2nd chart, the Size scroller is at the middle. (Signifying thin bars)

Resulting chart.

Looking at the previous article on Divergent bar chart, see below.

You will agree with me that bar in bar chart offers that instant insight, of being able to differentiate the top performing region in Sales without looking at the figures like in the case of divergent bar chart.

I hope this article was helpful to you.

Thanks for reading.