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.
Load the following data into Tableau Desktop / Public.
|Flavour||Total Sales ($m)||Total Quantity Sold (m)|
- 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
- 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.
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.