Chart.SaveChartTemplate Method (Excel)
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.
ActiveChart.SaveChartTemplate _
Filename:="Presentation Chart"