How to Create a Horizontal Lollipop Chart in PowerPoint

If you’ve already learned how to make a vertical lollipop chart, you might think, “Cool. I’ll just rotate it 90 degrees.”

Nope. You can’t rotate charts in PowerPoint. (I know, it’s incredibly silly.) So we build the horizontal version differently. This one uses a bar chart + formatted error bars.

Let’s build it.

Step 1: Start with a Bar Chart

1. Insert your data.
2. Choose a Bar Chart (not column this time).

We’ll transform it into a lollipop.

Step 2: Add Error Bars

1. Select the chart.
2. Click the green + (Chart Elements) icon or go to the Chart Design tab in the ribbon and choose “Add Chart Element”.
3. Choose Error Bars.
4. Choose Percentage Error Bars.

They’ll look tiny at first. We’re about to fix that.

Step 3: Format the Error Bars (The “Stick”)

1. Right-click an error bar → Format Error Bars.
2. Change:
   • Direction: Minus
   • End Style: No Cap
   • Percentage: 100%

Now the error bars extend all the way to the axis. These are your lollipop sticks.

Step 4: Remove the Bar Fill

1. Click the bars.
2. Open Format Data Series.
3. Choose No Fill.

Now you’re left with just the sticks.

Step 5: Turn the Error Bars into Lollipops

1. Select the error bars.
2. Go to Fill & Line → Line.
3. Choose Solid Line.
4. Pick your color.
5. Adjust width (around 1.5–2 pt works well).

Now for the circle:

1. In the same Format pane,
2. Under Begin Arrow Type, choose the circle.
3. Increase Begin Arrow Size to the largest option.

You now have horizontal lollipops.

Step 6: Highlight One Data Point (Optional)

If you want to emphasize the largest value:

1. Click a bar.
2. Click again to select just one data point.
3. Choose Solid Fill for that bar.
4. Adjust Gap Width (Format Data Series → Gap Width) to control thickness.

Check your slideshow preview to make sure the circle and stick widths look balanced.

In edit mode, proportions can look slightly off.

Recap

To make a horizontal lollipop chart:

1. Start with a bar chart.
2. Add percentage error bars.
3. Set error bars to:
4. Remove bar fill.
5. Format error bars with:
   • Solid line
   • Circle begin arrow
6. Adjust gap width and line thickness.

It’s not a native chart type. It’s a cleverly formatted bar chart.