Enable error bars when you want to show, for example, standard deviations in a chart, Excel lets you insert error bars to the following charts:
- 2-D area chart
- Bar chart
- Column chart
- Line chart
- x y scatter chart
- Bubble chart
Scatter and bubble charts let you show error bars for both x and y values.
How to enable
- Select chart.
- Click on "plus" sign next to chart.
- Click on checkbox "Error Bars" to enable it.
The arrow next to the "Error Bars" checkbox lets you choose between 3 different error bars:
- Standard error
- Standard deviation
How to customize error bars
Double-click on one of the error bars to open the task pane.
- Click "Error bars options" tab to display the settings above.
Excel lets you change the direction of the error bar, the end style and the error amount.