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.


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.


Please show your appreciation by sharing this page

Go back to charts, Go to the right >>
Go to Top: Error Bars    |    Go to Next Example: Sparklines