Lollipop Charts in Tableau

by Juhie Radia

In this blog we will go through how to make a lollipop chart. The sample superstore data on tableau is being used to feel free to follow along or use your own dataset.

Step 1: left click and drag the sub category field to rows

Step 2: left click and drag the sales field to columns

Step 3: repeat the previous step, so the sales field appears twice (side by side) in the columns shelf

Step 4: Create a dual axis by right clicking the second sales field in the columns shelf and selecting the dual axis option, so that the 2 separate graphs become one with the same axis

Step 5: In the second sales marks card, in the dropdown marks menu, select circle

Step 6: In the first sales marks card, in the dropdown marks menu, select bar

Step 7: right click on the second sales axis that appears and select the synchronize option, this is to make sure that both sales axes are equivalent and match each other

step 8: right click on the sales axis at the top and deselect show header to remove the top axis since both the top and bottom sales axis are now the same so there is no point in having 2 as it just takes up unnecessary space

Step 9: In the first sales marks card, change the size of the bars by toggling the blue marker that appears, feel free to edit the size until you are happy

Step 10: If you haven't already change the view from standard to entire

Step 11: In the second sales marks card, select the size mark and toggle the blue marker that appears to change the size of the circles, feel free to adjust the size until you are happy

Step 12: Sort the lollipop bars in descending by selecting the icon shown

Step 13: your lollipop chart is now complete, I hope this worked out for you too!

Wed 08 Sep 2021

Tue 21 Sep 2021

Mon 13 Sep 2021

Thu 16 Sep 2021