AddChartAutoFormat Method

Microsoft Excel Visual Basic

AddChartAutoFormat Method

       

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"