How To Add Error Bars In Excel (Custom Error Bars)

In this video tutorial I am going to show you how to add error bars in Excel. Specifically, I will show you how to add standard deviation error bars to a bar graph.
There are many types of error bars you can add to graphs in Excel. In this example, I will use the standard devation, however, you can also use the standard error or confidence intervals. I have included links below on how to calculate these in Excel.
HOW TO CALCULATE CONFIDENCE INTERVALS IN EXCEL
• How To Calculate Confi...
HOW TO CALCULATE STANDARD ERROR IN EXCEL
• Calculating Mean, Stan...
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor techsmith.z6rjha.net/c/198849...
KZbin SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

[@mackthemark9105]

Mr. Bradburn, may the rains fall soft upon your fields. May you bask in the sun and never get a burn; may your parents be liberal in their affection; may your children grow up to recognize the beautiful man that you are. Go forth this day with the knowledge that lives, or at the very least occasional Thursday evenings, are changed. God bless you. If you are not a religious man; you rock. You also rock if you're a religious man, to be clear. You get what I mean.

[@jayceel251]

Man you must've really needed those error bars

[@iglide]

@@jayceel251 he really did

[@MadieMeysenburg]

Thank you so much! This was by far the most simple tutorial I have seen regarding error bars, and it makes much more sense! I need these in my graph for my IB Biology Extended Essay, so this video saved my life!

[@StevenBradburn]

Thanks for the feedback

[@maximontes5590]

This video is just perfect. Had been struggling for days trying to set the right deviation values on my graph. You Mr. simply saved my a$$. Infinite thanks!

[@gregorymoilwa569]

You just gained a subscriber❤. Thank you for your service Sir.

[@edgypancreas1839]

Perfect Video, straight to the point and clear. Thank you, brother!

[@23rbarrett]

What a pleasure to encounter such a well organized and explained video! Followed your steps, et voila, the graph I need with error bars, thank you. In return, I offer this quote, from a distinguished colleague: "If I see a graph without error bars, I assume they are the width of the page." :)

[@StevenBradburn]

Many thanks for your kind feedback :)

[@jackwhitehead8177]

Dude, this is awesome. So straightforward. I'm a heavy procrastinator; you're here in my moment of panic and I could follow everything you said easily.

[@sowsan1034]

KINNGGGG THANK YOU!!!! I was so stuck on this

[@robbuckland5953]

Excellent, you included a step many have missed in copying and repeating the positive and negative error values into the custom option. Thanks for this.....

[@highwilllee2685]

Thanks for this tutorial. With my daughter we are looking a graph with error bars. Finally we find it in your helpful tutorial with "Custom" error bars.

[@konnerbaker3301]

You, sir, are a gentleman and a scholar. Full send on the Like.

[@linganileonjdube8160]

Thank you so much, you've just helped me with my last chapter of quantitative data for my MSc.

[@leahkimerer2446]

This is exactly what I needed! Thank you!

[@FlashDon]

I’ve been trying to do this for about a day.. this tutorial was worth it. Thank you sir!

[@StevenBradburn]

👍

[@skyzrpeterson517]

I’ve trying to do this for hours. You’re a savior

[@halofreak6166]

Awesome! thank you so much for saving so much time, very quick and concise!

[@ivystar6955]

You've just saved my life from the agony of endless research on how to custom error bars on Excel, I'll never be able to thank you enough ! Have a nice day (:

[@a.t.3192]

Oh god figuring this out was killing me in excel. Thanks so much for the excellent tutorial.

[@jacksonrottier]

Let’s gooo!!! Thank you so much for the help. Very clear and very helpful.

[@emilymccann1842]

This was so helpful. Couldn't have worked it out without this video!! Thank you :))

[@kymclennan7805]

Absolute legend. The website tutorials don't explain it as clear as you so thanks mate!!

[@StevenBradburn]

No problem 👍

[@cogwheelLearning]

Hey, really nice video! Your flow is excellent

[@breakingthefourthwall4945]

Thanks for the no bs vid man!

[@markmcfadden7428]

Your example was bang on, thanks

[@taylag1225]

Honestly couldn’t thank you enough for this!

[@StevenBradburn]

Very welcome

[@thediabetescoach9912]

Amazing thank you!!

[@shauryagoyal8770]

THIS IS AMAZING THANK YOU SO MUCH SAVED MY LIFE IN LESS THAN 4 MINUTES

[@user-bo6fu9mx5t]

thank you so much!! It is a great video. It helped a lot

[@needle_edible]

thank you so much!!! you saved my bachelor's thesis

[@user-bh3cc4kr1d]

Great. You made it so easy.

[@nasermohammadzadeh9848]

Thanks Steven. Very useful

[@dozytoast416]

This was helpful, thank you.

[@georgiaheaven5615]

Thank you for your help on this!

[@fragra7186]

thanks man you helped me a lot, much appreciated

[@tobyp2958]

This saved me from so much confusion thanks!

[@MmeOtaku]

Thank you so much !

[@michaelwang1730]

Thank you so much, it worked!

[@konstantinosdivanis4213]

thank you,excellent video

[@laurahorvath9258]

You saved my life!!!! thank you so much

[@TheVrashal]

This Tutorial was really helpful in creating cluster graph for my conference paper. Thank You from a Ph.D. Scholar.

[@scottdiver690]

Great vid thank you. A big help

[@Cullen592]

This video is so clutch!

[@VIShesh_Agrawal_happy]

Thanks sir for guiding us

[@diadahang7982]

For excel 2020, 1. Create a bar graph 2. Add Error Bars - Standard Deviation (don't look for more option, its not there) 3. Double click on the error bar - 'format error bars' will pop up from the right hand side 4. See the error amount, it will most likely be on standard deviation - change it custom 5. Click 'Specify Value' 6. Fill the value with your error bars - click OK AND YOU ARE GOOD TO GO :) GOODLUCK, TAKE DEEP BREATH AND CARE ON. REST IF YOU NEED TO!

[@StevenBradburn]

Thanks for the advice :)

[@thenewstyle8704]

Fucking life saver...

[@rhabdomere]

This saved my day! And I hate this stupid change from Microsoft: I don't understand why these f..king folks would keep changing it...It's meaningless and gives users a lot of trouble!

[@misssensei4040]

Thank you so much 🙏🏾

[@shunkaizhao3304]

God's work! Thank you!

[@karleffertz]

Thank you so much - that was very clear and concise.

[@StevenBradburn]

Thanks Karl

[@mastermind2971]

Thank you!

[@oussboudjelthia4869]

You made my life so much easier thank you sooooo much

[@StevenBradburn]

Very welcome

[@_patience1001]

Thank you very much, this is very helpful and interesting

[@quentinbld7705]

Best video ever ty

[@awppenheimer]

I keep coming back to this video every few months cos I keep forgetting how to do standard deviation lol. pretty helpful tho so thanks

[@lhhiep]

thank you for your useful video

[@sametnohutcu5556]

thank you so much.

[@hamidkiangaikani]

Awesome! Thanks man

[@chrisduarte7055]

Thanks!

[@neg_bm]

Thank you this was very helpful :)

[@Tiger-789]

Thanks a lot!

[@wakeg40]

dude thank you!

[@zainsaeed147]

I am advised to add error bars to my graph in research article. The video really helped me to make these using excel. May i know that once we add these bars to graph then do we need to make changes in the discussion part as well ?? Also do we need to mention that error bars are based on STDEV or STDEV. P or STDEV. S

[@vincyvarghese2426]

U made my day

[@elii1139]

Thanks a lot

[@laurensong8]

Thanks so much! :)

[@ikramulhaq7883]

thanks 👍

[@chantelleflynn9984]

Another full send on a like here, thank god you do these videos

[@StevenBradburn]

Thanks again!

[@parimojesh1051]

Very informative

[@Cobamernani456]

Thank you so much! Absolute life saver, quick and easy. Thanks for getting to the point so quickly!

[@StevenBradburn]

Very welcome!

[@liamdonnelly1816]

Thank you ^^

[@tunmisevictoria4464]

I love this

[@sylvangibbs3330]

finnally someone i can understand

[@matthewstilling4207]

This was a good video.

[@machonambahwe5081]

Thanks alot. It very helpful.

[@StevenBradburn]

Glad it was helpful!

[@michellelin1944]

Amazing this video was so useful! Thank you so much for the help :)

[@StevenBradburn]

Very welcome Michelle

[@banushasathi3526]

Thank you

[@connerwatson1902]

god bless you sir, I may now pass Bio 161

[@ruturajdeorukhkar8006]

Hi, thanks for the wonderful video ! I can’t find the error bar option when I press plus button. Any suggestions or remedies?

[@dew_77]

tysm

[@alicerosew]

Hi, do you have a video to show how to do this for 95% confidence intervals (i.e. upper and lower confidence intervals)?

[@charlottechambers3388]

love you king

[@mariamyassine8733]

I love you legend

[@willsteiner2529]

thanks

[@StevenBradburn]

No problem

[@carterweeg5851]

THANK YOU BABY

[@user-cx1jv2vp2t]

thank uuuu 💏

[@marlasinger8274]

god bless bro

[@kagamer21]

Hey Doc. B, what is the deal with line graphs in excel-- where when you try to add an error bar it makes a cross and not just a vertical line for the error bars?

[@dukedex5043]

Hi, if you have error numbers of data from a machine you used to analyse chemicals, can you use that error number in the excel error bar instead, or is the error bar only used for standard deviations that is calculated in excel? The machine I use calculated parts per million of a chemical, with an error number saying it could be this much more or less of parts per million. I hope that makes sense.

[@funmilayoafolabi5333]

I can't find the chart element option on my excel sheet.

[@KhaLed-pb4pu]

what about the box and whisker plot? error bars does not appear in the "add chart element".

[@MA-yt4xf]

Thanks for this!! I have a question - I created a bar graph representing the fold change of my gene of interest (treatment group fold change divided by control group fold change). I have 2 standard deviations - one for the treatment group and control group. Should I divide the treatment SD / control SD as well for my error bars? Or should I add the two SDs together? Data: Treatment fold change average = 5.9 SD of fold changes (3 samples) = 3.14 Control fold change average = 1.01 SD of fold changes (3 samples) = 0.23 Treated/control fold change = 5.83 Error bars = ??

[@saharkhalil5483]

Iam also looking for this from past 5 days 😢still got no answer

[@MA-yt4xf]

@@saharkhalil5483 i didnt her the answer either, so I ditched the error bars all together

[@saharkhalil5483]

@@MA-yt4xf iam really got sick due this stress 🥹🥲

[@khanofficial2249]

Nice to see your helpful videos, kindly make videos about Rstudio some diversity indices.

[@SaucyTuRkLeBiRd]

Ah my data isnt plotted in excel. What formula do I need to just enter the numerical values manually (at 3:20). Thanks!

[@willemdafoe5499]

Does this not double the standard deviation?

[@user-qe1uo8wh1i]

What if in each point i have more than one bar ?

[@blakepickering6914]

THANK THE LORD DR. BRADBURN

[@NikhilRatnaNeuro]

It helps to generate the bars but questions remain. why are same values entered in positive and negative error boxes? where is it accounting for the specificity of the data series of each bar? how can it be done without using custom option?

[@iskanderdoom6247]

Do u have an idea how format errorbar difference for X and Y lines in VBA? With chrt.SeriesCollection (numb_series) .ErrorBars .EndStyle xlNoCap .Format.Line.Visible msoTrue .Format.Line. Weight 15 .Format.Line. ForeColor.RGB RGB (255, 100, 0) .Format.Line. Transparency 0 End With I don't understand how made lines for X and Y different color, weight.

[@candythoms3995]

How can I add an error bar only on one bar?

[@yiagsit3770]

When i click on my plus icon near the graphic, there's no error bar option. Also i can't click on error bars on design bar. Someone help pleasee

[@SchoolBoyKosi]

My issue is that I don't have that plus sign at the top right corner of my graph so it doesnt allow me to customize my error bars. I calculated my standard error and everything but I cant implement the values into my graph.

[@SchoolBoyKosi]

nevermind i just had to download the excel app! You can't do what I was trying to do on chrome for Macbooks apparently.

[@ivy3723]

How do you change the 1 and 2? I need to add the variable name but i can’t find how

[@StevenBradburn]

Hi Ida, 1. Right-click on the graph and go to Select Data 2. Then click on Edit on the right side (Axis Labels) 3. Add in the labels; separate each entry with a comma

[@Cherry-ki3ln]

I wish that worked bro my excel is so fucked it has like 1/3 of these options, idk what braindead programmist managed to fuck up this programme in 2 years but they did a fantastic job