AddChartAutoFormat Method [Excel 2003 VBA Language Reference]

Adds a custom chart autoformat to the list of available chart autoformats.

expression**.AddChartAutoFormat(Chart**, Name, Description)

expression Required. An expression that returns an Application object.

Chart Required Chart. A chart that contains the format that will be applied when the new chart autoformat is applied.

Name Required String. The name of the autoformat.

Description Optional String. A description of the custom autoformat.

Example

This example adds a new autoformat based on Chart1.

Application.AddChartAutoFormat _
    Chart:=Charts("Chart1"), Name:="Presentation Chart"

Applies to | Application Object