Class DownBars (Excel VBA)

The class DownBars represents the down bars in a chart group. To use a DownBars class variable it first needs to be instantiated, for example


Dim dbs as DownBars
Set dbs = ActiveChart.ChartGroups(1).DownBars

Delete

Deletes the object.


ActiveChart.ChartGroups(1).DownBars.Delete

Format

Returns the ChartFormat object.


Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveChart.ChartGroups(1).DownBars.Format

GetProperty

GetProperty (ID)

Name

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


Dim strName As String
strName = ActiveChart.ChartGroups(1).DownBars.Name

Select

Selects the object.


ActiveChart.ChartGroups(1).DownBars.Select

SetProperty

SetProperty (ID, Value)


Dim strID As String: strID = 
ActiveChart.ChartGroups(1).DownBars.SetProperty ID:=strID, Value:=

Arguments

The following arguments are required:

ID - String

Value - Variant