Software & Apps MS Office How to Add Error Bars in Excel Get more accurate estimates and measurements by Lisa Mildon Lifewire Tech Review Board Member & Writer Lisa Mildon is a Lifewire writer and an IT professional with 30 years of experience. Her writing has appeared in Geekisphere and other publications. our editorial process Facebook Twitter LinkedIn Lisa Mildon Updated on August 21, 2019 Tumisu/Pixabay MS Office Excel Word Powerpoint Outlook Tweet Share Email Whether you’re a statistician or need to track variables in your monthly sales, Error Bars in Excel can provide a great visual on just how accurate your numbers or measurements are compared to the actual value. With Excel’s built-in measurements using percentages, deviations, and more, you should be able to get a more accurate picture of your data. Below is how to use Excel’s Error Bars to get you a more accurate idea of your measurements. Instructions in this article apply to Excel 2019, 2016, 2013, and Microsoft 365. How to Add Error Bars in Excel Adding Error Bars to your Excel chart is a relatively simple process. Best of all, if you need to remove it, simply reverse the instructions. Select the chart within your Excel spreadsheet. Select Chart Elements, represented by a green plus (+) sign next to the top right of the chart. Select Error Bars. You can also select the arrow next to Error Bars, then select Standard Error, Percentage, Standard Deviation, or More Options. Standard Error, Percentage, and Standard Deviation are predefined in Excel. For more customized settings, select More Options. The Add Error Bars dialog will open up. Choose which Series to customize, then select OK. A side window will open within Excel. Here you can adjust the Direction, End Style, and the Error Amount of the Error Bar using a Fixed value, Percentage, Standard deviation, Standard error, or create a Custom value. Using Error Bars' More Options If you choose to customize your error bars in your chart, as explained above, there is the More Options setting. More Options gives you the ability to make several customizations, including some colorization of different aspects of the Error Bars. After selecting Error Bars > More Options, you’ll be prompted to select which series to add Error Bars to. Select the Series, then select OK. The Format Error Bars side window will open. Depending on what type of chart you have, the options will change slightly. In this example, a horizontal bar chart was chosen. Scatter charts can display both horizontal and vertical error bars. To get rid of them, select them, then press the Delete key. The Horizontal Error Bar section contains 2 different settings. Under Direction, you have a few options for the Error Bar: Both: Error Bar goes in both directions Minus: Error Bar goes to the right of the linePlus: Error Bar goes to the left of the line The End Style gives you the option to have a Cap or No Cap on the end of your Error Bar. The last section sets the Error Amount. Here you can set a customized Fixed value, Percentage, or Standard Deviation. You can also select Standard Error or Custom to add further customization to the Error Amount. If you choose Custom, select Specify Value. From here, you can adjust the Positive and Negative Error Value. Once set, select OK. You can repeat this process for each series by selecting the dropdown menu next to Error Bar Options. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Email Address Sign up There was an error. Please try again. You're in! Thanks for signing up. There was an error. Please try again. Thank you for signing up. Tell us why! Other Not enough details Hard to understand Submit