Applies To
SeriesCollection Collection.
Description
Pastes data from the Clipboard to the specified series collection.
Syntax
object.Paste(rowcol, seriesLabels, categoryLabels, replace, newSeries)
object
Required. The SeriesCollection object.
rowcol
Optional. Specifies whether the values corresponding to a particular data series are in rows (xlRows) or columns (xlColumns). The default is xlColumns.
seriesLabels
Optional. If True, Microsoft Excel uses the contents of the cell in the first column of each row (or first row of each column) as the name of the data series in that row (or column). If False (or omitted), Microsoft Excel uses the contents of the cell in the first column of each row (or first row of each column) as the first data point of the data series.
categoryLabels
Optional. If True, Microsoft Excel uses the contents of the first row (or column) of the selection as the categories for the chart. If False (or omitted), Microsoft Excel uses the contents of the first row (or column) as the first data series in the chart.
replace
Optional. If True, Microsoft Excel applies categories while replacing existing categories with information from the copied cell range. If False, Microsoft Excel inserts new categories without replacing any old ones.
newSeries
Optional. Specifies whether the data is to be pasted as new series (True) or as new points on existing series (False). The default is True.
See Also
Add Method (SeriesCollection Collection), ChartWizard Method, Copy Method, Cut Method, Extend Method.
Example
This example copies data to the Clipboard from cells C1:C5 on Sheet1 and then pastes the data into Chart1 as a new series.
Worksheets("Sheet1").Range("C1:C5").Copy
Charts("Chart1").SeriesCollection.Paste