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 Required. 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 argument can also be one of the following XlChartGallery constants: xlBuiltIn, xlUserDefined, or xlAnyGallery.

TypeName Optional Variant (used only with Chart objects). The name of the custom chart type if ChartType specifies a custom chart gallery.

Example

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

Charts(1).ApplyCustomType xlLineMarkers