Paste Method (Chart Object)

Applies To

Chart Object.

Description

Pastes chart data from the Clipboard into the specified chart.

Syntax

object.Paste(type)

object

Required. The Chart object.

type

Optional. If another chart is in the Clipboard, specifies the chart information to paste (one of xlFormats, xlFormulas, or xlAll). The default is xlAll. If there is data other than a chart in the Clipboard, this parameter cannot be used.

Remarks

This method changes the current selection.

See Also

Copy Method, Cut Method, Paste Method (DialogSheet or 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