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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.