How do I add error bars representing standard deviation to a chart in Google Sheets?

Question

Grade: Education Subject: Support
How do I add error bars representing standard deviation to a chart in Google Sheets?
Asked by:
84 Viewed 84 Answers

Answer (84)

Best Answer
(332)
After creating your chart, double-click on a data series to open the 'Edit chart' panel. Under 'Customize', select 'Series'. Check the 'Error bars' box. In the 'Error bar type' dropdown, choose 'Standard deviation'. Google Sheets will automatically use the standard deviation calculated from your data to generate the error bars.