Y Error Bars
/text/schart/01/04050000.xhp
Y Error Bars
i85330
Use the
Y Error Bars
dialog to display error bars for 2D charts.
An error bar is an indicator line that spans over a range from y - NegativeErrorValue to y + PositiveErrorValue. In this term, y is the value of the data point. When "standard deviation" is selected, y is the mean value of the data series. NegativeErrorValue and PositiveErrorValue are the amounts calculated by the error bar function or given explicitly.
The
Insert - Y Error Bars
menu command is only available for 2D charts.
Error category
In the
Error category
area, you can choose different ways to display the error category.
None
Does not show any error bars.
Constant value
Displays constant values that you specify in the Parameters area.
Percentage
Displays a percentage. The display refers to the corresponding data point. Set the percentage in the Parameters area.
Functions
Select a function to calculate the error bars.
Standard Error: Displays the standard error.
Variance: Displays the variance calculated from the number of data points and respective values.
Standard Deviation: Displays the standard deviation (square root of the variance).
Error Margin: Displays the highest error margin in percent according to the highest value of the data group. Set the percentage in the Parameters area.
Cell Range
Click Cell Range and then specify a cell range from which to take the positive and negative error bar values.
Click a button to shrink the dialog, then use the mouse to select the cell range in the spreadsheet. Click the button again to restore the dialog to full size.
From Data Table
For a chart with its own data, the error bar values can be entered in the chart data table. The Data Table dialog shows additional columns titled Positive Y-Error-Bars and Negative Y-Error-Bars.
Positive (+)
Enter the value to add to the displayed value as the positive error value.
Negative (-)
Enter the value to subtract from the displayed value as the negative error value.
Positive (+) when Cell Range is selected
Enter the address range from where to get the positive error values. Use the Shrink button to select the range from a sheet.
Negative (-) when Cell Range is selected
Enter the address range from where to get the negative error values. Use the Shrink button to select the range from a sheet.
Same value for both
Enable to use the positive error values also as negative error values. You can only change the value of the "Positve (+)" box. That value gets copied to the "Negative (-)" box automatically.
Error indicator
Specifies the error indicator.
Positive and Negative
Shows positive and negative error bars.
Positive
Shows only positive error bars.
Negative
Shows only negative error bars.