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

  Рет қаралды 4,353

Spotlight Impact Data Design

Spotlight Impact Data Design

Күн бұрын

Пікірлер: 7
@mb-br7jw
@mb-br7jw 7 ай бұрын
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
@SpotlightImpact 7 ай бұрын
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
@SpotlightImpact 7 ай бұрын
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
@mb-br7jw 7 ай бұрын
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
@miless2111sutube 8 ай бұрын
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
@SpotlightImpact 8 ай бұрын
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
@SpotlightImpact 8 ай бұрын
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
How to Keep CHART LEGEND active in Excel and PowerPoint!🧑‍💻 [DATA VIZ TRICKS 📊]
7:38
How to Make a Horizontal Bullet Graph in Excel 🔥 [CHART TIPS! 📊]
8:38
Spotlight Impact Data Design
Рет қаралды 2,9 М.
Colorful Pasta Painting for Fun Times! 🍝 🎨
00:29
La La Learn
Рет қаралды 308 МЛН
Try Not To Laugh 😅 the Best of BoxtoxTv 👌
00:18
boxtoxtv
Рет қаралды 7 МЛН
СОБАКА И  ТРИ ТАБАЛАПКИ Ч.2 #shorts
00:33
INNA SERG
Рет қаралды 1,8 МЛН
Sigma baby, you've conquered soap! 😲😮‍💨 LeoNata family #shorts
00:37
Bar Chart Target Markers
8:11
Excel University
Рет қаралды 8 М.
Excel Charts & Graphs: Learn the Basics for a Quick Start
14:10
Leila Gharani
Рет қаралды 1 МЛН
How to Make a Diverging Stacked Bar Chart in PowerPoint 🔥 [PPT CHARTS!]
11:51
Spotlight Impact Data Design
Рет қаралды 6 М.
How to Create Gantt Chart with Progress Monitoring Bar for Multiple Tasks in Excel
10:16
Innovative Learner (innovative_learning)
Рет қаралды 50 М.
Bar chart with differences in Excel
13:49
RBX Excel videos
Рет қаралды 159 М.
Excel Solver & Goal Seek Tutorial
23:34
Kevin Stratvert
Рет қаралды 174 М.
Colorful Pasta Painting for Fun Times! 🍝 🎨
00:29
La La Learn
Рет қаралды 308 МЛН