Add custom error bars to Charts in Excel Online
My students need to be able to add previously calculated error bars to column graphs (to make a bar graph of means +/- standard errors). Adding this to the online version will make it easier for groups to be able to collaborate in real-time using the online version. This would make Excel online beat Google Sheets hands down for me.
Thank you for your suggestion and votes. We’ve recently rolled out a format task pane for charts and are investigating incorporating error bars as we continue to add more formatting capabilities for Excel Web.
Could really use this feature for our class too!
This should not be an optional feature! My students need this!!!
My students need this too!
Katye, I put together a video on how to do error bars within Google Sheets. I'm happy to share the video and the sheets assignment that goes along with it. Send me an email if you're interested.
charlescollis at claytonschools dot net
katye howell commented
Is this an option yet? My students need to be able to do this and have chromebooks. Neither google sheets nor excel online seem to have these
My students need to add error bars as well.
Please add error bars. our students need this as well.
I agree. My students need to be able to do the same. It is very disappointing that this was not thought ahead of time. It is a pretty basic function that needs to be available to students.
my teacher assigned a graph in a lab report and we are supposed to do it on excel but she required error bars. Our entire ib biology class and the future year students could definitely use an error bar option for those points
This also would make all the difference for me and millions of others. Billions maybe. (Gotta get your interest somehow)
Samantha Perry commented
Why is there still no error bar option on Excel online?! This is a serious downfall in my opinion.