Bar-in-bar chart is simply two interlocking bar charts. Its useful when you need to illustrate change between two points. E.g. Profit between two timelines for different products or regions.
Example of a bar-in-bar chart
Best practices for creating a bar-in-bar chart in Tableau.
Use distinct color code to show fields of comparison.
Show axis for reference when interpreting the view.
Provide additional details on the tooltip.
Step by step guide on how to create a bar-in-bar chart in Tableau.
In this article I 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.
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)
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. To receive more of the Tableau tips and tricks, kindly join our mailing list by subscribing below.
Thank you for reading.