应用于 Series 对象的 ApplyCustomType 方法。
将标准图表类型或自定义图表类型应用于数据系列。
expression.ApplyCustomType(ChartType)
expression 必需。该表达式返回上面的对象之一。
ChartType XlChartType 类型,必需。指定标准图表类型。
| XlChartType 可为以下 XlChartType 常量之一。 |
| 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 |
应用于 Chart 对象的 ApplyCustomType 方法。
将标准图表类型或自定义图表类型应用于图表。
expression.ApplyCustomType(ChartType, TypeName)
expression 必需。该表达式返回上面的对象之一。
Chart Type XlChartType 类型,必需。指定标准图表类型。
| XlChartType 可为以下 XlChartType 常量之一。 |
| 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 Variant 类型,可选。(仅用于 Chart 对象)。如果 ChartType 参数指定的是一个自定义图表库,则该参数为自定义图表类型的名称。
本示例将“带数据标志的折线图”图表类型应用于第一张图表。
Charts(1).ApplyCustomType xlLineMarkers