Adding Custom Error Bars to Column Graphs in Google Sheets

This video will show you how your can add custom error bars, such as standard deviation and SEM, to your Google Sheets column graphs. For help on what standard deviation and SEM are and how to interpret them as error bars, check out this video:
bit.ly/PiersSupport-SD-SEM

[@barsdice6627]

Perhaps the most common thing to add to a graph of data..... how can sheets just _not_ have this as a feature. Thank you for the video

[@dannyvanny]

Finally someone knows how. Whenever I look it up it just tells me how to add error bars to each graph of the series.

[@markschira]

Thanks for the video, it's well made and helpful. Of course the real solution would be for Google to add support for "custom" where one could provide the error bar values from the sheet. It does not seem like much to ask for.

[@loiubh]

What about if I have a graph with different trials and want to add a different error bar to each bar on the graph?

[@mashedmatatoes4634]

Jesus this is a life saver, big thanks for the tutorial!

[@lillyzarra4290]

This was a very helpful and straightforward video. Thank you so much!

[@bianco215]

Thank you so much. Hours of frustration until I found this.

[@unluckypuppy9287]

Thank you so much for making this video. It's super helpful!!

[@pyrixon2987]

Thank you, spent a long time look for how to do this

[@angelavillelasagastume9652]

Thank you so much!! This is 100% what I needed!

[@chloewang2420]

This is so helpful! Thank you very much!

[@EjiaLu]

Thanks for the video. Life saver for Mac users

[@natalieholding649]

thank you so much this was so helpful

[@MaxBoomingHere]

Thank you! This helped a lot. Although Google Sheets has gotten better since the making of this video, the standard deviation error bar they have isn't correct lol. For some reason using constant actually makes it work correctly

[@benjaminomeara7498]

Thank you very much for the tutorial

[@user-yk7lx8th3j]

Wow thanks so much!! Saved me so much time

[@vaniabessos1691]

Very helpful, thank you!

[@dancer6898]

What about when you have a stacked bar chart? Inverting when you already have two series makes it turn out really weird and it doesn't work. How would you add the standard deviation in this instance?

[@sophiesoto1187]

you're a lifesaver

[@Mentalcheez]

Great workaround, thanks! I thought you should know that the yellow error bar was incorrect (it was set to "Percent" instead of "Constant"). Cheers.

[@darianraizberg8442]

an actual life savor

[@moffenbacher]

So helpful!

[@RobertKonigsberg]

Thanks, that helped!

[@dagmarbirkfeld9327]

Thanks, Kevin! Good to see your face pop up.

[@zawadi2547]

I love you for this

[@faribashah4854]

Do the same steps apply for a scattergraph?

[@amandaburt6614]

This is a slay thank you

[@tonywang5203]

This is amazing

[@mydearriley]

Is this possible to do if there are two data points per value on the x-axis (arranged in two "series")? I've tried this method and the result is that all data points cluster on the first x-value and the other x-axis values are left empty (should have two bars per x-axis value). Unfortunately/optimistically, this is the only way I've found to gain access to the option to customize error bars for each bar in the two "series."

[@dancer6898]

this is the same problem I was having

[@arjanharjani3109]

Thank you

[@microbioman4252]

That LEFT-handed DNA helix tho!!! 🙄😲😄😄

[@willg9106]

Office 365 doesn't have a custom error bars feature either. So I switched to Sheets expecting to find it there... nope. Why isn't there a standard "I want custom bars!" button, there used to be. Thanks for the video.

[@cost94]

you saved me

[@dmcglinn1]

Great video! Too bad these are implemented in an easier way. Thank you for posting this hack

[@nevanoconnell3356]

You know its bad when the word magically is thrown around by a scientist.

[@voidfishtm2371]

Is there any way to do this with a line graph?

[@PiersSupport]

Try this: kzbin.info/www/bejne/q4GYiaCOjJqneKs&ab_channel=PiersSupport

[@voidfishtm2371]

@@PiersSupport Thank you! This is my first time making graphs online for a paper, so I appreciate the help.

[@t7yay]

How can you do this with only two variables???

[@PiersSupport]

same idea, just two rows!

[@t7yay]

@@PiersSupport Yes! I figured it out! Thanks so much! I sent this video over to my professor so she can share it with other Chromebook using students!

[@scheyeguy2479]

Anyone else here for Mrs. Moss's 6th period Bio?

[@thebigyeeter4282]

This man was my teacher

[@smashingpumpkinscurry]

Mate!

[@shimalyalcin4600]

thats cool bro but i dont remeber asking

[@andramalexh]

this was not what the video says. You were just adjusting the length of the error bar. I thought you were going to adjust the position and maybe the color. this is pointless

[@rivercuperus1158]

Sheets is so poorly made, but at least it's free

[@shimalyalcin4600]

I LITERALY CAN NOT VEN ED O IT PROHLEOY SING A LINE GRAPH LIAR! I WILL COMIT TAX FRAUD NOW