expression.ErrorBar(Direction, Include, Type, Amount, MinusValues)
expression Required. An expression that returns one of the objects in the Applies To list.
Direction Required XlErrorBarDirection. The error bar direction.
| XlErrorBarDirection can be one of these XlErrorBarDirection constants. |
| xlX Can only be used with scatter charts. |
| xlY default. |
Include Required XlErrorBarInclude. The error bar parts to be included.
| XlErrorBarInclude can be one of these XlErrorBarInclude constants. |
| xlErrorBarIncludeBoth default. |
| xlErrorBarIncludeMinusValues |
| xlErrorBarIncludeNone |
| xlErrorBarIncludePlusValues |
Type Required XlErrorBarType. The error bar type.
| XlErrorBarType can be one of these XlErrorBarType constants. |
| xlErrorBarTypeCustom |
| xlErrorBarTypeFixedValue |
| xlErrorBarTypePercent |
| xlErrorBarTypeStDev |
| xlErrorBarTypeStError |
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
This example applies standard error bars in the Y direction for series one. The error bars are applied in the positive and negative directions. The example should be run on a 2-D line chart.
myChart.SeriesCollection(1).ErrorBar _
Direction:=xlY, Include:=xlErrorBarIncludeBoth, _
Type:=xlErrorBarTypeStError