Description
A collection of all the Series objects in the specified chart or chart group.
Accessors
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."
Charts("chart1").SeriesCollection.Add _
source:=Worksheets("sheet1").Range("a1:a19")
Use the SeriesCollection method with an argument to access a single member of the collection or without an argument to access the entire collection at once. 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")
Properties
Application Property, Count Property, Creator Property, Parent Property.
Methods
Add Method (SeriesCollection Collection), Extend Method, Item Method, Paste Method (SeriesCollection Object).