This topic has not yet been rated - Rate this topic

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

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
`ActiveChart.SetDefaultChart Name:="Monthly Sales"`