.
Description
Sets or returns the error amount. The meaning of this value is dependent on the value of ErrorBar.ValueType.
C#
vb.net
Remarks
If the ValueType is Custom, this property will return 0. Setting this property when the ValueType is custom will cause the ValueType to change to FixedValue.
If the ValueType is not Custom, then this property specifies the error in both the positive and negative direction. If the ValueType is FixedValue, then this will be an absolute amount. For example, if the Value of the ErrorBarY is set to 5.0, then a data point at a Y position of 2.0 will have an error bar extending from -3.0 to 7.0, and a data point at a Y position of 15.0 will have an error bar extending from 10.0 to 20.0.
If the ValueType is Percentage, then this value expresses the error as a percentage of a data point's value. For example, if the Value of the ErrorBarY is set to 10.0, then a data point at a Y position of 2.0 will have an error bar extending from 1.8 to 2.2 (plus and minus 10% of 2.0), while a data point at a Y position of 100.0 will have an error bar extending from 90.0 to 110.0.
If you create a new error bar using ExcelWriter, then the Value will have a default value of 2 for the 2007 Office file formats (.xlsx, .xlsm, etc), and a value of 0 for the 2003 Office file formats (.xls).