DownBars Object

ChartGroup
DownBars
Multiple objects

Represents the down bars in the specified chart group. Down bars connect points in the first series in the chart group with lower values in the last series (the lines go down from the first series). Only 2-D line groups that contain at least two series can have down bars. This object isn't a collection. There's no object that represents a single down bar; either you have up bars and down bars turned on for all points in a chart group or you have them turned off.

Using the DownBars Object

Use the DownBars property to return the DownBars object. The following example turns on up and down bars for chart group one in the chart. The example then sets the up-bar color to blue and the down-bar color to red.

With myChart.ChartGroups(1)
    .HasUpDownBars = True
    .UpBars.Interior.Color = RGB(0, 0, 255)
    .DownBars.Interior.Color = RGB(255, 0, 0)
End With

Remarks

If the HasUpDownBars property is False, most properties of the DownBars object are disabled.

Properties | Application Property | Border Property | Creator Property | Fill Property | Interior Property | Name Property | Parent Property

Methods | Delete Method

Parent Objects | ChartGroup Object

Child Objects | Border Object | ChartFillFormat Object | Interior Object

See Also | UpBars Object