Chart.SaveChartTemplate method (Excel)

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


expression.SaveChartTemplate (FileName)

expression A variable that represents a Chart object.


Name Required/Optional Data type Description
FileName Required String The name of the chart template.


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.


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.