ChartObject.Duplicate Method (Excel)
Duplicates the object and returns a reference to the new copy.
Syntax
expression .Duplicate
expression A variable that represents a ChartObject object.
Return Value
Object
Example
This example duplicates embedded chart one on Sheet1 and then selects the copy.
Set dChart = Worksheets("Sheet1").ChartObjects(1).Duplicate
dChart.Select