| title | keywords | f1_keywords | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|---|
Charts.Add2 method (Excel) |
vbaxl10.chm218076 |
|
bfd7d614-a640-dfdc-ebc5-3d0682f2c839 |
04/20/2019 |
medium |
Inserts a chart directly onto the grid.
expression.Add2 (Before, After, Count, NewLayout)
expression A variable that represents a Charts object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Before | Optional | Variant | An object that specifies the sheet before which the new sheet is added. |
| After | Optional | Variant | An object that specifies the sheet after which the new sheet is added. |
| Count | Optional | Variant | The number of sheets to be added. The default value is one. |
| 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). |
CHART
[!includeSupport and feedback]