Class ErrorBars (PowerPoint VBA)

The class ErrorBars represents the error bars on a chart series.

Set

To use a ErrorBars class variable it first needs to be instantiated, for example

Dim ebs as ErrorBars
Set ebs = ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).ErrorBars

ErrorBars class variables can be set using the Series.ErrorBars procedure.

Border

Returns the border of the object.

Dim cbrBorder As ChartBorder
Set cbrBorder = ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).ErrorBars.Border

ClearFormats

Clears the formatting of the object.

ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).ErrorBars.ClearFormats

Delete

Deletes the object.

ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).ErrorBars.Delete

EndStyle

Returns or sets the end style for the error bars.

Possible Values are xlCap - Caps are applied, xlNoCap - No caps are applied.

The value of this property can be one of the following XlEndStyleCap constants:

ActivePresentation.Slides(1).Shapes(1).Chart.FullSeriesCollection(1).ErrorBars.EndStyle = xlCap

Format

Returns the line, fill, and effect formatting for the object.

Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).ErrorBars.Format

GetProperty

Syntax : expression.GetProperty (Id)

Name

Returns the name of the object.

Dim strName As String
strName = ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).ErrorBars.Name

Parent

Returns the parent for the specified object. Read-only object.

Select

Selects the object.

ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).ErrorBars.Select

SetProperty

Syntax : expression.SetProperty (Id, Value)

Dim strId As String: strId = 
ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).ErrorBars.SetProperty Id:=strId, Value:=

Arguments

The following arguments are required:

Id - String

Value