SeriesCollection.Extend method (PowerPoint)

Adds new data points to an existing series collection.

Syntax

expression.Extend ( _Source_, _Rowcol_, _CategoryLabels_ )

expression A variable that represents a 'SeriesCollection' object.

Parameters

Name Required/Optional Data type Description
Source Required Variant The new data to be added to the SeriesCollection object, represented as an A1-style range reference.
Rowcol Optional Variant 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.
CategoryLabels Optional Variant 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.

Remarks

This method is not available for PivotChart reports.

Example

Note

Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.

The following example extends the series on the first chart in the active document by adding the data in cells B1:B6 from the linked workbook.

With ActiveDocument.InlineShapes(1)
    If .HasChart Then
        .Chart.SeriesCollection.Extend _
            Source:="B1:B6"
    End If
End With

See also

SeriesCollection Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.