ErrorBar Method
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Applies error bars to the series. Variant.
expression.ErrorBar(Direction, Include, Type, Amount, MinusValues)
expression Required. An expression that returns one of the objects in the Applies To list.
XlErrorBarDirection
| XlErrorBarDirection can be one of these XlErrorBarDirection constants. |
| xlX |
| xlY default |
XlErrorBarInclude
| XlErrorBarInclude can be one of these XlErrorBarInclude constants. |
| xlErrorBarIncludeBoth default |
| xlErrorBarIncludeNone |
| xlErrorBarIncludeMinusValues |
| xlErrorBarIncludePlusValues |
XlErrorBarType
| XlErrorBarType can be one of these XlErrorBarType constants. |
| xlErrorBarTypeCustom |
| xlErrorBarTypePercent |
| xlErrorBarTypeStError |
| xlErrorBarTypeFixedValue |
| xlErrorBarTypeStDev |
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 in Chart1. The error bars are applied in the positive and negative directions. The example should be run on a 2-D line chart.
Charts("Chart1").SeriesCollection(1).ErrorBar _
Direction:=xlY, Include:=xlErrorBarIncludeBoth, _
Type:=xlErrorBarTypeStError