Class SeriesLines (Excel VBA)

The class SeriesLines represents series lines in a chart group.

Item

To use a SeriesLines class variable it first needs to be instantiated, for example

Dim sls as SeriesLines
Set sls = ActiveChart.ChartGroups(1).SeriesLines

SeriesLines class variables can be set using the ChartGroup.SeriesLines procedure.

Border

Returns a Border object that represents the border of the object.

Dim brdBorder As Border
Set brdBorder = ActiveChart.ChartGroups(1).SeriesLines.Border

Delete

Deletes the object.

ActiveChart.ChartGroups(1).SeriesLines.Delete

Format

Returns the ChartFormat object.

Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveChart.ChartGroups(1).SeriesLines.Format

GetProperty

GetProperty (ID)

Name

Returns a String value that represents the name of the object.

Dim strName As String
strName = ActiveChart.ChartGroups(1).SeriesLines.Name

Select

Selects the object.

ActiveChart.ChartGroups(1).SeriesLines.Select

SetProperty

SetProperty (ID, Value)

Dim strID As String: strID = 
ActiveChart.ChartGroups(1).SeriesLines.SetProperty ID:=strID, Value:=

Arguments

The following arguments are required:

ID - String

Value