HiLoLines Object

Description

Represents the high-low lines in a chart group. High-low lines connect the highest point with the lowest point for every category in the chart group. Only 2-D line groups can have high-low lines. There is no singular HiLoLine object; you must turn high-low lines on or off for all points in a chart group at once.

Accessors

The HiLoLines property returns the high-low lines for a chart group. The following example uses the AutoFormat method to create a high-low-close stock chart in embedded chart one (the chart must contain three series). The example then makes the high-low lines blue.


Worksheets(1).ChartObjects(1).Activate
ActiveChart.AutoFormat gallery:=xlLine, format:=8
ActiveChart.ChartGroups(1).HiLoLines.Border.Color = RGB(0, 0, 255)

Remarks

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

Properties

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

Methods

Delete Method, Select Method.