Chart.SaveChartTemplate method (Excel)

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

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.

ActiveChart.SaveChartTemplate _ 
 Filename:="Presentation Chart" 

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.