How to Add Error Bars in Excel (3 Suitable Ways)

Get FREE Advanced Excel Exercises with Solutions!

Using error bars is one of those frequent tasks that we do to describe a dataset precisely. If you are looking for ways to add error bars in Excel, this is the right place for you. Here, in this article, you will find step-by-step ways to add error bars in Excel.


What Is an Error Bar?

Error Bar is a graphical representation. It describes the variability of data and represents the error or uncertainty in a given data. It can give a general idea about the data.


How to Add Error Bars in Excel: 3 Ways

1. Using Chart Elements to Add Error Bars in Excel

Here, we have the following dataset containing the list of Fruits and their amount of Sales. First, we will see the graphical representation of the data in the Bar charts. Then, we will show you how to add the error bars in Excel.

How to Add Error Bars in Excel

Error bars can be added to the graph from chart elements. You can find step-by-step ways to add error bars in Excel below.

Steps:

  • First, select the data from cell B4:C12.
  • Then, go to Insert >> Chart.

How to Add Error Bars in Excel

  • After that, from the Bar charts select the 2-D column.

  • Finally, a Bar chart is created containing the values of the dataset.

  • Now, click on the ‘+’. You will be able to see the Chart Elements.
  • Then, add Axis Titles and Error Bars from there.

How to Add Error Bars in Excel

  • Finally, Error Bars are added to the Bar chart using Chart Elements.

How to Add Error Bars in Excel Using Chart Element


1.1. Inserting Standard Error Bars

In statistics, Standard Error is a mathematical technique for calculating variability. It allows one to evaluate the standard deviation of a given sample. It is expressed as SE which is used to calculate a sample’s efficiency, accuracy, and consistency.

To add the Standard Error bar in the Bar chart you have to follow the following steps.

Steps:

  • First, select the Bar chart and click on the ‘+’ sign.
  • Then, from Chart Elements select Error Bars >> then select Standard Error.
  • Finally, you can see the Standard Error Bars in the chart.

How to Add Standard Error Bars in Excel

  • The resultant chart shows Standard Error Bars.

 How to Add Error Bars in Excel

READ MORE: How to Add Custom Error Bars in Excel


1.2. Using Percentage Error Bars

Percentage Error bar shows the fluctuation of each data point in a dataset in percentage.
To add the Percentage Error bar to the Bar chart you have to follow the following steps.

Steps:

  • First, select the bar chart and click on the ‘+’ sign.
  • Then, from Chart Elements select Error Bars >> Percentage Error.
  • Finally, you can see the Percentage Error Bars in the chart.

How to Add Percentage Error Bars in Excel

  • The resultant chart shows Percentage Error Bars.

READ MORE: How to Add Individual Error Bars in Excel


1.3. Inserting Standard Deviation Error Bars

The standard deviation is a measure of how evenly distributed data is. It shows how widely your data is distributed around the mean or average. Its symbol is σ.
To add the Standard Deviation Error bar in the Bar chart, you have to follow the following steps.

Steps:

  • First, select the bar chart and click on the ‘+’ sign.
  • Now, from Chart Elements select Error Bars >> Standard Deviation Error.
  • Finally, you can see the Standard Deviation Error Bars in the chart.

 How to Add Standard Deviation Error Bars in Excel

  • The resultant chart shows Standard Deviation Error Bars.

Read More: How to Add Vertical Error Bars in Excel


2. Inserting Vertical and Horizontal Error Bars in Excel

We can add both Vertical and Horizontal Error Bars to our dataset. You will find ways to add these error bars below.

2.1. Adding Vertical Error Bars

We can add Vertical Error Bars where data is represented in a Bar chart. You can find the step-by-step ways to add vertical error bars below.

Steps:

  • To bring the Vertical Bar Chart follow the steps explained in Method_1.
  • Next, select the chart and click on the ‘+’ sign.

 How to Add Vertical Error Bars in Excel

  • Then, from Chart Elements select Error Bars >> More Options.

 How to Add Vertical Error Bars in Excel

  • This will open Format Error Bars.
  • Then, under Vertical Error Bar, choose the options you want. Here, we choose Direction as Plus and End Style as No Cap.

  • Finally, you will get the required chart with Vertical Error Bars.

 How to Add Vertical Error Bars in Excel


2.2. Adding Horizontal Error Bars

Horizontal error bars can be added to Bar charts, XY scatter plots, and bubble charts.

Here, we will create a Bar chart using the dataset and add Horizontal Error Bars to the chart.

Steps:

  • First, select the dataset from cell B4:C12.
  • Then, go to Insert >> Charts.

 How to Add Horizontal Error Bars in Excel

  • After that, from Bar Charts select 2-D Bar.

  • Now, select the chart and click on the ‘+’ sign.
  • Chart Elements will appear.
  • From there add Axis Titles.

 How to Add Horizontal Error Bars in Excel

  • Now, from Chart Elements click on Error Bars >> More Options.

  • This will open Format Error Bars.
  • Finally, under Horizontal Error Bar, choose the options you want. Here, we choose Direction as Minus and End Style as No Cap.

 How to Add Horizontal Error Bars in Excel

  • Finally, you will get the required chart with Horizontal Error Bars.

 How to Add Error Bars in Excel

Read More: How to Add Horizontal Error Bars in Excel


3. Adding Individual Error Bars in Excel

Here, we have a dataset containing the sales value of fruits for three consecutive months: January, February, and March. Average sales for each month are calculated using the AVERAGE function and the Standard deviation is calculated using the STDEV.P function.

Steps:

  • First, select cell C13 and insert the following formula.
=AVERAGE(C5:C12)
  • Then, press ENTER to get the Average value.

 How to Add Individual Error Bars in Excel

  • Now, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • After that, select cell C14 and insert the following formula.
=STDEV.P(C5:C12)
  • Then, press ENTER to get the Standard Deviation.

 How to Add Individual Error Bars in Excel

  • Finally, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

 How to Add Individual Error Bars in Excel

  • The final dataset is given below.

 How to Add Individual Error Bars in Excel

Now, we will create a Bar chart using the Average value of the sales in each month. Then, we will add the Standard Deviation Error bars to the chart.

Steps:

  • First, select the cells C13:E13.
  • Then, go to Insert >> Charts.

 How to Add Error Bars in Excel

  • After that, From Bar Charts >> select 2-D Column.

 How to Add Error Bars in Excel

  • Then, select the chart and click on the ‘+’ sign.
  • From Chart Elements add Axis Titles and change the Chart Title.

  • Finally, the bar chart for the Average sales is created.

 How to Add Error Bars in Excel

  • Now, click on the ‘+’ sign.
  • From Chart Elements select Error Bars >> More Options.

  • This will open Format Error Bars.
  • Then, under Vertical Error Bar, select Custom >> Specify Value.

 How to Add Error Bars in Excel

  • This will appear Custom Error Bar tool.
  • Select the values from cell C14:E14 for both Positive Error Value and Negative Error Value.
  • Finally, press OK.

 How to Add Error Bars in Excel

  • Finally, the desired chart is prepared.

 How to Add Error Bars in Excel


Download Practice Workbook


Conclusion

So, in this article, we have shown you how to add error bars in Excel. I hope you found this article interesting and helpful. If something seems difficult to understand, please leave a comment. Please let us know if there are any more alternatives that we may have missed.


Related Articles


<< Go Back To Error Bars in Excel | Excel Chart Elements | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Arin Islam
Arin Islam

Anowara Islam Arin, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Arin exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo