SeriesCollection.Extend Method
Adds new data points to an existing series collection.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Extend ( _
Source As Object, _
Rowcol As Object, _
CategoryLabels As Object _
) As Object
'Usage
Dim instance As SeriesCollection
Dim Source As Object
Dim Rowcol As Object
Dim CategoryLabels As Object
Dim returnValue As Object
returnValue = instance.Extend(Source, _
Rowcol, CategoryLabels)
Object Extend(
Object Source,
Object Rowcol,
Object CategoryLabels
)
Parameters
Source
Type: System.ObjectRequired Object. The new data to be added to the SeriesCollection object, either as a Range object or an array of data points.
Rowcol
Type: System.ObjectOptional Object. Ignored if Source is an array. Specifies whether the new values are in the rows or columns of the given range source. Can be one of the following XlRowCol constants: xlRows or xlColumns. If this argument is omitted, Microsoft Excel attempts to determine where the values are by the size and orientation of the selected range or by the dimensions of the array.
CategoryLabels
Type: System.ObjectOptional Object. Ignored if Source is an array. 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, Microsoft Excel attempts to determine the location of the category label from the contents of the first row or column.
Return Value
Type: System.Object
Remarks
This method is not available for PivotChart reports.