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

⚡JOIN for members-only content and early access to weekly tutorials    / @spotlightimpact  

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. 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/e...
Peltier Tech https://peltiertech.com/dot-plots-mic...

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

🙏 SUPPORT MY CHANNEL
Subscribe to this channel for more tips, tricks, and tutorials!    / @spotlightimpact  
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-sprin...

🎒 COURSES & TRAINING AFFILIATES
Depict Data Studio Courses https://depictdatastudio.teachable.co...
Excel University https://affiliate.excel-university.co...
Miss Excel (Opens monthly) https://links.miss-excel.com/exclusiv...

🙋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