UpBars Object

Description

Represents the up bars in a chart group. Up bars connect points on series one with higher values on the last series in the chart group (the lines go up from series one). Only 2-D line groups that contain at least two series can have up bars. There is no singular UpBar object; you must turn up bars and down bars on or off for all points in a chart group at once.

Accessors

The UpBars property returns the up bars for a chart group. The following example turns on up and down bars for chart group one in embedded chart one on the worksheet named "Sheet5." The example then sets the up bar color to blue and the down bar color to red.

With Worksheets("sheet5").ChartObjects(1).Chart.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 UpBars object are disabled.

See Also

DownBars Object

Properties

Application Property, Border Property, Creator Property, Interior Property, Name Property, Parent Property.

Methods

Delete Method, Select Method.