AddChartAutoFormat Method

Applies To

Application object.

Description

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

Syntax

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.

See Also

DeleteChartAutoFormat method, SetDefaultChart method.

Example

This example adds a new autoformat based on Chart1.

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