应用于 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