ChartObjects.Add Method (Excel)
Creates a new embedded chart.
Syntax
expression .Add(Left, Top, Width, Height)
expression A variable that represents a ChartObjects object.
Parameters
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.
Example
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