How to Create a Lollipop Chart?

a team smiling while working

A lollipop chart is a type of visualization that shows the values of a variable using circles or squares attached to horizontal or vertical lines. A lollipop chart can also show the comparison or difference between two variables by using different colors or shapes for the circles or squares.

Keep on Reading: Tableau Data Analyst Certification Questions »

Create a Lollipop Chart in Tableau
Create a Lollipop Chart in Tableau

Desktop Specialist

Learn more about Desktop Specialist Certification.

Data Analyst

Learn more about the Data Analyst Certification.

Server Certified

Learn more about the Tableau Server Certification.

🎁 Did you know you can get $30 for sharing your work and certification experiences? Write and get paid for every article. Learn more »

To create a lollipop chart in Tableau, follow these steps:

  1. Connect to your data source and drag the variable you want to use as the lines to the Columns or Rows shelf. For example, if you want to create a lollipop chart of sales by product category, drag Product Category to Rows.
  2. Drag another variable you want to use as the circles or squares to the Size mark. For example, drag Sales to Size.
  3. Change the mark type from Automatic to Circle or Square, depending on your preference. This will create a lollipop chart with different sizes based on the values of the second variable.
  4. To show the comparison or difference between two variables, drag another variable you want to use as the color or shape dimension to the Color or Shape mark. For example, drag Profit Ratio to Color.
  5. Optionally, you can add labels, tooltips, filters, legends, titles, and other formatting options to enhance your visualization.

You have now created a lollipop chart in Tableau!

Keep reading: Tableau Desktop Specialist Certification Questions »

Loading RSS Feed

A lollipop chart can be useful for businesses in many ways. Here are some examples of how businesses can benefit from using this type of visualization:

  • A lollipop chart can help show the values of a variable across categories or groups using visual cues such as size and position. For example, a business can use a lollipop chart to show sales by product category and see how they vary across different products.
  • A lollipop chart can help show the comparison or difference between two variables across categories or groups using visual cues such as color or shape. For example, a business can use a lollipop chart to show sales by product category and profit ratio and see which products are more profitable than others.
  • A lollipop chart can help emphasize essential categories or groups based on two variables using visual cues such as color or shape. For example, a business can use a lollipop chart to highlight products with high sales and high-profit ratios compared to others.

A lollipop chart is one of the most creative types of visualization that businesses can use to display and compare their data visually.

Here are some interview questions on this topic:

  • What is a lollipop chart and when would you use it?
  • How do you create a lollipop chart in Tableau?
  • What are some advantages and disadvantages of using a lollipop chart?
  • How do you interpret and analyze a lollipop chart?
  • How do you customize and format a lollipop chart in Tableau?

Here are some data analyst technical round questions on this topic:

  • How do you calculate the average value of a variable across categories or groups using Tableau calculated fields?
  • How do you align the circles or squares with the lines using Tableau dual axis option?
  • How do you add reference lines or bands to show benchmarks or targets for values of two variables using Tableau analytics pane?
  • How do you filter out outliers or extreme values from your data set using Tableau filters shelf?
  • How do you test for statistical significance or correlation between two variables using Tableau trend lines option?

Learning how to create a lollipop chart in Tableau can help in your career in many ways. Here are some reasons why learning this skill can be beneficial:

  • Learning how to create a lollipop chart in Tableau can help you showcase your creativity and innovation in data visualization. A lollipop chart is not one of the standard charts available in Tableau but rather one that requires some tricks and techniques to create it from scratch.
  • Learning how to create a lollipop chart in Tableau can help you improve your analytical and problem-solving skills. A lollipop chart involves manipulating data, calculating metrics, applying logic, testing hypotheses, and finding insights from complex data sets.
  • Learning how to create a lollipop chart in Tableau can help you communicate your findings and recommendations effectively and persuasively. A lollipop chart is an eye-catching and engaging way of presenting data that can capture attention and convey messages clearly and concisely.

Get our Most Popular Downloads

Download the most popular scenario-based Tableau Workbooks in .twbx format. Used by thousands of Tableau developers and job aspirants every day to improve and fine-tune their CV and Tableau Public profile. Join the largest Tableau Experts Social Group.

Tableau Banking and Financial Dataset Analysis Download
Banking & Financial Dataset Analysis

Financial Domain Tableau Dataset and Analysis. The most important domain in today’s industry. Analyze Key Performance Indicators. Discover Risky and Fraudulent Outliers. Download the Tableau Packaged (.twbx) Workbook. Includes a complete Financial dataset analysis. Enhance your Data Analytics experience with our skilled analysis.

Tableau Healthcare and Hospital Dataset Analysis Download
Healthcare & Hospital Dataset Analysis

Hospital and Healthcare Domain Tableau Dataset and Analysis. A key field of study with millions of lives at stake. The most sensitive industry today. Download the Tableau Packaged (.twbx) Workbook. Understand how healthcare datasets work. Includes a complete Healthcare dataset with analytical charts. Explore Tableau interactive features with this download.

Tableau Insurance Dataset Analysis Download
Insurance Dataset Analysis

Insurance Domain Tableau Dataset and Analysis. Important domain specific metrics and data. Learn how to visualize important metrics. Show outliers and insightful data points. Download the Tableau Packaged (.twbx) Workbook. Includes comprehensive analysis of Insurance data of a large sample population. Uses industry standard analytical practices.

Tableau Practice Test

The best Tableau practice exams built. Period. Explore definitive practical problems created by brilliant Tableau experts.

Get in Touch

Contact Us
Write for Us

Published by Rahul Bhattacharya

Rahul is a journalist with expertise in researching a variety of topics and writing engaging contents. He is also a data analyst and an expert in visualizing business scenarios using data science. Rahul is skilled in a number of programming languages and data analysis tools. When he is not busy writing, Rahul can be found somewhere in the Appalachian trails or in an ethnic restaurant in Chicago.

Leave a Reply