Pastes chart data from the Clipboard into the specified chart.

expression   Required. An expression that returns a Chart object

Type  Optional Variant. Specifies the chart information to paste if a chart is on the Clipboard. Can be one of the following XlPasteType constants: xlFormats, xlFormulas, or xlAll. The default value is xlAll. If there’s data other than a chart on the Clipboard, this argument cannot be used.

Remark

This method changes the current selection.

For Floor and Walls objects, paste a picture from the Clipboard on the floor or walls of the specified chart. For Point and Series objects, pastes a picture from the Clipboard as the marker on the selected point or series. This method can be used on column, bar, line, or radar charts, and it sets the MarkerStyle property to xlMarkerStylePicture.

expression   Required. An expression that returns one of the above objects.

Pastes data from the Clipboard into the specified series collection.

expression   Required. An expression that returns a SeriesCollection object.

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.

Pastes the contents of the Clipboard onto the sheet.

expression   Required. An expression that returns a Worksheet object.

Destination  Optional Variant. A Range object that specifies where the Clipboard contents should be pasted. If this argument is omitted, the current selection is used. This argument can be specified only if the contents of the Clipboard can be pasted into a range. If this argument is specified, the Link argument cannot be used.

Link  Optional Variant. True to establish a link to the source of the pasted data. If this argument is specified, the Destination argument cannot be used. The default value is False.

Remarks

If you don’t specify the Destination argument, you must select the destination range before you use this method.

This method may modify the sheet selection, depending on the contents of the Clipboard.