How to Make a Lollipop Chart in Excel! [CHART TIPS🍭]

In this step by step tutorial you'll learn how to make a horizontal lollipop chart built from an XY scatter chart with unique category labels (above the lollipop stems instead of off to the side). There are so many cool ways you can "hack" Excel to make unique chart types like this horizontal lollipop with cool label positioning. This time I used a lollipop technique I love from Dr. Stephanie Evergreen at Evergreen Data, check out the blog post here: http://stephanieevergreen.com/lollipop/

Insert a blank scatter plot to start, set up your source data like I do in the video and follow along!

📣 SHOUTOUTS
Evergreen Data Blog http://stephanieevergreen.com/lollipop/
My Online Training Hub https://www.myonlinetraininghub.com/excel-dot-plot-charts
Peltier Tech https://peltiertech.com/dot-plots-microsoft-excel/

💻 DOWNLOADS FOR PURCHASE
Zip Code Lookup Template [Excel] https://spotlightimpact.gumroad.com/l/XPDdv
Square Carousel Template [PowerPoint] https://spotlightimpact.gumroad.com/l/jsnyf
10 Minute Timer Slide Template [PowerPoint] https://spotlightimpact.gumroad.com/l/hwodqy
Net Promoter Slider Chart Template [PowerPoint] https://spotlightimpact.gumroad.com/l/NPSgaugechart
Waffle Chart Template [Excel] https://spotlightimpact.gumroad.com/l/bgpvN
Data Placemat or Dashboard Template [PowerPoint] https://spotlightimpact.gumroad.com/l/fNVsO

🙏 SUPPORT MY CHANNEL
Subscribe to this channel for more tips, tricks, and tutorials! https://www.youtube.com/channel/UCSuQd43nLcgH18R4d7DwTZQ?sub_confirmation=1
Hit the THANKS button in any video!
Grab data design souvenirs from my shop on Gumroad https://spotlightimpact.gumroad.com/
Grab data design souvenirs from my Payhip shop https://payhip.com/spotlightimpact
Buy Spotlight Impact SWAG on Spring https://spotlightimpact.creator-spring.com/

🎒 COURSES & TRAINING AFFILIATES
Depict Data Studio Courses https://depictdatastudio.teachable.com/?affcode=202644_jnppg_eo
Excel University https://affiliate.excel-university.com/234.html
Miss Excel (Opens monthly) https://links.miss-excel.com/exclusive?ref=nick91

🙋FAQs
I’m using Microsoft 365 in my videos: PowerPoint, Excel, Word. If you don't have a feature you see here, check the Microsoft support pages for a version feature list
https://support.microsoft.com/en-us
Buying courses through affiliate links above costs no extra, but gives a small percentage of the proceeds to my channel.

#powerpoint #powerointtips #powerpointtutorial

Видео How to Make a Lollipop Chart in Excel! [CHART TIPS🍭] канала Spotlight Impact Data Design