ApplyCustomType Method

Applies To

Chart object, Series object.

Description

Applies a standard or custom chart type to a chart or series.

Syntax

expression.ApplyCustomType(ChartType, TypeName)

expression An expression that returns a Chart or Series object.

ChartType Required Long. A standard chart type (see the ChartType property for the list of available constants). For Chart objects, this can also be one of the following XlChartGallery constants: xlBuiltIn, xlUserDefined, or xlAnyGallery.

TypeName Optional Variant (used only with Chart objects). A String naming the custom chart type when ChartType specifies a custom chart gallery.

Example

This example applies the "Line with Data Markers" chart type to Chart1.

Charts(1).ApplyCustomType xlLineMarkers