<< Click to Display Table of Contents >> Showing/hiding error bars |
Note: This chart element is only available for certain two-dimensional chart types, such as column, bar and line charts.
You can draw error bars for the data points of a data series. Error bars display the possible/tolerable error of the values in the form of a line with a short dash at the end.
To show or hide error bars, proceed as follows:
Via the "Add chart element" icon
Select the chart and use the ribbon command Chart | Add chart element to choose the entry Error bars. In the following submenu, you can choose from a predefined selection for displaying the values. A check mark in front of it indicates the setting which is currently enabled.
If you choose the entry None, the data labels will be removed.
The entry More takes you to the dialog box with additional options (see below).
Via the dialog box
Additional options for error bars can be found via the dialog box:
1. | Select the chart by clicking on it. |
2. | Use the ribbon command Chart | Add chart element to choose the entry Error bars and select More in the following submenu to open the dialog box. |
Alternatively: Select the desired data series and right-click to open the context menu and select the entry Series: Properties. |
3. | Switch to the Error bar tab and select the desired settings here. |
For more information on the options of the dialog box, see Data series and data points, "Error bar" tab.