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 STANDARD ERROR IN EXCEL

HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Software (Microsoft Excel 365 ProPlus)

FOLLOW US

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.

[mackthemark]

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.

[maximontes]

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!

[edgypancreas]

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

[jackwhitehead]

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.

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

[robbuckland]

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

[rbarrett]

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." :)

[sowsan]

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

[leahkimerer]

This is exactly what I needed! Thank you!

[jacksonrottier]

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

[emilymccann]

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

[halofreak]

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

[skyzrpeterson]

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

[highwilllee]

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.

[konnerbaker]

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

[linganileonjdube]

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

[ivystar]

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 (:

[gregorymoilwa]

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

[cogwheelLearning]

Hey, really nice video! Your flow is excellent

[bofumxt]

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