Class FullSeriesCollection (Excel VBA)

The class FullSeriesCollection represents the full set of Series objects in a chart. To use a FullSeriesCollection class variable it first needs to be instantiated, for example

Dim fsc as FullSeriesCollection
Set fsc = ActiveChart.FullSeriesCollection()

For Each

Here is an example of processing the FullSeriesCollection items in a collection.

Dim srsFullSeriesCollection As Series
For Each srsFullSeriesCollection In ActiveChart.FullSeriesCollection()
	
Next srsFullSeriesCollection

Count

Returns a Long value that represents the number of Series objects in the FullSeriesCollection object.

Dim lngCount As Long
lngCount = ActiveChart.FullSeriesCollection.Count

Item

Returns a single object from the FullSeriesCollection object.

Item (Index)

Index: The index number for the object.

Dim srsFullSeriesCollection As Series
Set srsFullSeriesCollection = ActiveChart.FullSeriesCollection(Index:=1)