I have a question , so I did this experiment and only had one trial. The data points i collected was distance and time and I am calculating a quantity that rely on this data, is deviation or error bars in this case would be useless!?
As per my understanding you want to calculate response using previous trend. In that case line of best fit is a suitable tool: Follow this tutorial: th-cam.com/video/o202naENQs0/w-d-xo.html
Firstly click on any error bar, all error bars will be selected. After that, again click on the particular error bar that you want to edit. One error bar will be selected. Now you will be able to change the color of individual bar by using the method as describe in the video
Follow the procedure as I explained earlier. Click on error bar and you will observe that all error bars are selected then again click on the error bar of your interested. It will enable you to single out that particular error bar. Please avoid double click.
How to add error bars to a multiple line graph in excel: th-cam.com/video/OphkHRFk5go/w-d-xo.html
Thank you it helped a lot with my data plotting!
Glad it helped!
My excel doesn't have custom error bar...
The options arrangement varies depending on the version of excel. But, custom error bar option is available in each version. I have used excel 2016
I have a question , so I did this experiment and only had one trial. The data points i collected was distance and time and I am calculating a quantity that rely on this data, is deviation or error bars in this case would be useless!?
As per my understanding you want to calculate response using previous trend. In that case line of best fit is a suitable tool: Follow this tutorial: th-cam.com/video/o202naENQs0/w-d-xo.html
I dont have that option on the newest excel version, where can I find it?
This option is available in all excel versions. the location of the option may vary depending on the version
What is your ms Excel year?
excel 2016
i dont have the plus thing next to the graph? any help?
Very good explanation in very simple way.
Glad it was helpful!
Thanks Baba
Glad it helped
This was really helpful. Thank you😊
You're welcome!
Excellent explanation
Glad it was helpful!
Thank you!
You're welcome!
Thanks alot
Happy to help
감사합니다
You are welcome
Thank you! It helps a lot!
You're welcome!
Thanks so much you helped me for my physics class!
Great to hear!
good ... nice vdo
Thanks
Does anyone know how to change the color of individual error bars?
Firstly click on any error bar, all error bars will be selected. After that, again click on the particular error bar that you want to edit. One error bar will be selected. Now you will be able to change the color of individual bar by using the method as describe in the video
@@TeachingJunction for error bars, it doesn’t allow me to single out one error bar
Follow the procedure as I explained earlier. Click on error bar and you will observe that all error bars are selected then again click on the error bar of your interested. It will enable you to single out that particular error bar. Please avoid double click.
@@noahhewitt9150 It is very simple. I could not understand why it is not working in your excel
Thanks a lot!!
You're welcome!