X/Y Error Bars
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.
>錯誤分類
在 [錯誤種類] 區域中,可選擇顯示錯誤種類的不同方式。
無
Does not show any error bars.
常量
Displays constant values that you specify in the Parameters area.
百分比
Displays a percentage. The display refers to the corresponding data point. Set the percentage in the Parameters area.
函式
選取函式以計算誤差線。
標準誤差:顯示標準誤差。
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.
儲存格範圍
按一下 [儲存格範圍],然後指定要從中擷取正誤差線值與負誤差線值的儲存格範圍。
來自資料表格
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.
兩者的值相同
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.
正數與負數
顯示正誤差線與負誤差線。
正數
僅顯示正誤差線。
負數
僅顯示負誤差線。