Graphical representations of data variability in Excel
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
Error bars in Excel are graphical representations of data variability. They show the precision of a measurement. The bars usually represent standard deviation and standard error. They indicate how far from the determined value the true value is.
Error bars on charts provide a more comprehensive view of the data set and allow users to see the margins or errors in the data.
How to Add Error Bars in Excel?
Microsoft Excel allows you to add error bars to certain types of charts, including line charts, bar charts, and scatter charts.
The following steps will help you to add errors bars to your Excel charts:
1. Click on your chart.
2. Click the Chart Elements (plus sign).
3. Check the box Error Bars and click the arrow next to it. You will see a list of items that you can add to your chart.
You can add the following errors bars to your chart:
Standard Error: Indicates the standard error for all values in the dataset.
Percentage: Determines a percentage error range and error amount for each value.
Standard Deviation: Displays a standard deviation for all values.
You can also modify the default error bars to suit your needs:
Click More Options in the Error Bars.
The Format Error Bars menu will pop-up on the right side of your screen. Here, you can modify the style of the error bars, as well as the error amounts for the bars.
Thank you for reading CFI’s guide to adding error bars in Excel. CFI offers a library of resources and training materials designed to help you learn Excel in the most efficient way possible. To learn more, check out these additional resources:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.