Skip to main content

ChartObjects.Add method

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>