Tableau Lollipop Chart

In this article, we will show you how to Create a Tableau Lollipop Chart with an example. For this Tableau lollipop chart demo, we are going to write the Custom SQL Query against the SQL Server Data Source.

Please visit Connecting Tableau to SQL Server article to understand the Tableau configurations. The custom SQL query we are going to use for this Lollipop Chart in Tableau report is:

SELECT ProdSubCat.EnglishProductSubcategoryName, 
       Tery.[SalesTerritoryCountry], 
       Prod.EnglishProductName, 
       Prod.Color, 
       Fact.OrderQuantity, 
       Fact.TotalProductCost, 
       Fact.SalesAmount, 
       Fact.TaxAmt, 
       Fact.OrderDate
FROM DimProductSubcategory AS ProdSubCat
   INNER JOIN
     DimProduct AS Prod 
        ON ProdSubCat.ProductSubcategoryKey = Prod.ProductSubcategoryKey 
   INNER JOIN
     FactInternetSales AS Fact 
        ON Prod.ProductKey = Fact.ProductKey 
   INNER JOIN
     [DimSalesTerritory] AS Tery 
        ON Tery.[SalesTerritoryKey] = Fact.[SalesTerritoryKey]

Create a Tableau Lollipop Chart

In this example, we are going to create a Lollipop Chart in Tableau. First, Drag and Drop the English Product Name from Dimension Region to Rows Shelf and Sales Amount from Measures region to Columns Shelf, as shown below. By default, Tableau will generate the Bar Chart

Tableau Lollipop Chart 1

From the below screenshot, we used the filters to restrict the number of rows returned by the Bar Chart. So, our report will display the products whose sales amount is greater than or equal to 30,000,000

Tableau Lollipop Chart 2

Next, Drag and Drop the Sales Amount from Measures region to Columns Shelf as shown below

Tableau Lollipop Chart 3

By using the Tableau Dual Axis concept, Please merge measures in the column shelf. To do this, Please select the Sales Amount, and right-click on it will open the context menu. From that, Please select the Dual Axis option

Tableau Lollipop Chart 4

Once you complete, Let us change the Mark type from Automatic to more meaningful. First, Please select the Mark Type option of a Sales Amount axis and select the Bar Chart for now

Tableau Lollipop Chart 6

Next, Please change the Size of the Bar chart using the Size field present in Mark shelf

Tableau Lollipop Chart 7

Then, Please change the Color of the Bar chart using the Color field present in Mark shelf as shown below

Tableau Lollipop Chart 8

Now, we are increasing the Circle size by using the Size field present in Mark shelf

Tableau Lollipop Chart 9

If you are not comfortable to see both the Axes, Please select one of the Axis and unchecked the Show Header option as shown below

Tableau Lollipop Chart 10

To make our Tableau lollipop chart more colorful, We added the Color dimension to the Color field in Marks Shelf

Tableau Lollipop Chart 11

From the above screenshot, you can see we successfully created the lollipop chart

Formatting Tableau Lollipop Chart

To change the Circle of a Tableau lollipop chart, we have to change the Mark type from Automatic to Shape as shown below

Tableau Lollipop Chart 12

Next, Please click on the Shape filed and select the shape from the drop-down list. If you want more shapes for you to project, Please click on the More Shapes option

Tableau Lollipop Chart 13

Once you click on the More Shapes option, a new window called Edit Shape will open. Here we are selecting the Ratings pallete

Tableau Lollipop Chart 14

Next, we selected the below shown shape for this example

Tableau Lollipop Chart 15

Click OK to finish assigning the selected shape to our Tableau Lollipop Chart. Let us see our final report preview

Tableau Lollipop Chart 16

Comments are closed.