AddChartAutoFormat Method

Microsoft Excel Visual Basic

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"