应用于 Series 对象的 ApplyCustomType 方法。
将标准图表类型或自定义图表类型应用于数据系列。
expression.ApplyCustomType(ChartType)
expression 必需。该表达式返回上面的对象之一。
ChartType XlChartType 类型,必需。标准图表类型。
| XlChartType 可为以下 XlChartType 常量之一。 |
| xl3DAreaStacked |
| xlConeCol |
| xlConeColStacked |
| xlCylinderBarClustered |
| xlCylinderBarStacked100 |
| xlCylinderColClustered |
| xlCylinderColStacked100 |
| xlDoughnutExploded |
| xlLineMarkers |
| xlLIneMarkersStacked100 |
| xlLineStacked100 |
| xlPieExploded |
| xlPyramidBarClustered |
| xlPyramidBarStacked100 |
| xlPyramidColClustered |
| xlPyramidColStacked100 |
| xlRadarFilled |
| xlStockHLC |
| xlStockVHLC |
| xlSurface |
| xlSurfaceTopViewWireframe |
| xlXYScatter |
| xlXYScatterLinesNoMarkers |
| xlXYScatterSmoothNoMarkers |
| xl3DArea |
| 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 |
| xlConeColClustered |
| xlConeColStacked100 |
| xlCylinderBarStacked |
| xlCylinderCol |
| xlCylinderColStacked |
| xlDoughnut |
| xlLine |
| xlLineMarkersStacked |
| xlLineStacked |
| xlPie |
| xlPieOfPie |
| xlPyramidBarStacked |
| xlPyramidCol |
| xlPyramidColStacked |
| xlRadar |
| xlRadarMarkers |
| xlStockOHLC |
| xlStockVOHLC |
| xlSurfaceTopView |
| xlSurfaceWireframe |
| xlXYScatterLines |
| xlXYScatterSmooth |
应用于 Chart 对象的 ApplyCustomType 方法。
将标准图表类型或自定义图表类型应用于图表。
expression.ApplyCustomType(ChartType, TypeName)
expression 必需。该表达式返回上面的对象之一。
ChartType XlChartType 类型,必需。指定标准图表类型。
| XlChartType 可为以下 XlChartType 常量之一。 |
| xl3DAreaStacked |
| xlConeCol |
| xlConeColStacked |
| xlCylinderBarClustered |
| xlCylinderBarStacked100 |
| xlCylinderColClustered |
| xlCylinderColStacked100 |
| xlDoughnutExploded |
| xlLineMarkers |
| xlLIneMarkersStacked100 |
| xlLineStacked100 |
| xlPieExploded |
| xlPyramidBarClustered |
| xlPyramidBarStacked100 |
| xlPyramidColClustered |
| xlPyramidColStacked100 |
| xlRadarFilled |
| xlStockHLC |
| xlStockVHLC |
| xlSurface |
| xlSurfaceTopViewWireframe |
| xlXYScatter |
| xlXYScatterLinesNoMarkers |
| xlXYScatterSmoothNoMarkers |
| xl3DArea |
| 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 |
| xlConeColClustered |
| xlConeColStacked100 |
| xlCylinderBarStacked |
| xlCylinderCol |
| xlCylinderColStacked |
| xlDoughnut |
| xlLine |
| xlLineMarkersStacked |
| xlLineStacked |
| xlPie |
| xlPieOfPie |
| xlPyramidBarStacked |
| xlPyramidCol |
| xlPyramidColStacked |
| xlRadar |
| xlRadarMarkers |
| xlStockOHLC |
| xlStockVOHLC |
| xlSurfaceTopView |
| xlSurfaceWireframe |
| xlXYScatterLines |
| xlXYScatterSmooth |
TypeName Variant 类型,可选。该参数为用 ChartType 指定自定义图库时,命名自定义图表类型的 String 变量。
本示例应用数据点折线图图表类型。
myChart.ApplyCustomType xlLineMarkers