How to Create a Lollipop Chart in Google Slides (A Modern Alternative to Bar Charts)

Let’s be honest: standard bar charts are the vanilla ice cream of the presentation world. They’re safe, everyone recognizes them, but they can feel a bit… heavy. When you have a slide packed with data, thick bars dominate the screen, often distracting from the actual numbers you're trying to highlight.

Enter the Lollipop Chart.

It’s cleaner, sharper, and arguably more elegant. By reducing the heavy bar to a thin line and capping it with a dot (the "candy"), you draw the audience’s eye directly to the data point (the value) rather than the container. It improves what data visualization expert Edward Tufte calls the "data-ink ratio"—more information, less decorative clutter.

The problem? Google Slides doesn't have a native "Lollipop Chart" button. Usually, you have to hack one together by drawing lines and circles manually, which is a nightmare to update when your numbers change.

Here is how you can build professional, data-driven Lollipop-style charts right inside Google Slides using ExtraChart, without drawing a single shape manually.

Why Choose a Lollipop Chart?

Before we build it, let's look at why you’d swap your trusty bar chart for this modern cousin:

1. Less Clutter: Great for ranking long lists of items (like sales by region or survey scores).
2. Focus on Value: The dot at the end emphasizes the exact position/value, whereas a bar emphasizes the length.
3. Modern Aesthetic: It just looks more premium.

The Challenge with Native Google Slides

If you try to do this natively, you are stuck. You might use a Scatter Plot, but you can't easily connect the dots to the axis. Or you use a Bar Chart, but you can't make the bars ultra-thin with a distinct circular cap. Most people end up overlaying circles on top of bars—a recipe for disaster when you need to update next month's Q1 report.

The ExtraChart Solution

ExtraChart runs as a sidebar add-on, giving you granular control over chart rendering that Google’s native tool misses. We can use the Horizontal Bar Chart engine and customize the styling to achieve that sleek, separated look.

Step 1: Launch ExtraChart

First, get ExtraChart running in your slide deck. Go to Extensions -> ExtraChart -> Create & Edit Charts.

Step 2: Select the Horizontal Bar Chart

Since a Lollipop chart is essentially a modified bar chart, we start with the Horizontal Bar base. This gives us the X and Y axis structure we need.

In the sidebar menu, scroll down to the Bar & Column Charts section and select the Horizontal Bar Chart.

Step 3: Input Your Data

The editor popup will appear. On the Data tab, you can paste your data directly from Excel or Google Sheets.

• Column A (Labels): Categories (e.g., "North," "South," "East," "West").
• Column B (Values): Your metric (e.g., Revenue, Satisfaction Score).

As soon as you paste the data, the preview on the left updates instantly. No more "Apply" buttons—you see what you get immediately.

Step 4: Styling for the "Lollipop" Look

This is where the magic happens. Switch to the Settings tab. To get that Lollipop aesthetic (or as close as possible with a bar engine), we need to manipulate the layout parameters:

1. Reduce Bar Width/Spacing: In the layout settings, look for spacing or bar width controls. By increasing the spacing between categories, the bars themselves become thinner. A thinner bar looks more like the "stick" of a lollipop.
2. Color Palette: Use the Color Palette Manager. Make your bars a solid, high-contrast color.
3. Labels: Ensure your data labels are positioned clearly at the end of the bars.

Note: While a classic lollipop has a distinct circle at the end, a very thin horizontal bar with a bold data label at the tip achieves 90% of the same visual effect—clean separation of data points without the visual weight of a blocky bar.

Step 5: Insert and Resize

Once you are happy with the preview:

1. Click Create.
2. The chart inserts as a high-resolution image on your slide.

The best part? It’s not a static screenshot. If your boss asks you to update the Q3 numbers next week, you don't need to rebuild it. Just select the chart image, open ExtraChart, and your data is there, ready to be tweaked.

When to Use It (And When Not To)

• USE IT WHEN: You have categorical data (text labels) and you want to compare values. It’s fantastic for Top 10 lists.
• AVOID IT WHEN: You have stacked data segments (use a Stacked Bar Chart for that) or if exact comparison of lengths is critical for your audience, as standard bars are slightly easier for the eye to measure strictly by length.

Summary

You don't need to settle for the default charts that Google Slides gives you. With ExtraChart, you can create visualizations that look like they were designed in Illustrator, but keep the flexibility of a spreadsheet.

Ready to clean up your slides?

Head to the Google Workspace Marketplace and search for ExtraChart to get started today.