ChartObject.Duplicate Method

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

See Also

• ChartObject Object
• ChartObject Object Members