Series.ErrorBar Method (PowerPoint)
Applies error bars to the series.
Version Information
Version Added: PowerPoint 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
Note
Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.
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