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

Advertisement

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.

Advertisement

Like this free tutorial? Please share, pin, tweet or +1 this page.

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