Share via


Chart.Paste Method

Excel Developer Reference

Pastes chart data from the Clipboard into the specified chart.

Syntax

expression.Paste(Type)

expression   A variable that represents a Chart object.

Parameters

Name Required/Optional Data Type Description
Type Optional Variant Specifies the chart information to paste if a chart is on the Clipboard. Can be one of the following XlPasteType constants: xlPasteFormats, xlPasteFormulas, or xlPasteAll. The default value is xlPasteAll. If there’s data other than a chart on the Clipboard, this argument cannot be used.

Example

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

Visual Basic for Applications
  Worksheets("Sheet1").Range("B1:B5").Copy
Charts("Chart1").Paste

See Also