Chart.SetDefaultChart Method
| Excel Developer Reference |
Specifies the name of the chart template that Microsoft Excel uses when creating new charts.
Version Information
Version Added: Excel 2007
Syntax
expression.SetDefaultChart(Name)
expression A variable that represents a Chart object.
Parameters
| 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 to specify a built-in chart template. |
Example
This example sets the default chart template to the custom chart named "Monthly Sales."
| Visual Basic for Applications |
|---|
|
See Also