Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Forecasting and Modeling
      • Alteryx
        • Introduction to Alteryx
      • Power BI
        • Power BI – Beyond the Basics
        • Power BI
      • Qlik Sense
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop
      • Python
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Sign Up
Home > Microsoft Excel > How to Add Error Bars in Excel? 7 Best Methods

How to Add Error Bars in Excel? 7 Best Methods

Note: This guide on how to add error bars in Excel is suitable for Excel 2010, 2013. 2016, 2019, and Office 365 versions. 

Error bars in Excel help visualise the error margins or standard deviation in your data. Add them to your charts to show the error in absolute or percentage terms or standard deviations. 

They can be added to all the data points in a series to display a preset error percentage of the user’s choice. Error bars are very suitable for bar, column, line, scatter, and bubble charts. 

In this guide, I am going to explain how to add error bars in Excel along with their various use cases with the help of illustrations. 

Table Of Contents
  1. Error Bars in Excel – An Overview
  2. How to Add Error Bars in Excel 2013 and Later Versions?
  3. How to Add Error Bars in Excel 2010 and Earlier Versions?
  4. How to Add Custom Value Error Bars in Excel?
  5. How to Add Individual Error Bars in Excel?
  6. How to Add Horizontal Error Bars In Excel?
  7. How to Add Error Bars In Excel for Specific Data Series?
  8. How to Format Error Bars in Excel? 
  9. Let’s Wrap Up

Related:

How to Extract an Excel Substring? – 6 Best Methods

How to Superscript in Excel? (9 Best Methods)

How To Find Duplicates in Excel? (3 Easy Methods)

Watch this video to learn how to add error bars in Excel

Error Bars in Excel – An Overview

Error bars are a very useful tool to represent the errors or the variability in a data set. That is they display how far the real value can deviate from the measured value. It is a very important tool in statistical analysis and scientific experiments. 

how to add Error Bars in Excel
Error Bars in Excel

In Excel, error bars can be added to suitable charts like bar, column, line, scatter, and bubble graphs. The user has the option to add the following forms of the error bar:

  1. As a standard error
  2. As a percentage error
  3. As a fixed value
  4. As a standard deviation 

Users can also set their own predefined error amount and set individual values for each error bar in the series. 

Adding error bars in Excel 2013 and later versions is slightly different from the method applicable to the earlier versions. These are explained in separate sections below. 

Also Read:

How to Use Goal Seek in Excel? (3 Simple Examples)

How to Insert Multiple Rows in Excel? The 4 Best Methods

How to Autofit Excel Cells? 3 Best Methods

How to Add Error Bars in Excel 2013 and Later Versions?

To add error bars in Excel 2013, Excel 2016, Excel 2019, and Microsoft Office 365 versions follow these steps after plotting suitable graphs: 

Step 1: Click anywhere in the graph

Step 2: Click on the Chart Elements option in the top-right corner of the chart. 

How to add error bars in Excel
Click on Chart Elements to access Error bars

Step 3: Click on the Error Bars arrow to expand it and select a suitable option. 

  • Standard Error – To display the standard error for all values, that is the how far the sample mean is from the population mean of the data series.
  • Percentage Error – To add percentage error bars to your chart. The default percentage error is 5%, which can be changed from “More options”.
  • Standard Deviation – To show the standard deviation of the data point i.e. how far is it from the average.
  • More Options – To edit error bar values and to create custom error bars. It will open the Format Error Bars pane where you can do the following: 
Click on the arrow next to Error bars for More options
Click on the arrow next to Error bars for More options
  1. Set custom values for the fixed value, percentage, and standard deviation error bars.
  2. Choose the direction of the error bars (positive, negative, or both)
  3. Make custom error bars based on custom values.
  4. Format the appearance of error bars. 

To insert standard error bars in the chart, you can directly select the Error Bars option. 

To customize the error bars after adding them, double click on any one of them to access the Format Error Bars pane, where you can edit everything about them. 

How to Add Error Bars in Excel 2010 and Earlier Versions?

To add error bars in earlier versions of Excel i.e. versions 2010 and 2007, follow these steps:

Step 1: Click on the chart to access the Chart Tools tab in the Excel ribbon. 

Step 2: Under the Chart Tools tab, locate and click on the Error Bars option. It can be found in 

             the Analysis group in the Layout tab. 

Look under the Analysis group in the Chart tools tab for the Error bars option
Look under the Analysis group in the Chart tools tab for the Error bars option

How to Add Custom Value Error Bars in Excel?

If you want to add your own custom value error bars to your charts follow these steps:

Step 1: Click Chart Elements > Error Bars > More Options to access the Format Error Bars 

   pane

How to Add Custom Value Error Bars
Click on the Custom option under Error Amount

Step 2: Click on the Error Bars options tab. 

Step 3: Under Error Amount, click Custom and click on Specify Value

Step 4: In the Custom Error Bars Dialogue box enter the Positive Error Value and Negative 

  Error Value. If you don’t want a positive or negative value you must enter zero. 

Specify positive and negative error values

That’s it, you have added custom value error bars to your graph. 

How to Add Individual Error Bars in Excel?

Sometimes, you will need to add different individual error bars of varying lengths to each data point in the series. To do this, follow these steps: 

Step 1:  Calculate the Standard deviation of each data point using the STDEV.P function in an 

    adjacent row or column. 

Step 2: Click Chart Elements > Error Bars > More Options to access the Format Error Bars 

   pane

Step 3: Click on the Error Bars options tab. 

Step 4: Under Error Amount, click Custom and Click on Specify Value

How to add individual error bars in Excel?
Under the Positive and Negative Error Value boxes enter the cell reference for the Standard Deviation values calculated for each data point

Step 5: In the Custom Error Bars Dialogue box for the Positive Error Value and Negative 

  Error Value, enter the cell reference for the Standard deviation values we just 

  calculated. 

Individual Error Bars for each data point
Individual Error Bars for each data point

Congratulations, you have successfully added individual error bars of varying lengths of standard deviation to each data point in the data series. 

How to Add Horizontal Error Bars In Excel?

Horizontal error bars are by default added to horizontal bar charts, bubble, and scatter graphs. They are added along with the vertical error bars. 

But, if you need only the horizontal error bars, delete the vertical error bars by right-clicking on any one of them choosing the delete button. 

How to Add Error Bars In Excel for Specific Data Series?

In case if you are using a combo chart in your Excel sheet, it is advisable to add error bars only to one particular data series in the chart. This will avoid confusion by reducing the clutter. 

To do this, just click on the specific data series you want to add error bars to, and then click on the Chart Elements button. Now, click the arrow next to Error Bars and pick any desired type. 

Doing this will add error bars only to the data series you selected. 

How to Format Error Bars in Excel? 

To edit the appearance of the error bars in Excel follow these steps: 

Step 1: Double Click on the Error bars in the chart you want to edit. 

Step 2: To change the appearance of the error bar like colour and width, choose the Fill & Line 

tab. There, you will have the option to change everything about the appearance of the 

error bar. 

Change the appearance of the error bar under the Fill & Line section of the Format Error bars pane
Change the appearance of the error bar under the Fill & Line section of the Format Error bars pane

Step 3: Click on the Error Bars options tab to change the type, direction and style of the error 

bars

Suggested Reads:

How to Group Worksheets in Excel? (In 3 Simple Steps)

How to Shade Every Other Row in Excel? (5 Best Methods)

How to Use the Excel Fill Handle Easily? (Top 3 Uses with Examples)

Let’s Wrap Up

We are at the end of this guide on how to add error bars in Excel. If you have any questions about this or any other Excel feature, let us know in the comments. We are always happy to help. 

If you need more high-quality Excel guides, please check out our free Excel resources centre.

Ready to dive deep into Excel? Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Adam Lacey

Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats. When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.

30 day vertical banner

Most Popular Posts

  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15
  • How to Create Charts and Graphs in Microsoft Excel 2016

Similar Posts

How to Open a Workbook in Microsoft Excel 2016

Editing Images with Photoshop CS6 Camera Raw

Using Adjustment Layers in Photoshop Elements 11

Manual Mail Merge Setup in Word 2010

How to Assign a Fixed Cost to a Task in Microsoft Project 2016?

How to Unmerge Cells in Excel? 3 Best Methods

Course Categories

  • Web Development
  • QuickBooks
  • Microsoft
  • Adobe
  • Data Analysis

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebook
© 2022 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)