XlChartType can be one of these XlChartType constants. |
xlLine. Line |
xlLineMarkersStacked. Stacked Line with Markers |
xlLineStacked. Stacked Line |
xlPie. Pie |
xlPieOfPie. Pie of Pie |
xlPyramidBarStacked. Stacked Pyramid Bar |
xlPyramidCol. 3D Pyramid Column |
xlPyramidColClustered. Clustered Pyramid Column |
xlPyramidColStacked. Stacked Pyramid Column |
xlPyramidColStacked100. 100% Stacked Pyramid Column |
xlRadar. Radar |
xlRadarFilled. Filled Radar |
xlRadarMarkers. Radar with Data Markers |
xlStockHLC. High-Low-Close |
xlStockOHLC. Open-High-Low-Close |
xlStockVHLC. Volume-High-Low-Close |
xlStockVOHLC. Volume-Open-High-Low-Close |
xlSurface. 3D Surface |
xlSurfaceTopView. Surface (Top View) |
xlSurfaceTopViewWireframe. Surface (Top View wireframe) |
xlSurfaceWireframe. 3D Surface (wireframe) |
xlXYScatter. Scatter |
xlXYScatterLines. Scatter with Lines. |
xlXYScatterLinesNoMarkers. Scatter with Lines and No Data Markers |
xlXYScatterSmooth. Scatter with Smoothed Lines |
xlXYScatterSmoothNoMarkers. Scatter with Smoothed Lines and No Data Markers |
xl3DArea. 3D Area |
xl3DAreaStacked. 3D Stacked Area |
xl3DAreaStacked100. 100% Stacked Area |
xl3DBarClustered. 3D Clustered Bar |
xl3DBarStacked. 3D Stacked Bar |
xl3DBarStacked100. 3D 100% Stacked Bar |
xl3DColumn. 3D Column |
xl3DColumnClustered. 3D Clustered Column |
xl3DColumnStacked. 3D Stacked Column |
xl3DColumnStacked100. 3D 100% Stacked Column |
xl3DLine. 3D Line |
xl3DPie. 3D Pie |
xl3DPieExploded. Exploded 3D Pie |
xlArea. Area |
xlAreaStacked. Stacked Area |
xlAreaStacked100. 100% Stacked Area |
xlBarClustered. Clustered Bar |
xlBarOfPie. Bar of Pie |
xlBarStacked. Stacked Bar |
xlBarStacked100. 100% Stacked Bar |
xlBubble. Bubble |
xlBubble3DEffect. Bubble with 3D effects |
xlColumnClustered. Clustered Column |
xlColumnStacked. Stacked Column |
xlColumnStacked100. 100% Stacked Column |
xlConeBarClustered. Clustered Cone Bar |
xlConeBarStacked. Stacked Cone Bar |
xlConeBarStacked100. 100% Stacked Cone Bar |
xlConeCol. 3D Cone Column |
xlConeColClustered. Clustered Cone Column |
xlConeColStacked. Stacked Cone Column |
xlConeColStacked100. 100% Stacked Cone Column |
xlCylinderBarClustered. Clustered Cylinder Bar |
xlCylinderBarStacked. Stacked Cylinder Bar |
xlCylinderBarStacked100. 100% Stacked Cylinder Bar |
xlCylinderCol. 3D Cylinder Column |
xlCylinderColClustered. Clustered Cone Column |
xlCylinderColStacked. Stacked Cone Column |
xlCylinderColStacked100. 100% Stacked Cylinder Column |
xlDoughnut. Doughnut |
xlDoughnutExploded. Exploded Doughnut |
xlLineMarkers. Line with Markers |
xlLineMarkersStacked100. 100% Stacked Line with Markers |
xlLineStacked100. 100% Stacked Line |
xlPieExploded. Exploded Pie |
xlPyramidBarClustered. Clustered Pyramid Bar |
xlPyramidBarStacked100. 100% Stacked Pyramid Bar |
expression.ChartType
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
Some chart types aren’t available for PivotChart reports.
Example
This example sets the bubble size in chart group one to 200% of the default size if the chart is a 2D bubble chart.
With Worksheets(1).ChartObjects(1).Chart
If .ChartType = xlBubble Then
.ChartGroups(1).BubbleScale = 200
End If
End With