SeriesLines Object [Excel 2003 VBA Language Reference]
ChartGroup SeriesLines Border |
Represents series lines in a chart group. Series lines connect the data values from each series. Only 2-D stacked bar, 2-D 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.
Using the SeriesLines Object
Use the SeriesLines property 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 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
Parent Objects | ChartGroup Object
Child Objects | Border Object