SeriesCollection.Paste method (Excel)
Pastes data from the Clipboard into the specified series collection.
Syntax
expression.Paste (RowCol, SeriesLabels, CategoryLabels, Replace, NewSeries)
expression A variable that represents a SeriesCollection object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| RowCol | Optional | XlRowCol | Specifies whether the values corresponding to a particular data series are in rows or columns. |
| SeriesLabels | Optional | Variant | True to use the contents of the cell in the first column of each row (or the first row of each column) as the name of the data series in that row (or column). False to use the contents of the cell in the first column of each row (or the first row of each column) as the first data point in the data series. The default value is False. |
| CategoryLabels | Optional | Variant | True to use the contents of the first row (or column) of the selection as the categories for the chart. False to use the contents of the first row (or column) as the first data series in the chart. The default value is False. |
| Replace | Optional | Variant | True to apply categories while replacing existing categories with information from the copied range. False to insert new categories without replacing any old ones. The default value is True. |
| NewSeries | Optional | Variant | True to paste the data as a new series. False to paste the data as new points in an existing series. The default value is True. |
Return value
Variant
Example
This example pastes data from the Clipboard into a new series on Chart1.
Worksheets("Sheet1").Range("C1:C5").Copy
Charts("Chart1").SeriesCollection.Paste
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.