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.