September 22, 2015

Tableau Tip Tuesday: Using Lollipop Charts to Track Progress

I was first exposed to using lollipop charts to track progress by Alberto Cairo back in January 2013. In the viz, I used lollipop charts to show the percentage of educated and obese people by State in the U.S. I realized I never wrote about how to create them, so in this tip, I’m going to show you several things:

It’s a bit of a long video since there’s so much to cover. If there’s anything else you’d like me to create videos for, please let me know in the comments below.

NOTE: After creating the video, I did quite a bit of formatting on the visualisations to get the sorting to keep the sheets in sync and to create the second dashboard. I’d highly recommend you download the workbook to see how I did it. Particularly, see the LOD calc I had to create to get the sorting to work on the sparklines.