Error limits on Excel charts

In this example, we will show how to show margins of error on a chart in Excel.

1. Select a chart. A group of tabs will appear on the Menu Ribbon Working with charts (Chart Tools).
2. On the Advanced tab Layout (Layout) click Error limit (Error Bars) > More options (More Error Bars Options). Note that to quickly add error bars to the graph, a standard deviation value of 5% of the considered value or 1 standard deviation is used.
3. Find the parameter Direction (Direction). Check option All (Both).
4. Find the parameter Edge style (End Style). Check option Point (Cap).
5. Click fixed value (Fixed Value) and enter the value 10.
6. Click Close (Close).

Result:

Note: For a scatter plot, Excel also displays horizontal margins of error. In this example, these limits have been removed.