| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Chart.SetDefaultChart method (Excel) |
vbaxl10.chm149182 |
|
|
8be43de3-8b7d-4885-3e49-19aa0c65564f |
04/16/2019 |
medium |
Specifies the name of the chart template that Microsoft Excel uses when creating new charts.
expression.SetDefaultChart (Name)
expression A variable that represents a Chart object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Name | Required | Variant | Specifies the name of the default chart template that will be used when creating new charts. This name can be a string naming a chart in the gallery for a user-defined template, or it can be a special constant xlBuiltIn (XlChartGallery) to specify a built-in chart template. |
This example sets the default chart template to the custom chart named Monthly Sales.
ActiveChart.SetDefaultChart Name:="Monthly Sales"[!includeSupport and feedback]