Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SetDefaultChart Method

Chart.SetDefaultChart Method

Office 2007
Specifies the name of the chart template that Microsoft Excel uses when creating new charts.

Version Information
 Version Added:  Excel 2007



expression   A variable that represents a Chart object.


NameRequired/OptionalData TypeDescription
NameRequiredVariantSpecifies 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.


This example sets the default chart template to the custom chart named "Monthly Sales."

Visual Basic for Applications
ActiveChart.SetDefaultChart Name:="Monthly Sales"

Community Additions

© 2015 Microsoft