summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/schart/01/04050000.xhp
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--helpcontent2/source/text/schart/01/04050000.xhp125
1 files changed, 125 insertions, 0 deletions
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 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+
+<meta>
+<topic id="textschart0104050000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">X/Y Error Bars</title>
+<filename>/text/schart/01/04050000.xhp</filename>
+</topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuYErrorBars" id="bm_id877101" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/@@nowidget@@" id="bm_@@nowidget@@" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/@@nowidget@@" id="bm_@@nowidget@@" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/dlg_InsertErrorBars" id="bm_id877102" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/tp_ErrorBars" id="bm_id8771021" localize="false"/>
+<paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="1"><link href="text/schart/01/04050000.xhp" name="Y Error Bars">X/Y Error Bars</link></paragraph><comment>i85330</comment>
+<paragraph role="paragraph" id="par_id3149666" xml-lang="en-US"><variable id="statistik"><ahelp hid=".">Use the <emph>X or Y Error Bars</emph> dialog to display error bars for 2D charts.</ahelp>
+</variable></paragraph>
+<embed href="text/schart/01/04030000.xhp#context"/>
+<section id="howtoget">
+<embed href="text/schart/00/00000004.xhp#efgsta"/>
+</section>
+<paragraph role="paragraph" id="par_id3401287" xml-lang="en-US">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.</paragraph>
+<paragraph role="note" id="par_id3153965" xml-lang="en-US">The <emph>Insert - X/Y Error Bars</emph> menu command is only available for 2D charts.</paragraph>
+<paragraph role="heading" id="hd_id3150344" xml-lang="en-US" level="2">Error category</paragraph>
+<paragraph role="paragraph" id="par_id3150202" xml-lang="en-US">In the <emph>Error category</emph> area, you can choose different ways to display the error category.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_NONE" id="bm_id3862117" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/RB_NONE" id="bm_id3862118" localize="false"/>
+<paragraph role="heading" id="hd_id3152989" xml-lang="en-US" level="3">None</paragraph>
+<paragraph role="paragraph" id="par_id3149409" xml-lang="en-US"><ahelp hid=".">Does not show any error bars.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_CONST" id="bm_id3964964" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/RB_CONST" id="bm_id3964966" localize="false"/>
+<paragraph role="heading" id="hd_id3145117" xml-lang="en-US" level="3">Constant value</paragraph>
+<paragraph role="paragraph" id="par_id3151390" xml-lang="en-US"><ahelp hid=".">Displays constant values that you specify in the Parameters area.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_PERCENT" id="bm_id3336588" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/RB_PERCENT" id="bm_id3336589" localize="false"/>
+<paragraph role="heading" id="hd_id3159204" xml-lang="en-US" level="3">Percentage</paragraph>
+<paragraph role="paragraph" id="par_id3150048" xml-lang="en-US"><ahelp hid=".">Displays a percentage. The display refers to the corresponding data point. Set the percentage in the Parameters area.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_FUNCTION" id="bm_id7856685" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/RB_FUNCTION" id="bm_id7856686" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/LB_FUNCTION" id="bm_id0428200810313556" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/LB_FUNCTION" id="bm_id0428200810313557" localize="false"/>
+<paragraph role="heading" id="hd_id8977629" xml-lang="en-US" level="3">Functions</paragraph>
+<paragraph role="paragraph" id="par_id7109286" xml-lang="en-US"><ahelp hid=".">Select a function to calculate the error bars.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id5154576" xml-lang="en-US">Standard Error: Displays the standard error.</paragraph>
+<paragraph role="paragraph" id="par_id3157979" xml-lang="en-US">Variance: Displays the variance calculated from the number of data points and respective values.</paragraph>
+<paragraph role="paragraph" id="par_id3153249" xml-lang="en-US">Standard Deviation: Displays the standard deviation (square root of the variance). Unlike other functions, error bars are centered on the mean.</paragraph>
+<paragraph role="paragraph" id="par_id3149870" xml-lang="en-US">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.</paragraph>
+
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_RANGE" id="bm_id3336590" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/RB_RANGE" id="bm_id3336591" localize="false"/>
+<paragraph role="heading" id="hd_id350962" xml-lang="en-US" level="3">Cell Range</paragraph>
+<paragraph role="paragraph" id="par_id6679586" xml-lang="en-US"><ahelp hid=".">Click Cell Range and then specify a cell range from which to take the positive and negative error bar values.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/IB_RANGE_POSITIVE" id="bm_id3336592" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/IB_RANGE_POSITIVE" id="bm_id3336593" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/IB_RANGE_NEGATIVE" id="bm_id3336594" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/IB_RANGE_NEGATIVE" id="bm_id3336595" localize="false"/>
+<paragraph role="paragraph" id="par_id3872188" xml-lang="en-US"><ahelp hid="." visibility="hidden">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.</ahelp></paragraph>
+
+<bookmark xml-lang="en-US" branch="hid/CHART2_SCH_ERROR_BARS_FROM_DATA" id="bm_id3336595" localize="false"/>
+<paragraph role="heading" id="hd_id2633747" xml-lang="en-US" level="3">From Data Table</paragraph>
+<paragraph role="paragraph" id="par_id6633503" xml-lang="en-US"><ahelp hid=".">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.</ahelp></paragraph>
+
+<comment>Positive (+)</comment>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/MF_POSITIVE" id="bm_id3964968" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/MF_POSITIVE" id="bm_id3964961" localize="false"/>
+<paragraph role="paragraph" id="par_id0428200810573839" xml-lang="en-US"><ahelp hid="." visibility="hidden">Enter the value to add to the displayed value as the positive error value.</ahelp></paragraph>
+
+<comment>Negative (-)</comment>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/MF_NEGATIVE" id="bm_id3964969" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/MF_NEGATIVE" id="bm_id3964963" localize="false"/>
+<paragraph role="paragraph" id="par_id0428200810573862" xml-lang="en-US"><ahelp hid="." visibility="hidden">Enter the value to subtract from the displayed value as the negative error value.</ahelp></paragraph>
+
+<comment>Positive (+) when Cell Range is selected</comment>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/ED_RANGE_POSITIVE" id="bm_id3964969" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/ED_RANGE_POSITIVE" id="bm_id3964962" localize="false"/>
+<paragraph role="paragraph" id="par_id0428200810573844" xml-lang="en-US"><ahelp hid="." visibility="hidden">Enter the address range from where to get the positive error values. Use the Shrink button to select the range from a sheet.</ahelp></paragraph>
+
+<comment>Negative (-) when Cell Range is selected</comment>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/ED_RANGE_NEGATIVE" id="bm_id3964970" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/ED_RANGE_NEGATIVE" id="bm_id3964963" localize="false"/>
+<paragraph role="paragraph" id="par_id0428200810573970" xml-lang="en-US"><ahelp hid="." visibility="hidden">Enter the address range from where to get the negative error values. Use the Shrink button to select the range from a sheet.</ahelp></paragraph>
+
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/CB_SYN_POS_NEG" id="bm_id3964971" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/CB_SYN_POS_NEG" id="bm_id3964964" localize="false"/>
+<paragraph role="heading" id="hd_id0428200810573977" xml-lang="en-US" level="3">Same value for both</paragraph>
+<paragraph role="paragraph" id="par_id0428200810573991" xml-lang="en-US"><ahelp hid=".">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.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3156396" xml-lang="en-US" level="2">Error Indicator</paragraph>
+<paragraph role="paragraph" id="par_id3150539" xml-lang="en-US">Specifies the error indicator.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/RB_BOTH" id="bm_id0428200810544351" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_BOTH" id="bm_id0428200810544352" localize="false"/>
+<paragraph role="heading" id="hd_id0428200810574027" xml-lang="en-US" level="3">Positive and Negative</paragraph>
+<paragraph role="paragraph" id="par_id0428200810574039" xml-lang="en-US"><ahelp hid=".">Shows positive and negative error bars.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/RB_POSITIVE" id="bm_id0428200810550028" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_POSITIVE" id="bm_id0428200810550029" localize="false"/>
+<paragraph role="heading" id="hd_id0428200810574031" xml-lang="en-US" level="3">Positive</paragraph>
+<paragraph role="paragraph" id="par_id042820081057411" xml-lang="en-US"><ahelp hid=".">Shows only positive error bars.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_ErrorBars/RB_NEGATIVE" id="bm_id0428200810551739" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/dlg_InsertErrorBars/RB_NEGATIVE" id="bm_id0428200810551740" localize="false"/>
+<paragraph role="heading" id="hd_id0428200810574138" xml-lang="en-US" level="3">Negative</paragraph>
+<paragraph role="paragraph" id="par_id0522200809110667" xml-lang="en-US"><ahelp hid=".">Shows only negative error bars.</ahelp></paragraph>
+<section id="relatedtopics">
+<embed href="text/schart/01/04050100.xhp#regression"/>
+</section>
+</body>
+</helpdocument>