SeriesCollection Object

Remarks

Use the SeriesCollection method to return the SeriesCollection collection.

Example

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."

Charts("chart1").SeriesCollection.Add _ source:=Worksheets("sheet1").Range("a1:a19")

Use SeriesCollection(), where is the series index number or name, to return a single Seriesobject. The following example sets the color of the interior for the first series in embedded chart one on Sheet1.

Worksheets("sheet1").ChartObjects(1).Chart. _ SeriesCollection(1).Interior.Color = RGB(255, 0, 0)

See also:

• Excel Object Model Reference
• SeriesCollection Object Members