Edit

Shapes.AddChart2 method (Excel)

  • Article

Adds a chart to the document. Returns a Shape object that represents a chart and adds it to the specified collection.

Syntax

expression.AddChart2 (Style, XlChartType, Left, Top, Width, Height, NewLayout)

expression A variable that represents a Shapes object.

Parameters

Name Required/Optional Data type Description
Style Optional Variant The chart style. Use "-1" to get the default style for the chart type specified in XlChartType.
XlChartType Optional Variant The type of chart.
Left Optional Variant The position, in points, of the left edge of the chart, relative to the anchor.
Top Optional Variant The position, in points, of the top edge of the chart, relative to the anchor.
Width Optional Variant The width, in points, of the chart.
Height Optional Variant The height, in points, of the chart.
NewLayout Optional Variant If NewLayout is True, the chart is inserted by using the new dynamic formatting rules (Title is on, and Legend is on only if there are multiple series).

Return value

Shape

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.