Applies To
Application Object.
Description
Specifies the name of the chart template that Microsoft Excel will use when creating new charts.
Syntax
object.SetDefaultChart(formatName)
object
Required. The Application object.
formatName
Required. Specifies the name of a custom autoformat. This name can be a custom autoformat, as a string, or the special constant xlBuiltIn to specify the built-in chart template.
Example
This example sets the default chart template to the custom autoformat named "Monthly Sales."
Application.SetDefaultChart formatName:="Monthly Sales"