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.

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