How to Make a Lollipop Chart in Tableau

Tired of the same old bar charts? A lollipop chart is a visually appealing and effective alternative that can make your data dashboards stand out. This guide will walk you through exactly how to build, customize, and effectively use lollipop charts in Tableau to better tell your data story.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Lollipop Chart and Why Should You Use One?

A lollipop chart is a variation of a bar chart. Instead of a full bar, it uses a line (the "stick") with a circle at the end (the "candy") to represent the data value. This design offers a few key advantages:

• Reduced Visual Clutter: By replacing thick bars with thin lines, lollipop charts minimize the amount of ink on the page. This makes them look cleaner, especially when you have many categories to display.
• Clear Focus on the Value: The dot at the end of the line draws the viewer's eye directly to the endpoint, emphasizing the magnitude or value of that specific category without the distraction of a long, heavy bar.
• Great for Ranking: Just like bar charts, lollipops excel at showing ranked data. When sorted, they make it incredibly easy to see which categories are performing best or worst.

While they are stylish and effective, they work best when comparing values that all start from a common baseline (usually zero), similar to a standard bar chart. They share the same core DNA as a bar chart, just with a more modern and minimalist aesthetic.

Preparing Your Data

The good news is that if your data is ready for a bar chart, it's ready for a lollipop chart. You don't need to do any special formatting. Typically, you'll need at least:

• One Dimension: This is your categorical data. Think of things like Product Category, Country, Campaign Name, or Sales Rep.
• One Measure: This is your quantitative data. It's the numerical value you want to measure, like Sales, Profit, Website Visits, or Conversion Rate.

For this tutorial, we will be using the Sample - Superstore dataset that comes with Tableau, looking at Sales (our measure) by Sub-Category (our dimension).

Step-by-Step: How to Build a Lollipop Chart in Tableau

Creating a lollipop chart in Tableau involves a clever use of a dual-axis chart. Don't worry, it sounds more complicated than it is! Just follow these steps carefully.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Create a Basic Bar Chart

First, we need to create a simple horizontal bar chart, which will form the foundation (the "sticks") of our lollipops.

1. Drag your dimension (e.g., Sub-Category) to the Rows shelf.
2. Drag your measure (e.g., Sales) to the Columns shelf. Tableau will likely aggregate this as SUM(Sales), which is what we want.
3. Sort the chart descending to make it easier to read. You can do this by clicking the sort icon on the axis or in the toolbar.

You should now have a standard horizontal bar chart. This is our starting point.

Step 2: Create the Dual Axis

This is the most important part of the process. We need to duplicate our measure on the Columns shelf to create a second, identical chart next to the first one. We will then combine them.

1. Drag your measure (Sales) from the data pane again and drop it on the Columns shelf, right next to the first SUM(Sales) pill.

You will now see two identical bar charts in your worksheet, one next to the other, sharing the same Sub-Category labels.

Step 3: Combine into a Dual-Axis Chart

Now we merge these two charts into a single visualization with a shared axis.

1. Right-click on the second SUM(Sales) pill on the Columns shelf.
2. Select Dual Axis from the menu.

You'll see your visualization change significantly. The two charts are now layered on top of each other. Tableau has likely changed the mark type to circles by default. Now it's time to create the lollipop effect.

Step 4: Adjust the Mark Types

In the Marks card area, you will now see three tabs: All, SUM(Sales), and SUM(Sales) (2). These control the formatting for the entire chart, the first chart, and the second chart, respectively.

1. Click on the SUM(Sales) marks card (the first one).
2. Change the mark type from Automatic to Bar.
3. Next, click on the SUM(Sales) (2) marks card (the second one).
4. Ensure its mark type is set to Circle.

You're getting close! You should now see thin bars with circles at the end, but they probably don't line up perfectly.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 5: Synchronize the Axes

For the circles to sit perfectly at the end of the bars, both axes must use the exact same scale. This is a critical step that is easy to forget.

1. Right-click on the top axis (or either axis).
2. Select Synchronize Axis.

Voila! The circles should now be perfectly aligned with the ends of the bars, creating the lollipop look.

Step 6: Adjust Sizing

The final step in the basic build is to adjust the sizes to create the classic lollipop appearance: a thin "stick" and a proportionate "candy."

1. Go to the SUM(Sales) (Bar) marks card.
2. Click the Size button.
3. Move the slider to the left to make the bars thin and stick-like.
4. Now, go to the SUM(Sales) (2) (Circle) marks card.
5. Click the Size button.
6. Move the slider to the right to make the circles slightly larger than the sticks for a more pronounced effect.

Step 7: Clean Up The View

To finalize the chart, we can hide the redundant second axis header.

1. Right-click the top axis.
2. Uncheck Show Header.
3. Feel free to edit the bottom axis title or any other formatting to suit your needs.

Congratulations! You have successfully created a functional and stylish lollipop chart.

Customizing Your Lollipop Chart for Better Insights

Now that you have the basic structure, you can add more layers of information to make your chart more insightful.

Adding Labels for Clarity

Displaying the exact value can be very helpful. It's best to label the circle, not the bar.

1. Navigate to the SUM(Sales) (2) (Circle) marks card.
2. Drag your measure (Sales) onto the Label button.
3. You can now click on the Label button to format the font, alignment, and number display (e.g., currency, percentage).

Using Color Effectively

Color can add another dimension to your analysis. You can color your lollipops based on the dimension or the measure.

• To color by category: Drag your dimension (Sub-Category) to the Color button on the SUM(Sales) (2) marks card. This will assign a different color to each dot, which is great for differentiation.
• To color by value: Drag your measure (Sales) to the Color button on the SUM(Sales) (2) marks card. This will create a color gradient, making it even easier to spot high and low performers at a glance.

Pro Tip: Remember to apply the color changes to the Circle marks card, not the Bar marks card, for the most visually appealing result.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Customizing Tooltips

Tooltips are the pop-up boxes that appear when you hover over a data point. Polishing them can make your dashboard much more user-friendly. Go to the All marks card and click on Tooltip. You can customize the text to be more descriptive, adding fields and formatting it to read like a sentence, for example: "The <Sub-Category>, sub-category generated <SUM(Sales)>, in total sales."

Final Thoughts

Mastering the lollipop chart in Tableau is a fantastic way to elevate your dashboards, moving beyond basic bar charts to something more refined and visually engaging. By combining two charts on a dual axis, customizing mark types, and synchronizing the axes, you can quickly build an impressive and insightful visualization for ranking data.

While mastering specific charts in tools like Tableau is a valuable skill, it often requires navigating a complex interface with dozens of menus and settings. At Graphed, we connect directly to all your data sources so you can get the charts and dashboards you need just by asking. Instead of following multi-step tutorials, you simply say, "Show me last quarter's sales by sub-category as a lollipop chart," and get a live, interactive dashboard in seconds. This turns hours of manual report-building into a quick conversation, giving you the insights you need without the steep learning curve.