How to Add Error Bars to Charts in Google Sheets

Last Updated on November 3, 2023 by Jake Sheridan

In this tutorial, you will learn how to add error bars to charts in Google Sheets.

How to Add Error Bars to Charts in Google Sheets

In spreadsheets, error bars are graphical representations of data variation. They demonstrate the accuracy of a measurement. Standard deviation and standard error are commonly represented as bars. They show how far the genuine value differs from the determined value.

On charts, error bars provide a more thorough perspective of the data set by allowing readers to see the data’s margins or errors.

Once you are ready, we can get started by using real-life scenarios to help you understand how to add error bars to charts in Google Sheets.

Add Error Bars to Chart

Before we begin we will need a group of data to be used to create a chart and add error bars to it.

Step 1

Make sure your group of data is displayed in a clean and tidy manner. This will help us to create the chart easily.

Untitled

Step 2

Select the entire data cell, choose Insert, and select Chart.

Untitled

Step 3

By default, Google Sheet will use the selected group of data to generate a pie chart. Simply change the chart to a column chart in the Chart Editor.

Untitled

Step 4

To add the error bars, simply Series, tick Error Bars, and customize them to your preference. ​​The error bar has been set to encompass +/- 10% of each value in the column in this example. Percentage type error bars are what they’re called.

Untitled

Step 5

Once you are done editing and customizing the chart, it will look something like this.

Untitled

Summary

That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to make categories in google sheets. Want more? Check out all the Google Sheets Tutorials.