Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

AddChartAutoFormat Method [Excel 2003 VBA Language Reference]

Office 2003

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.


This example adds a new autoformat based on Chart1.

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

Applies to | Application Object

See Also | DeleteChartAutoFormat Method | SetDefaultChart Method

© 2015 Microsoft