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