Class ErrorBars (PowerPoint VBA)

The class ErrorBars represents the error bars on a chart series. 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

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 return 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

GetProperty (Id)

Name

Returns the name of the object.

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

Select

Selects the object.

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

SetProperty

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