This is a Quick Tip on how to build lollipop charts in Tableau, so less reading and more jumping in. We are going to spend 5 minutes or less building our lollipop chart.

Data

Load the following data into Tableau Desktop / Public.

FlavourTotal Sales ($m)Total Quantity Sold (m)
Cotton Candy5.55
Watermelon45.5
Blue Raspberry4.44
Pink Lemonade33
Strawberry25

Worksheet

  • Drag Flavour onto Columns.
  • Drag Total Quantity Sold (m) onto Rows twice.
    • Right-click on the second Total Quantity Sold (m) and select Dual Axis.
    • Right-click on the header in and select Synchronize Axis.
  • Under Marks, you should have
    • All
    • SUM(Total Quantity Sold (m))
    • SUM(Total Quantity Sold (m)) (2) 
  • In All
    • Drag Flavour onto Color
  • In SUM(Total Quantity Sold (m))
    • Change the Mark Type to Bar.
    • Click on Size and reduce to a quarter.
  • In SUM(Total Quantity Sold (m)) (2)
    • Change the Mark Type to Circle.
    • Drag Total Sales ($m) onto Size.

Now adjust the visuals and now you should see the following:

Now you can see that the height of the lollipop stick gives you a visual way to see the total quantity of lollipops sold, and the size of the lollipop gives you the total sales. Let us compare Cotton Candy and Strawberry flavours and you can see that the quantity is the same, however, the total sales are vastly different.

Summary

I hope you all enjoyed this article as much as I enjoyed writing it. Do let me know if you experienced any issues recreating this Visualisation, and as always, please leave a comment below or reach out to me on Twitter @Tableau_Magic.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.