HiLoLines Object
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

HiLoLines Object

Office 2007
Represents the high-low lines in a chart group.

Remarks

High-low lines connect the highest point with the lowest point in every category in the chart group. Only 2-D line groups can have high-low lines. This object isn’t a collection. There’s no object that represents a single high-low line; you either have high-low lines turned on for all points in a chart group or you have them turned off.

If the HasHiLoLines property is False, most properties of the HiLoLines object are disabled.

Example

Use the HiLoLines property to return the HiLoLines object. The following example uses the HasHiLowLines property to add HiLowLines to embedded chart one (the chart must be a line chart) on worksheet one. The example then makes the high-low lines blue.

Visual Basic for Applications
Worksheets(1).ChartObjects(1).Activate
ActiveChart.ChartGroups(1).HasHighLowLines = True
ActiveChart.ChartGroups(1).HiLoLines.Border.Color = RGB(0, 0, 255)



Show:
© 2016 Microsoft