Excel.ChartObject.Duplicate.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ChartObject.Duplicate method (Excel)	vbaxl10.chm494080	vbaxl10.chm494080	Excel.ChartObject.Duplicate	f43de123-c113-ca5d-6cf7-71f7d08f7e88	04/20/2019	medium

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

[!includeSupport and feedback]