Paste Method (Chart Object) Example

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

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