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

ErrorBars Object (PowerPoint)

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

Represents the error bars on a chart series.


Error bars indicate the degree of uncertainty for chart data. Only series in area, bar, column, line, and scatter groups on a 2-D chart can have error bars. Only series in scatter groups can have x and y error bars. This object is not a collection. There is no object that represents a single error bar; you either enable x error bars or y error bars for all points in a series or you disable them.

The ErrorBar method changes the error bar format and type.


Note Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.

Use the ErrorBars property to return the ErrorBars object. The following example enables error bars for series one of the first chart in the active document and then sets the end style for the error bars.

With ActiveDocument.InlineShapes(1)

    If .HasChart Then

        .Chart.SeriesCollection(1).HasErrorBars = True

        .Chart.SeriesCollection(1).ErrorBars.EndStyle = xlNoCap

    End If

End With

See also


PowerPoint Object Model Reference

© 2018 Microsoft