How to add standard error bars in Google Sheets

You can watch a video tutorial here.

Graphs are great ways to visualize data and Google Sheets has several tools for creating and formatting charts. The type of chart that you create depends on the dataset that you have. Error bars are ways of indicating how much uncertainty is built into the chart. Standard error bars indicate the standard deviation.

Step 1 – Open the Chart editor

– Select the chart
– Click on the 3 dots in the top left corner of the chart to display the menu options
– Select Edit chart

Step 2 – Open the Series for editing

– Choose the Customize tab
– Expand the Series dropdown 

Step 3 – Choose the Error bars

– Tick Error bars
– Close the Chart editor

Step 4 – Change the type

– Expand the Type dropdown
– Select Standard
– Keep the value as 1

Step 5 – Check the result

– Standard Error bars are added to the chart