Tranform your bar chart into a lollipop chart like this! 🔥 Insert error bars, format error bars – select minus, no cap, and set percentage to 100%. Format the color of your error bars and set the end type to circle. Then set the large data bars to No Fill to make them disappear. Now you have a beautiful lollipop chart in Excel!

STAY CONNECTED
🔔 Subscribe to my YouTube Channel. I’ll be forever grateful! https://www.youtube.com/channel/UCSuQd43nLcgH18R4d7DwTZQ?sub_confirmation=1

📬 Sign up for my email list. I’ll post tips and tricks when inspiration strikes
https://spotlightimpact.com/souvenirs-%F0%9F%8E%81

🖐 Follow me on social
Twitter: https://twitter.com/spotlightimpact
Instagram: https://www.instagram.com/nickvsppt/
LinkedIn: https://www.linkedin.com/company/spotlight-impact-data-design/

GRAB SWAG!
👕 Buy Spotlight Impact Swag!
https://spotlightimpact.creator-spring.com

BUY MY TEMPLATES AND DESIGN SERVICES
💲 Download templates from my souvenir shop on Gumroad
https://spotlightimpact.gumroad.com/

💲 *HOT SELLER* Zip Code Lookup Template in Excel https://spotlightimpact.gumroad.com/l/XPDdv

👨‍💻 Check out our design services and portfolio.
https://www.spotlightimpact.com

GET DESIGN TRAINING FROM OUR FRIENDS AT DEPICT DATA STUDIO
📊 Mini and full online courses in data viz, data analysis, presentation design, and more! https://tinyurl.com/dataviztrainingonline*

GET EXCEL TRAINING FROM OUR FRIENDS AT EXCEL UNIVERSITY
📈 Online Excel how-to and productivity training*. Get Excel certified here! https://affiliate.excel-university.com/idevaffiliate/idevaffiliate.php?id=234_0_3_3

💻 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.

*Affiliate Links
#excel #exceltips #excelcharts