SeriesCollection.Extend(Object, Object, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Adds new data points to an existing series collection.
public object Extend (object Source, object Rowcol, object CategoryLabels);
Public Function Extend (Source As Object, Optional Rowcol As Object, Optional CategoryLabels As Object) As Object
Parameters
- Source
- Object
Required Object. The new data to be added to the SeriesCollection object, either as a Range object or an array of data points.
- Rowcol
- Object
Optional 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
- Object
Optional 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.
Returns
Remarks
This method is not available for PivotChart reports.
Applies to
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應