SeriesCollection Object (Excel)
A collection of all the Series objects in the specified chart or chart group.
The following example adds the data in cells C1:C10 on worksheet one to an existing series in the series collection in embedded chart one.
Worksheets(1).ChartObjects(1).Chart. _ SeriesCollection.Extend Worksheets(1).Range("c1:c10")
Use the Add method to create a new series and add it to the chart. The following example adds the data from cells A1:A19 as a new series on the chart sheet named "Chart1."
Use SeriesCollection(index), where index is the series index number or name, to return a single Series object. The following example sets the color of the interior for the first series in embedded chart one on Sheet1.