Shapes.AddChart2 (Excel)

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

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

Dim shpAddChart2 As Shape
Set shpAddChart2 = ActiveChart.Shapes.AddChart2()

Arguments

Optional arguments

The following arguments are optional

Style (Style) - The chart style. Use "-1" to get the default style for the chart type specified in XlChartType.

XlChartType (XlChartType) - The type of chart.

Here you can find possible values for XlChartType

Left (Points) - The position, in points, of the left edge of the chart, relative to the anchor.

Top - The position, in points, of the top edge of the chart, relative to the anchor

Width (Long) - The width, in points, of the chart.

Height (Long) - The height, in points, of the chart.

NewLayout (Boolean) - 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).