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 |
|---|
|
See Also