PowerPoint.Series.ErrorBar.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Series.ErrorBar method (PowerPoint)	vbapp10.chm65688	vbapp10.chm65688	PowerPoint.Series.ErrorBar	a25795b8-a954-0803-bea6-6c650190ad3f	06/08/2017	medium

Series.ErrorBar method (PowerPoint)

Applies error bars to the series.

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	XlErrorBarDirection	One of the enumeration values that specifies the error bar direction.
Include	Required	XlErrorBarInclude	One of the enumeration values that specifies the error bar parts to include.
Type	Required	XlErrorBarType	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 2D 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

Series Object

[!includeSupport and feedback]