Thank you Jeff Lenning at Excel University for this cool trick! Sometimes you need individual line markers on your bar charts to show an individual average or other unique value like a goal. Here's one cool way to do it. Add drop shadow effect to a secondary series of bars, overlap the two series and adjust the shadow to create your bar marker. A cool trick that has a lot a lot of use cases for other types of charts I think. Thanks Jeff for sharing, and thank you for your permission to share how I used your steps in my own bar chart. I hope you'll follow Jeff and Excel University at the links below!

Check out Excel University and their suite of Excel certification courses here* https://affiliate.exceluniversity.co...

SHOUTOUTS & REFERENCES
Jeff's post here https://www.exceluniversity.com/bar...
Subscribe to Excel University on YouTube    / exceluniversityinc  

LET'S CONNECT
Official site: www.spotlightimpact.com
Souvenir blog: https://spotlightimpact.com/souvenirs...
LinkedIn:   / spotlightimpactdatadesign  
Instagram:   / nickvsppt  
Twitter:   / nickvsppt  

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...
Custom PostIt Note Graphics [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...
Resume or CV Template [Word] https://spotlightimpact.gumroad.com/l...
Data Placemat or Dashboard Template [PowerPoint] https://spotlightimpact.gumroad.com/l...

SUPPORT THIS 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 sourvenirs from my Pahip shop https://payhip.com/spotlightimpact
Buy Spotlight Impact SWAG on Spring https://spotlightimpact.creatorsprin...

COURSES & TRAINING AFFILIATES
Depict Data Studio has Mini and full online courses in data viz, data analysis, presentation design https://spotlightimpact.com/souvenirs...
FREE COURSE! Soar Beyond the Dusty Shelf Report https://depictdatastudio.teachable.co...
Excel University has online Excel howto and productivity trainings to boost your skill and get you that promotion! Get Excel certified here! https://affiliate.exceluniversity.co...

FYI
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/enus
Buying courses or products through affiliate links costs no extra for you and gives my channel a small percentage of the proceeds.

#powerpoint #powerpointtipsandtricks #powerpointtutorial