UpBars object (Excel)

Represents the up bars in a chart group.

Remarks

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 2D line groups that contain at least two series can have up bars. This object isn't a collection. There's no object that represents a single up bar; you either have up bars turned on for all points in a chart group or you have them turned off.

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

Example

Use the UpBars property of the ChartGroup object to return the UpBars object.

The following example turns on up and down bars for chart group one in embedded chart one on Sheet5. The example then sets the up bar color to blue and sets 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

Methods

• Delete
• Select

Properties

• Application
• Creator
• Format
• Name
• Parent

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.