ApplyCustomType method (Excel Graph)

The ApplyCustomType method as it applies to the Series and Chart objects.

Series object

Applies a standard or custom chart type to a series.

Syntax

expression.ApplyCustomType (ChartType)

expression Required. An expression that returns a Series object.

Parameters

Name Required/Optional Data type Description
ChartType Required XlChartType A standard chart type. Can be one of the XlChartType constants.

Chart object

Applies a standard or custom chart type to a chart.

Syntax

expression.ApplyCustomType (ChartType, TypeName)

expression Required. An expression that returns a Chart object.

Parameters

Name Required/Optional Data type Description
ChartType Required XlChartType A standard chart type. Can be one of the XlChartType constants.
TypeName Optional Variant A String naming the custom chart type when ChartType specifies a custom chart gallery.

Example

This example applies the line with the markers chart type.

myChart.ApplyCustomType xlLineMarkers

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.