Tableau – Lollipop chart

A lollipop chart, also known as a dumbbell chart, is a type of data visualization that displays the difference between two values as a line segment connecting two circles. This type of chart is useful for comparing two values side-by-side and for showing the magnitude of the difference between them. Tableau, a popular data visualization software, provides an easy way to create lollipop charts using its drag-and-drop interface.

It is used to draw the attention of the viewer to the data value, rather than to the bar or column chart, and can be used to display both rank and value simultaneously.

Steps to create a Lollipop Chart 

Step 1 : Add a categorical variable to the Rows shelf

Step 2 : Add Numerical values on the columns shelf

Step 3 : Duplicate the Numerical Value to place in the columns shelf

Step 4 : Right click on the profit and select Dual axis option , next click on the profit axis and select synchronize axis option as shown below.

Step 5 :Change the first numerical variable’s chart to a circle and the second variable’s chart to a bar chart

Step 6 :  The two charts should be resized to resemble a Lollipop chart, as shown in the below screenshot.

This is how we can create a lollipop chart in tableau.