Chart.SaveChartTemplate Method

  • Article
Excel Developer Reference

Saves a custom chart template to the list of available chart templates.

Version Information
 Version Added:  Excel 2007

Syntax

expression.SaveChartTemplate(Filename)

expression   A variable that represents a Chart object.

Parameters

Name Required/Optional Data Type Description
Filename Required String The name of the chart template.

Remarks

By default, this method saves the active chart to the user's chart template directory. If a UNC or URL is specified, the chart will be saved to the specified location instead.

Example

This example adds a new chart template based on the active chart.

Visual Basic for Applications 
  ActiveChart.SaveChartTemplate _
    Filename:="Presentation Chart"

See Also