How to Show Error Bar in Google Sheets Chart

Sometimes you might want show error bar in google sheets. If so, you can follow this guide to get the job done. Whether you want to add an error bar for a line chart or a pie chart, it’s all possible using this step-by-step guide.

Suppose you have created a chart in Google Sheets. In addition to showing the graph only to viewers, you want to show the percentage by which they missed something. For example, if someone scored 76% on a test, you want to show them the percentage by which they fell short of being the best.

For this, you don’t need to use any third-party add-ons or services because Google Sheets comes with such an inbuilt option that will do the job. FYI, you can find this option in almost all chart types, but it works best for line charts.


To note: Before heading to the next guide, make sure you have already added the chart to your spreadsheet.

To show the error bar in the Google Sheets chart, follow these steps:

  1. Double click on the chart and switch to Personalize tongue.
  2. Expand the Series section.
  3. Check it Error bars check box.
  4. Choose the type of error bar.
  5. Enter the value.

To learn more about these steps, keep reading.

As mentioned earlier, you first need to view the chart in Google Sheets. Then double click on the chart and go to Personalize tab on the right side.

Here you will find different sections. From there, expand the Series section and check the Error bars check box.

How to show error bar in Google Sheets chart

Next, you need to choose the type of error bar. For your information, there are three types: Constant, Percentage and Standard Deviation. If you choose the Constant option, and set the value to 50, it will show the range from 50 to 150. Also the standard deviation works the same as it should.

When complete, the graph will look like this:

how to show error bar in google sheets chart

Lily: How to Count Checkboxes in Google Sheets

To put error bars on a chart in Google Sheets, you need to follow the aforementioned steps. In other words, you can do it with the help of the Series section. It contains an option called Error bars which allows users to display error bar as per requirements.

To add error bars to a chart, you can follow these steps. First, add the chart in Google Sheets, double click on it and select it Personalize option. Then expand the Series section, and check the Error bars check box. Finally, set the error bar type and choose the value accordingly.

That’s all! I hope this guide has helped.

Lily: Google Sheets tips and tricks; Tutorial to make the most of its features.

how to show error bar in google sheets chart

Leave a Comment