How to Create a Lollipop Chart in Excel (using functions)

Welcome back to Plot Twist, the series where we transform ordinary data into eye-catching visualizations! In this episode, we’ll dive into creating a Lollipop Chart in Excel. A Lollipop Chart is similar to a bar chart, but instead uses function to create lollipop bars to visualize the data! That’s right – this chart is actually made from Excel functions, unlike traditional charts.

We’ll walk through every step:
• Setting up the chart
• Using the REPT function to create the Lollipop bars
• Adding data labels to the chart
• Formatting the chart
• Adding conditional formatting to highlight the smallest bar in red and the largest in green

And here’s the twist: this isn’t just visually unique—it’s completely dynamic! Update your data, and the labels, bar lengths, and colors adjust automatically. You won’t believe this isn’t a standard Excel chart.
Ready to give your data a sweet new look?!

📖RESOURCES

🤓SHOP EXCEL DICTIONARY

📩NEWSLETTER

📺SUBSCRIBE

🕰️TIMESTAMPS
‘0:00 Intro
‘0:31 Lollipop Chart overview
‘0:56 Set up the Lollipop Chart
‘1:09 Create Lollipop bars using the REPT function
‘2:22 Add data labels to the Lollipop Chart
‘2:59 Format the Lollipop Chart
‘3:51 Add conditional formatting to the Lollipop Chart
‘6:12 Benefits of the Lollipop Chart
‘6:30 Wrap up

#excel #exceltips #tutorial #chart #lollipop #functions #DataVisualization #PLOTTWIST #ExcelTutorials #CreativeCharts

[auliarbn]

Thanks for making ma sheet more exciting❤. Love from 🇮🇩

[jonr]

Thinking outside the (chart) box! Useful trick, thanks.