ChartObjects.Duplicate Method

Syntax

expression.Duplicate

expression A variable that represents a ChartObjects object.

Return Value
Object

Example

This example duplicates embedded chart one on Sheet1 and then selects the copy.

Visual Basic for Applications
`Set dChart = Worksheets("Sheet1").ChartObjects(1).Duplicate dChart.Select`

Duplicates the object and returns a reference to the new copy.