ApplyCustomType Method [Excel 2003 VBA Language Reference]
ApplyCustomType method as it applies to the Series object.
Applies a standard or custom chart type to a series.
expression.ApplyCustomType(ChartType)
expression Required. An expression that returns one of the above objects.
XlChartType
| XlChartType can be one of these XlChartType constants. |
| xlLine |
| xlLineMarkersStacked |
| xlLineStacked |
| xlPie |
| xlPieOfPie |
| xlPyramidBarStacked |
| xlPyramidCol |
| xlPyramidColClustered |
| xlPyramidColStacked |
| xlPyramidColStacked100 |
| xlRadar |
| xlRadarFilled |
| xlRadarMarkers |
| xlStockHLC |
| xlStockOHLC |
| xlStockVHLC |
| xlStockVOHLC |
| xlSurface |
| xlSurfaceTopView |
| xlSurfaceTopViewWireframe |
| xlSurfaceWireframe |
| xlXYScatter |
| xlXYScatterLines |
| xlXYScatterLinesNoMarkers |
| xlXYScatterSmooth |
| xlXYScatterSmoothNoMarkers |
| xl3DArea |
| xl3DAreaStacked |
| xl3DAreaStacked100 |
| xl3DBarClustered |
| xl3DBarStacked |
| xl3DBarStacked100 |
| xl3DColumn |
| xl3DColumnClustered |
| xl3DColumnStacked |
| xl3DColumnStacked100 |
| xl3DLine |
| xl3DPie |
| xl3DPieExploded |
| xlArea |
| xlAreaStacked |
| xlAreaStacked100 |
| xlBarClustered |
| xlBarOfPie |
| xlBarStacked |
| xlBarStacked100 |
| xlBubble |
| xlBubble3DEffect |
| xlColumnClustered |
| xlColumnStacked |
| xlColumnStacked100 |
| xlConeBarClustered |
| xlConeBarStacked |
| xlConeBarStacked100 |
| xlConeCol |
| xlConeColClustered |
| xlConeColStacked |
| xlConeColStacked100 |
| xlCylinderBarClustered |
| xlCylinderBarStacked |
| xlCylinderBarStacked100 |
| xlCylinderCol |
| xlCylinderColClustered |
| xlCylinderColStacked |
| xlCylinderColStacked100 |
| xlDoughnut |
| xlDoughnutExploded |
| xlLineMarkers |
| xlLineMarkersStacked100 |
| xlLineStacked100 |
| xlPieExploded |
| xlPyramidBarClustered |
| xlPyramidBarStacked100 |
ApplyCustomType method as it applies to the Chart object.
Applies a standard or custom chart type to a chart.
expression.ApplyCustomType(ChartType, TypeName)
expression Required. An expression that returns one of the above objects.
XlChartType
| XlChartType can be one of these XlChartType constants. |
| xlBuiltIn |
| xlUserDefined |
| xlLine |
| xlLineMarkersStacked |
| xlLineStacked |
| xlPie |
| xlPieOfPie |
| xlPyramidBarStacked |
| xlPyramidCol |
| xlPyramidColClustered |
| xlPyramidColStacked |
| xlPyramidColStacked100 |
| xlRadar |
| xlRadarFilled |
| xlRadarMarkers |
| xlStockHLC |
| xlStockOHLC |
| xlStockVHLC |
| xlStockVOHLC |
| xlSurface |
| xlSurfaceTopView |
| xlSurfaceTopViewWireframe |
| xlSurfaceWireframe |
| xlXYScatter |
| xlXYScatterLines |
| xlXYScatterLinesNoMarkers |
| xlXYScatterSmooth |
| xlXYScatterSmoothNoMarkers |
| xl3DArea |
| xl3DAreaStacked |
| xl3DAreaStacked100 |
| xl3DBarClustered |
| xl3DBarStacked |
| xl3DBarStacked100 |
| xl3DColumn |
| xl3DColumnClustered |
| xl3DColumnStacked |
| xl3DColumnStacked100 |
| xl3DLine |
| xl3DPie |
| xl3DPieExploded |
| xlArea |
| xlAreaStacked |
| xlAreaStacked100 |
| xlBarClustered |
| xlBarOfPie |
| xlBarStacked |
| xlBarStacked100 |
| xlBubble |
| xlBubble3DEffect |
| xlColumnClustered |
| xlColumnStacked |
| xlColumnStacked100 |
| xlConeBarClustered |
| xlConeBarStacked |
| xlConeBarStacked100 |
| xlConeCol |
| xlConeColClustered |
| xlConeColStacked |
| xlConeColStacked100 |
| xlCylinderBarClustered |
| xlCylinderBarStacked |
| xlCylinderBarStacked100 |
| xlCylinderCol |
| xlCylinderColClustered |
| xlCylinderColStacked |
| xlCylinderColStacked100 |
| xlDoughnut |
| xlDoughnutExploded |
| xlLineMarkers |
| xlLineMarkersStacked100 |
| xlLineStacked100 |
| xlPieExploded |
| xlPyramidBarClustered |
| xlPyramidBarStacked100 |
TypeName Optional Variant (used only with a Chart object). The name of the custom chart type if ChartType specifies a custom chart gallery.
Remarks
When using a user-defined custom type you must set the ChartType to xlUserDefined. For built-in custom types, set ChartType to xlBuiltIn.
Example
This example applies the "Line with Data Markers" chart type to chart one.
Charts(1).ApplyCustomType xlLineMarkers
Applies to | Chart Object | Series Object