Class ErrorBars (Excel VBA)

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

Item

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

Dim ebs as ErrorBars
Set ebs = ActiveChart.FullSeriesCollection(1).ErrorBars

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

Border

Returns a Border object that represents the border of the object.

Dim brdBorder As Border
Set brdBorder = ActiveChart.FullSeriesCollection(1).ErrorBars.Border

ClearFormats

Clears the formatting of the object.

ActiveChart.FullSeriesCollection(1).ErrorBars.ClearFormats

Delete

Deletes the object.

ActiveChart.FullSeriesCollection(1).ErrorBars.Delete

EndStyle

Returns or sets the end style for the error bars. Can be one of the following XlEndStyleCap constants: xlCap or xlNoCap.

xlCap - Caps applied, xlNoCap - No caps applied.
ActiveChart.FullSeriesCollection(1).ErrorBars.EndStyle = xlCap

Format

Returns the ChartFormat object.

Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveChart.FullSeriesCollection(1).ErrorBars.Format

GetProperty

GetProperty (ID)

Name

Returns a String value that represents the name of the object.

Dim strName As String
strName = ActiveChart.FullSeriesCollection(1).ErrorBars.Name

Select

Selects the object.

ActiveChart.FullSeriesCollection(1).ErrorBars.Select

SetProperty

SetProperty (ID, Value)

Dim strID As String: strID = 
ActiveChart.FullSeriesCollection(1).ErrorBars.SetProperty ID:=strID, Value:=

Arguments

The following arguments are required:

ID - String

Value