How To Add Error Bars In Google Sheets (Step-By-Step 2022)

Written by Abid Akon

Here's what we'll cover:

When representing data graphically, there are levels of uncertainty and intervals between each value in the dataset. These variables are represented as Error bars.

Understanding how to fix error bars in Google sheets is very important. In this tutorial, we are going to learn step by step How To Add Error Bars In Google Sheets.

What are Error bars in Google Sheets?

Error bars are used to indicate the intervals and differences in your chart. They are used to display variability and instability in data.

They are mostly used in column charts, area charts, line charts, and bar charts. Values in datasets tend to be imperfect or somewhat false due to the passing of information from one medium to another. Error bars help to display levels of uncertainty in a given dataset. 

How To Add Error Bars in Google Sheets.

To add error bars, you must first create a column chart or bar chart with the given dataset. In the sample worksheet below, we have the names of fruits and vegetables and the total amount sold in May. 

1How To Add Error Bars In Google Sheets

This is what we’ll use to create a chart and add error bars of values. 

Step 1: Highlight the cell range. Ensure the headers are included in the selected range. 

2How To Add Error Bars In Google Sheets

Step 2: Navigate your way to the toolbar and click Insert. 

3How To Add Error Bars In Google Sheets

Step 3: From the drop-down menu displayed, select Chart. 

4How To Add Error Bars In Google Sheets

Alternatively, you can click on the Insert Chart icon on the far right of the toolbar. 

5How To Add Error Bars In Google Sheets

Step 4: Google Sheets automatically inserts a column chart. Sometimes, a different chart like a pie chart can be inserted.

6How To Add Error Bars In Google Sheets

To change the chart type, double click on the chart to open the Chart Editor. 

Step 5: Under the Setup Editor, select Chart Type and select the Column Chart to change the given chart. 

7How To Add Error Bars In Google Sheets 1
8How To Add Error Bars In Google Sheets

Step 6: A column chart is inserted into the worksheet. 

9How To Add Error Bars In Google Sheets

Now that we have our column chart, let’s insert error bars into the chart. It is done by following the steps below. 

Step 1: Open the Chart Editor by either double-clicking on the chart or clicking on the three dots and selecting Edit Chart. 

Step 2: Under the Customize tab, Select Series. 

10How To Add Error Bars In Google Sheets

Step 3: Under the Series section, scroll down and check the checkbox beside Error Bars.

7How-To-Add-Error-Bars-In-Google-Sheets-2

Error bars would be inserted into the column chart. 

12How To Add Error Bars In Google Sheets

How To Customize Error Bars in Google Sheets. 

Now that the error bars are inserted into the chart, you can customize the type of error bars and the value each error bar represents. 

Step 1: Go to the Type section under Series, to customize the type of error bar you want to insert in your chart. 

Step 2: From the dropdown list displayed, you can select any of the error bar types which are Standard Deviation, Constant, and Percent.

13How To Add Error Bars In Google Sheets

Step 3: In the Value section, you can add the value to the error bars. Input the value into the Value textbox.

14How To Add Error Bars In Google Sheets

Step 4: Error bars are added to the column chart and they display the type and value assigned to them. 

15How To Add Error Bars In Google Sheets

Types of Error Bars in Google Sheets. 

In the previous section,  I mentioned the types of error bars as Standard Deviation, Percent, and Constant but I’m pretty sure you don’t understand what these types are and what they do. In this segment, I’ll explain these terms in detail. 

Constant. 

As the name implies, the value would be made a constant error bar. It won’t be changed across the column chart. If the constant is set as 5, it would be placed as -5 and +5 in the chart. 

16How To Add Error Bars In Google Sheets

Standard Deviation. 

The Standard Deviation type is placed in the middle of the column chart. It illustrates how the data is scattered around the mean value in the dataset. 

17How To Add Error Bars In Google Sheets

Percent. 

The Percent error bars display the upper and lower difference of the data in the column chart according to the percentage value entered. 

For example, if you enter the percentage value as 20%, the error bar would be placed between 80% and 120% of the dataset.

18How To Add Error Bars In Google Sheets

Final Thoughts. 

If you are a Google Sheets user that mostly specializes in graphical representations of data, be sure to learn this feature to increase interpretation and understanding in the analysis of your data.

Now you know How To Add Error Bars In Google Sheets. I hope you found this article helpful. 

Abid Akon

Abid Akon

I am a tech content writer. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I am writing articles to share my tech knowledge with you.

Related Articles

MD Abid Akon

Abid Akon

Hi, I am Abid. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I’ve created this website to share my technology keeping knowledge with you. Welcome to ”abidakon.com”

Abid Akon

My Personal Favorites
YouTube Channel