Class ErrorBars (Excel VBA)

The class ErrorBars represents the error bars in a chart series. To use a ErrorBars class variable it first needs to be instantiated, for example


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

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. Possible return values are 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