Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies error bars to the series.
Version Information
Version Added: Word 2007
Syntax
expression .ErrorBar(Direction, Include, Type, Amount, MinusValues)
expression A variable that represents a Series object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Direction |
Required |
One of the enumeration values that specifies the error bar direction. |
|
Include |
Required |
One of the enumeration values that specifies the error bar parts to include. |
|
Type |
Required |
One of the enumeration values that specifies the error bar type. |
|
Amount |
Optional |
Variant |
The error amount. Used for only the positive error amount when Type is xlErrorBarTypeCustom. |
MinusValues |
Optional |
Variant |
The negative error amount when Type is xlErrorBarTypeCustom. |
Example
The following example applies standard error bars along the y-axis for series one of the first chart in the active document. The error bars are applied in the positive and negative directions. The example should be run on a 2-D line chart.
With ActiveDocument.InlineShapes(1)
If .HasChart Then
.Chart.SeriesCollection(1).ErrorBar _
Direction:=xlY, Include:=xlErrorBarIncludeBoth, _
Type:=xlErrorBarTypeStError
End If
End With