How to Add Total Labels to Stacked Bar Charts in Tableau

Connect with us!

Description:
Have you ever tried to add a label to the end of a stacked bar chart in Tableau? I'm guessing it didn't work the way you wanted!

When you add a measure to the Label section of the Marks card, it adds a label to each section of stacked bar chart rather than an overall label for the entire bar.

It is possible to get a total label at the end of a stacked bar chart, but it requires a little Tableau trickery. Depending on your preference, a dual axis chart or a reference line might just be the trick you need!

Resources:

Chapters:
0:00 Intro
0:40 Reference Line Option
2:25 Dual Axis Option

[cathayat]

Thank you! It was very useful, really what I needed!

[luckymadhoo]

Thanks a lot. I dint know it was that easy 🙂

[Aquino-L-]

awesome! what if I want to have a all labels displayed in a stacked column chart along with the total but when filtered to single category then only display either the label or the total reference line; is there a way to ?

[markboyd]

What if my measure is a % value, not a # value? Each bar label displays the % for that segment, but adding the 'total %' displays the label near the middle of the stacked bar instead of the end, since it's using the same axis.

[swagatamchakraborty]

Great tip Eric! Thanks for showing both the approaches and I loved the second one.
I have one question : can we modify the default behaviour of selecting items in multiple dropdown in Tableau ? By default we select any item by clicking on the checkbox but if we want to select the item by clicking on the item itself like modern web forms, is it something that's not feasible in Tableau with the help of some workaround?
Thanks for bringing such high valued quick tips in Tableau!

[otis-lk]

excuse me sir, how could you record the video and make annotations directly like that? what app was it?