How to add standard error bars in Google Sheets
By
SpreadCheaters
Page last updated:
19/04/2023 |
Next review date:
19/04/2025
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
