Excel.DownBars(object).md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
DownBars object (Excel)	vbaxl10.chm609072	vbaxl10.chm609072	Excel.DownBars	23623e02-44c7-a6b2-e3a8-fffc4f7b3164	03/29/2019	medium

DownBars object (Excel)

Represents the down bars in a chart group.

Remarks

Down bars connect points on the first series in the chart group with lower values on the last series (the lines go down from the first series). Only 2D 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; you either have up bars and down 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 DownBars object are disabled.

Example

Use the DownBars property of the ChartGroup object to return the DownBars object. 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

Methods

• Delete
• Select

Properties

• Application
• Creator
• Format
• Name
• Parent

See also

• Excel Object Model Reference

[!includeSupport and feedback]