X/Y Error Bars

Use the X or Y Error Bars dialog to display error bars for 2D charts.

āϝāĻĻāĻŋ āĻĄāĻžāϟāĻž āĻ•ā§āϰāĻŽā§‡āϰ āĻāĻ•āϟāĻŋ āĻāϞāĻŋāĻŽā§‡āĻ¨ā§āϟ āύāĻŋāĻ°ā§āĻŦāĻžāϚāĻŋāϤ āĻšā§Ÿ, āĻāχ āĻ•āĻŽāĻžāĻ¨ā§āĻĄāϟāĻŋ āĻļ⧁āϧ⧁āĻŽāĻžāĻ¤ā§āϰ āϏ⧇āχ āĻĄāĻžāϟāĻž āĻ•ā§āϰāĻŽā§‡ āĻ•āĻžāϜ āĻ•āϰāĻŦ⧇āĨ¤ āϝāĻĻāĻŋ āϕ⧋āύ āĻāϞāĻŋāĻŽā§‡āĻ¨ā§āϟ āύāĻŋāĻ°ā§āĻŦāĻžāϚāύ āĻ•āϰāĻž āύāĻž āĻĨāĻžāϕ⧇, āϤāĻžāĻšāϞ⧇ āĻ•āĻŽāĻžāĻ¨ā§āĻĄāϟāĻŋ āϏāĻ•āϞ āĻĄāĻžāϟāĻž āĻ•ā§āϰāĻŽā§‡ āĻ•āĻžāϜ āĻ•āϰ⧇ āĻĨāĻžāϕ⧇āĨ¤

āĻāχ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāĻžāĻŦāϞ⧀āϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāϤ⧇...

Choose Insert - X Error Bars, or Insert - Y Error Bars (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.

āϧāύāĻžāĻ¤ā§āĻŽāĻ• āĻāĻŦāĻ‚ āĻ‹āύāĻžāĻ¤ā§āĻŽāĻ•

āϧāύāĻžāĻ¤ā§āĻŽāĻ• āĻāĻŦāĻ‚ āĻ‹āύāĻžāĻ¤ā§āĻŽāĻ• āĻ¤ā§āϰ⧁āϟāĻŋ āĻŦāĻžāϰ āĻĒā§āϰāĻĻāĻ°ā§āĻļāύ āĻ•āϰ⧇āĨ¤

āϧāύāĻžāĻ¤ā§āĻŽāĻ•

āĻļ⧁āϧ⧁āĻŽāĻžāĻ¤ā§āϰ āϧāύāĻžāĻ¤ā§āĻŽāĻ• āĻ¤ā§āϰ⧁āϟāĻŋ āĻŦāĻžāϰ āĻĒā§āϰāĻĻāĻ°ā§āĻļāύ āĻ•āϰ⧇āĨ¤

āĻ‹āύāĻžāĻ¤ā§āĻŽāĻ•

āĻļ⧁āϧ⧁āĻŽāĻžāĻ¤ā§āϰ āĻ‹āύāĻžāĻ¤ā§āĻŽāĻ• āĻ¤ā§āϰ⧁āϟāĻŋ āĻŦāĻžāϰ āĻĒā§āϰāĻĻāĻ°ā§āĻļāύ āĻ•āϰ⧇āĨ¤

Please support us!