SeriesLines Object

Description

Represents series lines in a chart group. Series lines connect the data values from each series. Only 2-D stacked bar or column chart groups can have series lines. There is no singular SeriesLine object; you must turn series lines on or off for all points in a chart group at once.

Accessors

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

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

Remarks

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

Properties

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

Methods

Delete Method, Select Method.