How To Make a Bar Chart with Target Markers Using Drop Shadow in Excel! 🔥[CHART TRICKS!]h
HTML-код
- Опубликовано: 21 авг 2024
- 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* affiliate.exce...
SHOUTOUTS & REFERENCES
👉 Jeff's post here www.excel-univ...
👉 Subscribe to Excel University on RUclips / exceluniversityinc
🖐 LET'S CONNECT
- Official site: www.spotlightimpact.com
- Souvenir blog: spotlightimpac...
- LinkedIn: / spotlight-impact-data-...
- Instagram: / nickvsppt
- Twitter: / nickvsppt
🗃️ DOWNLOADS FOR PURCHASE
- Zip Code Lookup Template [Excel] spotlightimpac...
- Square Carousel Template [PowerPoint] spotlightimpac...
- 10 Minute Timer Slide Template [PowerPoint] spotlightimpac...
- Custom Post-It Note Graphics [PowerPoint] spotlightimpac...
- Net Promoter Slider Chart Template [PowerPoint] spotlightimpac...
- Waffle Chart Template [Excel] spotlightimpac...
- Resume or CV Template [Word] spotlightimpac...
- Data Placemat or Dashboard Template [PowerPoint] spotlightimpac...
🙏 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 spotlightimpac...
- Grab data design sourvenirs from my Pahip shop payhip.com/spo...
- Buy Spotlight Impact SWAG on Spring spotlightimpac...
🎒 COURSES & TRAINING AFFILIATES
- Depict Data Studio has Mini and full online courses in data viz, data analysis, presentation design spotlightimpac...
- FREE COURSE! Soar Beyond the Dusty Shelf Report depictdatastud...
- Excel University has online Excel how-to and productivity trainings to boost your skill and get you that promotion! Get Excel certified here! affiliate.exce...
💻 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 support.micros...
- 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
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.
Yeah this doesn’t work that great when you have more than one set of bars you want to overlap. To do that you light want to work with error bars on extra series. You can see this trick in my bullet chart tutorial. ruclips.net/video/qcL33P_Y1Io/видео.htmlsi=HJ02dLCx3mfi6GMt
also check out peltier tech blog - this one's option 2 might help you out here peltiertech.com/multiple-width-overlapping-column-chart/
Hi, Thanks for your very fast reply 🙂. Your suggestion has actually been the first way I tried, using a stacked chart. I will try again if that will look ok on the combines bar chart. I thought I might have found a sub-optimal way of doing this by using gradual fill and making the first slider transparent, but becasue it uses a % for the width some of my indicators are wider than others. It does however solve the problem of not being on top of all the other bars. So no longer required to make all the bars transparent. I will give the error bars another go. Thanks again.
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?
Yep, exactly! If you check the box that says "categories in reverse order" to swap the y axis that will only switch the values on the primary axis - the secondary axis values (the target lines) will stay the same. So, the fix here is not to use the "categories in reverse order" check box but instead sort the data source. right-click the chart > edit in excel so the source data window pops up then reverse the order of the data through sorting your data in the table. As long as your labels, the data column, and the target column are sorted together that should update everything in the chart. I'll make a viewer question tutorial about this soon, thanks for the question!
Here's a quick tutorial on editing that data in a ppt chart - to open the source data pop up window ruclips.net/video/D-nGM27jt80/видео.htmlsi=U5BsEWoS5dVkgm6F