Adding Custom Error Bars to XY Scatter Plots 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 XY scatter plots. Oh, and don't forget the trend line. Its a bit tricksy!

[@hockeysc871]

My IA is about to be 👌🏽👌🏽

[@cheetodust658]

IB chem students do be loving this video

[@hitzcritz]

This is EXACTLY what I was looking for! Thanks so much!

[@alexmichaelsafayan1814]

PIERS I LOVE YOU MAN

[@infundere]

Thank you. I have a question that you may know the answer to: How can I add error or uncertainty bars for the x-axis as well on Google Sheets? Thank you again.

[@janiceyang8672]

thank you so much sir.

[@PeterStanley]

Very nice work! I wish google would sort this out (ala Excel). Cheers.

[@leonghw]

Thanks, but this is so MANUAL.
Is there no way to specify that error bar values should come from H2:H6 of the data?

[@winvictorywin5612]

Hello sir,
I am having airborne dust concentrations data as PM10, PM2.5, PM 1 .
These data was taken before and during dust producing work in a civil construction site.
N=5
How can i compare these before and during operations data ?
It seems that there is percent variation in dust concentrations in atmosphere between before and during operation data based on particle size.
Before operation:
PM 10 ( particle size less than 10 microns) is sharing 40% of total airborne dust, and PM 2.5 ( particle size less than 2. 5 micron) shares 10% of total airborne dust.
During machine operation:
PM 10 shares 60% and PM 2.5 10% only.
It seems that PM 10 share is increased due to that machine operation?
Which test is suitable for analysing these type similar data for discussion ?
How to use statistics?
Any comparison among these particle sizes?
thank u.

[@TheAlex010]

there really should be an easier way to do this