Tableau Lollipop Chart

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

Please visit Connecting to SQL Server article to understand the Tableau configurations. The custom SQL query we are going to use for this 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]

How to Create a Tableau Lollipop Chart

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

By default, it will generate the Bar graph.

Bar Graph 1

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

Change the Filter Condition to show profitable products 2

Next, for this Tableau Lollipop Chart, Drag and Drop the Sales Amount from the Measures region to Columns Shelf, as shown below.

Multiple Bar Charts 3

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

Choose Dual Axis from Menu 4

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

Change Marks from Automatic to Bar 6

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

Change the Bar Size 7

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

Change Tableau Lollipop Chart Color 8

Now, we are increasing the Tableau lollipop chart circle size by using the Size field present in the Mark shelf

Increase the Tableau Lollipop Chart Circles 9

If you are uncomfortable seeing both Axes, Please select one of the Axis and uncheck the Show Header option as shown below.

Showing the Header

To make our report more colorful, We added the Color dimension to the Tableau Lollipop Chart Color field in Marks Shelf.

Tableau Lollipop Chart Color

The above screenshot shows that we successfully created the lollipop chart.

Format Tableau Lollipop Chart

To change the Lollipop chart circle of it, we have to change the Mark type from Automatic to Shape, as shown below.

Tableau Lollipop Chart Shapes

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

Edit or Change the Shape from Circle

Once you click on the More Shapes option, an Edit Shape window will open. Here we are selecting the Ratings palette.

Select the Shape palette

Next, we selected the below-shown shape for this example.

Change Shape

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.