ChartObjects.Add method (Excel)

Creates a new embedded chart.


expression.Add (Left, Top, Width, Height)

expression A variable that represents a ChartObjects object.


Name Required/Optional Data type Description
Left Required Double The initial coordinates of the new object (in points), relative to the upper-left corner of cell A1 on a worksheet or to the upper-left corner of a chart.
Width Required Double The initial size of the new object, in points.

Return value

A ChartObject object that represents the new embedded chart.


This example creates a new embedded chart.

Set co = Sheets("Sheet1").ChartObjects.Add(50, 40, 200, 100) 
co.Chart.ChartWizard Source:=Worksheets("Sheet1").Range("A1:B2"), _ 
 Gallery:=xlColumn, Format:=6, PlotBy:=xlColumns, _ 
 CategoryLabels:=1, SeriesLabels:=0, HasLegend:=1

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.