How To Make a Bar Chart with Target Markers Using Drop Shadow in Excel! 🔥[CHART TRICKS!]h

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! 👇

SHOUTOUTS & REFERENCES

🖐 LET'S CONNECT

🗃️ DOWNLOADS FOR PURCHASE

🙏 SUPPORT THIS CHANNEL
- Hit the THANKS button in any video!

🎒 COURSES & TRAINING AFFILIATES

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

[mb-brjw]

Very nice. However I seem to not be able to change the gap size separately. All bars will change, also of the other data sets. I am trying to use this trick with 4 bars on tops of each other. And then the order of the bars is also of influence. I have tries to make things work with transparent color of the bars, but not (yet) ideal.

[milesssutube]

great video. One oddity I noticed is that if you switch the order of the y axis categories whilst the main data bars reverse order as expected the shadow series doesn't seem to so you have the wrong data in each one. This is very odd and I wonder if it is something to do this this approach of using a secondary X axis? Any ideas?