Paste Method (Chart Object)

Applies To

Chart object.

Description

Pastes chart data from the Clipboard into the specified chart.

Syntax

expression.Paste(Type)

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.

Remarks

This method changes the current selection.

See Also

Copy method, Cut method, Paste method (Worksheet object).

Example

This example pastes data from the range B1:B5 on Sheet1 into Chart1.

Worksheets("Sheet1").Range("B1:B5").Copy
Charts("Chart1").Paste