Тёмный

Adding Custom Error Bars to Column Graphs in Google Sheets 

Piers Support
Подписаться 8 тыс.
Просмотров 81 тыс.
50% 1

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

Опубликовано:

 

20 сен 2019

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 48   
@barsdice6627
@barsdice6627 4 года назад
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
@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.
@loiubh
@loiubh 4 года назад
What about if I have a graph with different trials and want to add a different error bar to each bar on the graph?
@markschira
@markschira 2 года назад
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.
@mashedmatatoes4634
@mashedmatatoes4634 4 года назад
Jesus this is a life saver, big thanks for the tutorial!
@lillyzarra4290
@lillyzarra4290 2 года назад
This was a very helpful and straightforward video. Thank you so much!
@unluckypuppy9287
@unluckypuppy9287 2 года назад
Thank you so much for making this video. It's super helpful!!
@angelavillelasagastume9652
@angelavillelasagastume9652 3 года назад
Thank you so much!! This is 100% what I needed!
@chloewang2420
@chloewang2420 3 года назад
This is so helpful! Thank you very much!
@pyrixon2987
@pyrixon2987 Год назад
Thank you, spent a long time look for how to do this
@bianco215
@bianco215 Год назад
Thank you so much. Hours of frustration until I found this.
@natalieholding649
@natalieholding649 4 года назад
thank you so much this was so helpful
@MaxBoomingHere
@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
@EjiaLu
@EjiaLu 2 года назад
Thanks for the video. Life saver for Mac users
@benjaminomeara7498
@benjaminomeara7498 4 года назад
Thank you very much for the tutorial
@vaniabessos1691
@vaniabessos1691 Год назад
Very helpful, thank you!
@sophiesoto1187
@sophiesoto1187 3 года назад
you're a lifesaver
@dancer6898
@dancer6898 2 года назад
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?
@RobertKonigsberg
@RobertKonigsberg 4 года назад
Thanks, that helped!
@moffenbacher
@moffenbacher 5 месяцев назад
So helpful!
@user-yk7lx8th3j
@user-yk7lx8th3j 9 месяцев назад
Wow thanks so much!! Saved me so much time
@zawadi2547
@zawadi2547 7 месяцев назад
I love you for this
@mydearriley
@mydearriley 4 года назад
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
@dancer6898 2 года назад
this is the same problem I was having
@amandaburt6614
@amandaburt6614 4 месяца назад
This is a slay thank you
@Mentalcheez
@Mentalcheez 4 года назад
Great workaround, thanks! I thought you should know that the yellow error bar was incorrect (it was set to "Percent" instead of "Constant"). Cheers.
@tonywang5203
@tonywang5203 Год назад
This is amazing
@darianraizberg8442
@darianraizberg8442 2 года назад
an actual life savor
@arjanharjani3109
@arjanharjani3109 2 года назад
Thank you
@dagmarbirkfeld9327
@dagmarbirkfeld9327 2 года назад
Thanks, Kevin! Good to see your face pop up.
@willg9106
@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
@cost94 4 месяца назад
you saved me
@voidfishtm2371
@voidfishtm2371 3 года назад
Is there any way to do this with a line graph?
@PiersSupport
@PiersSupport 3 года назад
Try this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uP5XmXW5tBI.html&ab_channel=PiersSupport
@voidfishtm2371
@voidfishtm2371 3 года назад
@@PiersSupport Thank you! This is my first time making graphs online for a paper, so I appreciate the help.
@microbioman4252
@microbioman4252 Год назад
That LEFT-handed DNA helix tho!!! 🙄😲😄😄
@dmcglinn1
@dmcglinn1 Год назад
Great video! Too bad these are implemented in an easier way. Thank you for posting this hack
@t7yay
@t7yay 4 года назад
How can you do this with only two variables???
@PiersSupport
@PiersSupport 4 года назад
same idea, just two rows!
@t7yay
@t7yay 4 года назад
@@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!
@nevanoconnell3356
@nevanoconnell3356 Год назад
You know its bad when the word magically is thrown around by a scientist.
@smashingpumpkinscurry
@smashingpumpkinscurry 3 года назад
Mate!
@scheyeguy2479
@scheyeguy2479 3 года назад
Anyone else here for Mrs. Moss's 6th period Bio?
@thebigyeeter4282
@thebigyeeter4282 2 года назад
This man was my teacher
@andramalexh
@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
@rivercuperus1158 4 месяца назад
Sheets is so poorly made, but at least it's free
@shimalyalcin4600
@shimalyalcin4600 3 года назад
thats cool bro but i dont remeber asking
@shimalyalcin4600
@shimalyalcin4600 3 года назад
I LITERALY CAN NOT VEN ED O IT PROHLEOY SING A LINE GRAPH LIAR! I WILL COMIT TAX FRAUD NOW
Далее
How to Interpret Error Bars
6:39
Просмотров 34 тыс.
They got a Golden Buzzer 🤣✨
00:46
Просмотров 14 млн
Beautiful sport😍
00:20
Просмотров 325 тыс.
No one will play with him( #standoff #meme #grenade
00:12
How To Add Error Bars In Excel (Custom Error Bars)
4:05
*Using Google Sheets for Graphing w/Error Bars
14:08
Просмотров 18 тыс.
Standard Error
7:05
Просмотров 805 тыс.
They got a Golden Buzzer 🤣✨
00:46
Просмотров 14 млн