Programming Excel with VBA and .NET

Name

seriescollection.NewSeries( )

Synopsis

Creates a new, empty series on the chart. For example, the following code creates a new line chart and adds a new series plotted from an array of values:

Sub ChartFromArray(  )
    Dim chrt As Chart, sr As Series
    ' Create a new chart.
    Set chrt = ThisWorkbook.Charts.Add
    chrt.ChartType = xlLine
    ' Create a new series.
    Set sr = chrt.SeriesCollection.NewSeries
    ' Add some values to the series.
    sr.Values = Array(1, 2, 3, 4)
End Sub