SeriesCollection.Extend (PowerPoint)

Adds new data points to an existing series collection.

This method is not available for PivotChart reports.

Syntax : expression.Extend (Source, Rowcol, CategoryLabels)

ActivePresentation.Slides(1).Shapes(1).Chart.ChartGroups(1).SeriesCollection.Extend Source:= "B1:B6"

Arguments

The following argument is required

Source (SeriesCollection) - The new data to be added to the SeriesCollection object, represented as an A1-style range reference.

The following arguments are optional

Rowcol (XlRowCol) - One of the XlRowCol enumeration values that specifies whether the new values are in the rows or columns of the given range source. If this argument is omitted, Microsoft Word attempts to determine where the values are by the size and orientation of the selected range or by the dimensions of the array.

Possible Values are xlColumns - The data series is in a row, xlRows - The data series is in a column.

CategoryLabels (Boolean) - True to have the first row or column contain the name of the category labels. False to have the first row or column contain the first data point of the series. If this argument is omitted, Word attempts to determine the location of the category label from the contents of the first row or column.