Series.ErrorBar (Word)
Applies error bars to the series.
ErrorBar (Direction, Include, Type, Amount, MinusValues)
With ActiveDocument.InlineShapes(1)
If .HasChart Then
.Chart.SeriesCollection(1).ErrorBar _
Direction:=xlY, Include:=xlErrorBarIncludeBoth, _
Type:=xlErrorBarTypeStError
End If
End With
Arguments
The following arguments are required:
Direction (XlErrorBarDirection) - One of the enumeration values that specifies the error bar direction.
Possible return values are xlChartX - Bars run parallel to the y-axis for x-axis values, xlChartY - Bars run parallel to the x-axis for y-axis values.
Include (XlErrorBarInclude) - One of the enumeration values that specifies the error bar parts to include.
Possible values are
| xlErrorBarIncludeBoth | Both the positive and negative error range. |
| xlErrorBarIncludeMinusValues | Only the negative error range. |
| xlErrorBarIncludeNone | No error bar range. |
| xlErrorBarIncludePlusValues | Only the positive error range. |
Type (XlErrorBarType) - One of the enumeration values that specifies the error bar type.
Possible values are
| xlErrorBarTypeCustom | The range is set by fixed values or cell values. |
| xlErrorBarTypeFixedValue | Fixed-length error bars. |
| xlErrorBarTypePercent | The percentage of the range to be covered by the error bars. |
| xlErrorBarTypeStDev | Shows the range for a specified number of standard deviations. |
| xlErrorBarTypeStError | Shows the standard error range. |
Optional arguments
The following arguments are optional
Amount (XlErrorBarType) - The error amount. Used for only the positive error amount when Type is xlErrorBarTypeCustom.
Possible values are
| xlErrorBarTypeCustom | The range is set by fixed values or cell values. |
| xlErrorBarTypeFixedValue | Fixed-length error bars. |
| xlErrorBarTypePercent | The percentage of the range to be covered by the error bars. |
| xlErrorBarTypeStDev | Shows the range for a specified number of standard deviations. |
| xlErrorBarTypeStError | Shows the standard error range. |
MinusValues (XlErrorBarType) - The negative error amount when Type is xlErrorBarTypeCustom.
Possible values are
| xlErrorBarTypeCustom | The range is set by fixed values or cell values. |
| xlErrorBarTypeFixedValue | Fixed-length error bars. |
| xlErrorBarTypePercent | The percentage of the range to be covered by the error bars. |
| xlErrorBarTypeStDev | Shows the range for a specified number of standard deviations. |
| xlErrorBarTypeStError | Shows the standard error range. |