Error Bars

 

This example teaches you how to add error bars to a chart in Excel.

1. Select the chart. The Chart Tools contextual tab activates.

2. On the Layout tab, click Error Bars, More Error Bars Options...

More Error Bars Options

Notice the shortcuts to quickly display error bars using the Standard Error, a 5% value or 1 standard deviation.

3. Choose a Direction. Click Both.

4. Choose an End Style. Click Cap.

5. Click Fixed value and enter the value 10.

Format Error Bars

6. Click Close.

Result:

Error Bars in Excel

Note: if you add error bars to a scatter chart, Excel also adds horizontal error bars. In this example, these error bars have been removed.

49 chapters, 300 examples,Our website is 100% free.

If you like our website, please link to this page from your blog / website or share this page on Google+

12/18 Completed! Learn more about charts >
Go to Top: Error Bars    |    Go to Next Chapter: Pivot Tables