Excel.HiLoLines(object).md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
HiLoLines object (Excel)	vbaxl10.chm599072	vbaxl10.chm599072	Excel.HiLoLines	3248f878-4be9-acbd-3515-70f8255b4d69	03/30/2019	medium

HiLoLines object (Excel)

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 2D 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 of the ChartGroup object is False, most properties of the HiLoLines object are disabled.

Example

Use the HiLoLines property of the ChartGroup object 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.

Worksheets(1).ChartObjects(1).Activate 
ActiveChart.ChartGroups(1).HasHiLoLines = True 
ActiveChart.ChartGroups(1).HiLoLines.Border.Color = RGB(0, 0, 255)

Methods

• Delete
• Select

Properties

• Application
• Border
• Creator
• Format
• Name
• Parent

See also

• Excel Object Model Reference

[!includeSupport and feedback]