Excel.SeriesLines(object).md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
SeriesLines object (Excel)	vbaxl10.chm597072	vbaxl10.chm597072	Excel.SeriesLines	db044358-d14b-ef45-4e42-237b8ee46ff0	04/02/2019	medium

SeriesLines object (Excel)

Represents series lines in a chart group.

Remarks

Series lines connect the data values from each series. Only 2D stacked bar, 2D stacked column, Pie of Pie, or Bar of Pie charts can have series lines. This object isn't a collection. There's no object that represents a single series line; you either have series lines turned on for all points in a chart group or you have them turned off.

If the HasSeriesLines property of the ChartGroup object is False, most properties of the SeriesLines object are disabled.

Example

Use the SeriesLines property of the ChartGroup object to return a SeriesLines object.

The following example adds series lines to chart group one in embedded chart one on worksheet one (the chart must be a 2D stacked bar or column chart).

With Worksheets(1).ChartObjects(1).Chart.ChartGroups(1) 
 .HasSeriesLines = True 
 .SeriesLines.Border.Color = RGB(0, 0, 255) 
End With

Methods

• Delete
• Select

Properties

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

See also

• Excel Object Model Reference

[!includeSupport and feedback]