From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/schart/01/04050000.xhp | 125 ++++++++++++++++++++++++ 1 file changed, 125 insertions(+) create mode 100644 helpcontent2/source/text/schart/01/04050000.xhp (limited to 'helpcontent2/source/text/schart/01/04050000.xhp') diff --git a/helpcontent2/source/text/schart/01/04050000.xhp b/helpcontent2/source/text/schart/01/04050000.xhp new file mode 100644 index 000000000..591be0c84 --- /dev/null +++ b/helpcontent2/source/text/schart/01/04050000.xhp @@ -0,0 +1,125 @@ + + + + + + + + +X/Y Error Bars +/text/schart/01/04050000.xhp + + + + + + + + +X/Y Error Barsi85330 +Use the X or Y Error Bars dialog to display error bars for 2D charts. + + +
+ +
+An error bar is an indicator line that spans over a range from x/y - NegativeErrorValue to x/y + PositiveErrorValue. In this term, x or y is the value of the data point. When "standard deviation" is selected, x or 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 - X/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). Unlike other functions, error bars are centered on the mean. +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 X or Y-Error-Bars and Negative X or 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 "Positive (+)" 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. +
+ +
+ + -- cgit v1.2.3