1*cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2*cdf0e10cSrcweir<helpdocument version="1.0"> 3*cdf0e10cSrcweir 4*cdf0e10cSrcweir<!-- 5*cdf0e10cSrcweir *********************************************************************** 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 12*cdf0e10cSrcweir * 13*cdf0e10cSrcweir * This file is part of OpenOffice.org. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 16*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 17*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 18*cdf0e10cSrcweir * 19*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 20*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 21*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 22*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 23*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 24*cdf0e10cSrcweir * 25*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 26*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 27*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 28*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 29*cdf0e10cSrcweir * 30*cdf0e10cSrcweir ************************************************************************ 31*cdf0e10cSrcweir --> 32*cdf0e10cSrcweir 33*cdf0e10cSrcweir 34*cdf0e10cSrcweir<meta> 35*cdf0e10cSrcweir<topic id="textschart0104050000xml" indexer="include" status="PUBLISH"> 36*cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Y Error Bars</title> 37*cdf0e10cSrcweir<filename>/text/schart/01/04050000.xhp</filename> 38*cdf0e10cSrcweir</topic> 39*cdf0e10cSrcweir</meta> 40*cdf0e10cSrcweir<body> 41*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuYErrorBars" id="bm_id877101" localize="false"/> 42*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><link href="text/schart/01/04050000.xhp" name="Y Error Bars">Y Error Bars</link></paragraph><comment>i85330</comment> 43*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149666" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="statistik"><ahelp hid=".">Use the <emph>Y Error Bars</emph> dialog to display error bars for 2D charts.</ahelp> 44*cdf0e10cSrcweir</variable></paragraph> 45*cdf0e10cSrcweir<embed href="text/schart/01/04030000.xhp#context"/> 46*cdf0e10cSrcweir<section id="howtoget"> 47*cdf0e10cSrcweir<embed href="text/schart/00/00000004.xhp#efgsta"/> 48*cdf0e10cSrcweir</section> 49*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3401287" xml-lang="en-US" l10n="NEW">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.</paragraph> 50*cdf0e10cSrcweir<paragraph role="note" id="par_id3153965" xml-lang="en-US" l10n="CHG" oldref="23">The <emph>Insert - Y Error Bars</emph> menu command is only available for 2D charts.</paragraph> 51*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3150344" xml-lang="en-US" level="2" l10n="U" oldref="5">Error category</paragraph> 52*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150202" xml-lang="en-US" l10n="CHG" oldref="6">In the <emph>Error category</emph> area, you can choose different ways to display the error category.</paragraph> 53*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_NONE --> 54*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:TP_STAT:RBT_NONE --> 55*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_NO_ERROR" id="bm_id3862117" localize="false"/> 56*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3152989" xml-lang="en-US" level="3" l10n="CHG" oldref="7">None</paragraph> 57*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149409" xml-lang="en-US" l10n="CHG" oldref="8"><ahelp hid="SCH:RADIOBUTTON:TP_STAT:RBT_NONE">Does not show any error bars.</ahelp></paragraph> 58*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_CONST --> 59*cdf0e10cSrcweir<!-- removed HID SCH:METRICFIELD:DLG_DATA_STAT:MTR_FLD_PLUS --> 60*cdf0e10cSrcweir<!-- removed HID SCH:METRICFIELD:DLG_DATA_STAT:MTR_FLD_MINUS --> 61*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:TP_STAT:RBT_CONST --> 62*cdf0e10cSrcweir<!-- removed HID SCH:METRICFIELD:TP_STAT:MTR_FLD_PLUS --> 63*cdf0e10cSrcweir<!-- removed HID SCH:METRICFIELD:TP_STAT:MTR_FLD_MINUS --> 64*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_CONSTERROR" id="bm_id3964964" localize="false"/> 65*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_PLUS_VALUE" id="bm_id5771965" localize="false"/> 66*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_MINUS_VALUE" id="bm_id1989196" localize="false"/> 67*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3145117" xml-lang="en-US" level="3" l10n="U" oldref="17">Constant value</paragraph> 68*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3151390" xml-lang="en-US" l10n="CHG" oldref="18"><ahelp hid="SCH:METRICFIELD:TP_STAT:MTR_FLD_MINUS">Displays constant values that you specify in the Parameters area.</ahelp></paragraph> 69*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_PERCENT --> 70*cdf0e10cSrcweir<!-- removed HID SCH:METRICFIELD:DLG_DATA_STAT:MTR_FLD_PERCENT --> 71*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:TP_STAT:RBT_PERCENTVALUE --> 72*cdf0e10cSrcweir<!-- removed HID SCH:METRICFIELD:TP_STAT:MTR_FLD_PERCENT --> 73*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_PERCENT" id="bm_id3336588" localize="false"/> 74*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_PERCENT_VALUE" id="bm_id1381572" localize="false"/> 75*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3159204" xml-lang="en-US" level="3" l10n="U" oldref="13">Percentage</paragraph> 76*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150048" xml-lang="en-US" l10n="CHG" oldref="14"><ahelp hid="SCH:METRICFIELD:TP_STAT:MTR_FLD_PERCENT">Displays a percentage. The display refers to the corresponding data point. Set the percentage in the Parameters area.</ahelp></paragraph> 77*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_FUNCTION" id="bm_id7856685" localize="false"/> 78*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_FUNCTION_LB" id="bm_id0428200810313556" localize="false"/> 79*cdf0e10cSrcweir<paragraph role="heading" id="hd_id8977629" xml-lang="en-US" level="3" l10n="NEW">Functions</paragraph> 80*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id7109286" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select a function to calculate the error bars.</ahelp></paragraph> 81*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id5154576" xml-lang="en-US" l10n="NEW">Standard Error: Displays the standard error.</paragraph> 82*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_VARIANT --> 83*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:TP_STAT:RBT_VARIANT --> 84*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_VARIANT" id="bm_id1840876" localize="false"/> 85*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3157979" xml-lang="en-US" l10n="CHG" oldref="10"><ahelp hid=".">Variance: Displays the variance calculated from the number of data points and respective values.</ahelp></paragraph> 86*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_SIGMA --> 87*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:TP_STAT:RBT_SIGMA --> 88*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_SIGMA" id="bm_id1873836" localize="false"/> 89*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153249" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid=".">Standard Deviation: Displays the standard deviation (square root of the variance).</ahelp></paragraph> 90*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_BIGERROR --> 91*cdf0e10cSrcweir<!-- removed HID SCH:METRICFIELD:DLG_DATA_STAT:MTR_FLD_BIGERROR --> 92*cdf0e10cSrcweir<!-- removed HID SCH:RADIOBUTTON:TP_STAT:RBT_BIGERROR --> 93*cdf0e10cSrcweir<!-- removed HID SCH:METRICFIELD:TP_STAT:MTR_FLD_BIGERROR --> 94*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_BIGERROR" id="bm_id5876949" localize="false"/> 95*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_BIGERROR_VALUE" id="bm_id9021271" localize="false"/> 96*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149870" xml-lang="en-US" l10n="CHG" oldref="16"><ahelp hid=".">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.</ahelp></paragraph> 97*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_RANGE" id="bm_id0428200810324237" localize="false"/> 98*cdf0e10cSrcweir<paragraph role="heading" id="hd_id350962" xml-lang="en-US" level="3" l10n="NEW">Cell Range</paragraph> 99*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id6679586" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Click Cell Range and then specify a cell range from which to take the positive and negative error bar values.</ahelp></paragraph> 100*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_POSITIVE_RANGE_CHOOSER" id="bm_id8996856" localize="false"/> 101*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_NEGATIVE_RANGE_CHOOSER" id="bm_id8254646" localize="false"/> 102*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3872188" xml-lang="en-US" l10n="NEW"><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> 103*cdf0e10cSrcweir<paragraph role="heading" id="hd_id2633747" xml-lang="en-US" level="3" l10n="NEW">From Data Table</paragraph> 104*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id6633503" xml-lang="en-US" l10n="NEW"><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 Y-Error-Bars and Negative Y-Error-Bars.</ahelp></paragraph><comment>Positive (+)</comment> 105*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_POSITIVE_VALUE" id="bm_id042820081035035" localize="false"/> 106*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id0428200810573839" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter the value to add to the displayed value as the positive error value.</ahelp></paragraph><comment>Negative (-)</comment> 107*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_NEGATIVE_VALUE" id="bm_id042820081036404" localize="false"/> 108*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id0428200810573862" xml-lang="en-US" l10n="NEW"><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> 109*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_POSITIVE_RANGE" id="bm_id0428200810391875" localize="false"/> 110*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id0428200810573844" xml-lang="en-US" l10n="NEW"><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> 111*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_NEGATIVE_RANGE" id="bm_id0428200810445387" localize="false"/> 112*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id0428200810573970" xml-lang="en-US" l10n="NEW"><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> 113*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_SAME_FOR_BOTH" id="bm_id0428200810464079" localize="false"/> 114*cdf0e10cSrcweir<paragraph role="heading" id="hd_id0428200810573977" xml-lang="en-US" level="3" l10n="NEW">Same value for both</paragraph> 115*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id0428200810573991" xml-lang="en-US" l10n="NEW"><ahelp hid=".">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.</ahelp></paragraph> 116*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_CT_INDICATE" id="bm_id3166467" localize="false"/> 117*cdf0e10cSrcweir<!-- removed HID HID_SCH_CT_INDICATE2 --> 118*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3156396" xml-lang="en-US" level="2" l10n="U" oldref="19">Error indicator</paragraph> 119*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150539" xml-lang="en-US" l10n="CHG" oldref="20"><ahelp hid="HID_SCH_CT_INDICATE2">Specifies the error indicator.</ahelp></paragraph> 120*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_SHOW_BOTH" id="bm_id0428200810544351" localize="false"/> 121*cdf0e10cSrcweir<paragraph role="heading" id="hd_id0428200810574027" xml-lang="en-US" level="3" l10n="NEW">Positive and Negative</paragraph> 122*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id0428200810574039" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Shows positive and negative error bars.</ahelp></paragraph> 123*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_SHOW_POSITIVE" id="bm_id0428200810550028" localize="false"/> 124*cdf0e10cSrcweir<paragraph role="heading" id="hd_id0428200810574031" xml-lang="en-US" level="3" l10n="NEW">Positive</paragraph> 125*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id042820081057411" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Shows only positive error bars.</ahelp></paragraph> 126*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_STATISTIK_SHOW_NEGATIVE" id="bm_id0428200810551739" localize="false"/> 127*cdf0e10cSrcweir<paragraph role="heading" id="hd_id0428200810574138" xml-lang="en-US" level="3" l10n="NEW">Negative</paragraph> 128*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id0522200809110667" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Shows only negative error bars.</ahelp></paragraph> 129*cdf0e10cSrcweir<section id="relatedtopics"> 130*cdf0e10cSrcweir<embed href="text/schart/01/04050100.xhp#regression"/> 131*cdf0e10cSrcweir</section> 132*cdf0e10cSrcweir</body> 133*cdf0e10cSrcweir</helpdocument> 134