public Series CreateSeries(Range range)
Public Function CreateSeries(ByVal range As Range) As Series
A Range object representing the cells that contain the source data for the new series.
The rules for creating series are described under SeriesCollection. If these rules would be violated by creating this series, then an ArgumentException will be thrown and the series will not be created. You will instead need to specify a ChartType and AxisType that are consistent with the rules for creating series.