Google Sheets: Graphing with separate (custom) Error Bars of Standard Deviation. 

Hey brother, my students have seen your videos and you have saved them a lot of time and confusion. I really appreciate your help and please continue to keep up the good work.

This video is saving my day Thank you!!

this video saved my ass ive been trying to do this for a few hours💀 I ❤ PETER STANLEY !THANK YOU SO MUCH!

my guy coming in clutch

Oh wow, that was painful. I think I won't bother now! I got here because I thought picking "standard deviation" would help me - like it would compute the standard deviation of my series and use that for each point, but no. Wouldn't it be nice if they allowed you to just pick another column for error bars values? Did some more research on this - when you use "Standard deviation" it computes STDDEV of the entire series and the plots the error bars for each point centered around the median of the series. The number you enter is a multiplier on STDDEV so 1 for +- 1 standard deviation. This only works for a normally distributed series about a mean. You can't use it for an X-Y plot of a variable and a dependent value. There is a feature of charts where you enter two columns of values for X and Y, highlight those for a scatter plot and select aggregate values on the X-axis. So then if a row has the same X as another row then it can aggregate those values as min, max, mean, median, sum, count. You'd THINK that for that set up then stddev for error bars could do the stddev of all the rows with the same X. But no, it doesn't work like that - it is still series based. So you still need to turn each X-Y point into its own series.

Seriously helpful, and quite understandable! Thanks for saving my lab report!

You’ve helped me sooo much! THANKYOU 👏🏻

Thank you so much !!! you saved my lab report !!

thank you so much! you saved me so much time from trying to figure this out on my own!

Great Video I was trying to figure out how to do this in sheets.

Wow! I am alternating between "this is idiotic" for the situation and "Brilliant" for the workaround. My thanks- though I suspect my students will *not* thank you right away.

Thank you! You saved me!

THANK YOU, it seriously saved me

Thank you so much! I would not have been able to figure this out without this video

Thank you!

Thank youuuuu! Very helpful.

Fantastic. Simple and it works. You have saved me hours.

Hello, this video was really great. Do you know how to do the same thing with a graph that has multiple lines ?

This is a nice workaround for five data points. But how would you deal with 1,000 data points? Or the need to have asymmetrical error bars, with a different + and - value? It's sad that Google hasn't done anything about this for years.

The values you've inputted were values of standard deviation. Why did you click constant? Thanks for making our to separate the series clearer, by the way!

life save thank you so much

thanks yo this saved my bio grade

I appreciate your effort, thank you.

KING 👑

Why we do have to insert STD manually? I really don't understand why I cant mark a cells with STD, like in excel.

Thank u this was so helpful

Thank you so much

thanks that was so helpful!!!!

Thank you so much!

So what you're saying is basically "use Excel". It's good to know that it's technically possible and it's a good explanation, but this method is simply not sustainable for large sets of data.

manually?

Thank you

Thanks bro 👍

ty

You can’t customize error bars on excel

thanks for the tuto! this system is garbage :( there should be an option to apply error bar to a serie given another serie

Thank you!