Shapes.AddSmartArt Method (Excel)

Creates a new SmartArt graphic with the specified layout.

Version Added: Excel 2010

expression .AddSmartArt(Layout, Left, Top, Width, Height)

expression A variable that represents a Shapes collection.

Parameters

Name

Required/Optional

Data Type

Description

Layout

Required

SmartArtLayout

An object that represents the layout to use.

Left

Optional

Variant

The distance, in points, from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart).

Top

Optional

Variant

The distance, in points, from the top edge of the object to the top edge of the worksheet.

Width

Optional

Variant

The width, in points, of the object.

Height

Optional

Variant

The width, in points, of the object.

Return Value

Shape

Concepts

Other resources

Show:
© 2014 Microsoft