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

[@mb-br7jw]

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.

[@SpotlightImpact]

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. kzbin.info/www/bejne/p5SvZGaGlL5kf9Esi=HJ02dLCx3mfi6GMt

[@SpotlightImpact]

also check out peltier tech blog - this one's option 2 might help you out here peltiertech.com/multiple-width-overlapping-column-chart/

[@mb-br7jw]

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.

[@miless2111sutube]

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?

[@SpotlightImpact]

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!

[@SpotlightImpact]

Here's a quick tutorial on editing that data in a ppt chart - to open the source data pop up window kzbin.info/www/bejne/el7ReIBobM-nbpIsi=U5BsEWoS5dVkgm6F