Table of contents
TOC
Collapse the table of content
Expand the table of content

Series.ErrorBar Method (PowerPoint)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Applies error bars to the series.

Syntax

expression. ErrorBar( Direction, Include, Type, Amount, MinusValues )

expression A variable that represents a Series object.

Parameters

NameRequired/OptionalData TypeDescription
DirectionRequiredXlErrorBarDirectionOne of the enumeration values that specifies the error bar direction.
IncludeRequiredXlErrorBarIncludeOne of the enumeration values that specifies the error bar parts to include.
TypeRequiredXlErrorBarTypeOne of the enumeration values that specifies the error bar type.
AmountOptionalVariantThe error amount. Used for only the positive error amount when Type is xlErrorBarTypeCustom.
MinusValuesOptionalVariantThe 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

See also

Concepts

Series Object

© 2018 Microsoft