| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Chart.Paste method (Excel) |
vbaxl10.chm149129 |
|
|
e34d3d30-39f8-dbd4-1a39-d3ef9f84e0f4 |
04/16/2019 |
medium |
Pastes chart data from the Clipboard into the specified chart.
expression.Paste (Type)
expression A variable that represents a Chart object.
| 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. |
This example pastes data from the range B1:B5 on Sheet1 into Chart1.
Worksheets("Sheet1").Range("B1:B5").Copy
Charts("Chart1").Paste[!includeSupport and feedback]