| Chart type | Description | Constant | |
| Column | Clustered Column | xlColumnClustered | |
| 3-D Clustered Column | xl3DColumnClustered | ||
| Stacked Column | xlColumnStacked | ||
| 3-D Stacked Column | xl3DColumnStacked | ||
| 100% Stacked Column | xlColumnStacked100 | ||
| 3-D 100% Stacked Column | xl3DColumnStacked100 | ||
| 3-D Column | xl3DColumn | ||
| Bar | Clustered Bar | xlBarClustered | |
| 3-D Clustered Bar | xl3DBarClustered | ||
| Stacked Bar | xlBarStacked | ||
| 3-D Stacked Bar | xl3DBarStacked | ||
| 100% Stacked Bar | xlBarStacked100 | ||
| 3-D 100% Stacked Bar | xl3DBarStacked100 | ||
| Line | Line | xlLine |
| Line with Data Markers | xlLineMarkers | |
| Stacked Line | xlLineStacked | |
| Stacked Line with Data Markers | xlLineMarkersStacked | |
| 100% Stacked Line | xlLineStacked100 | |
| 100% Stacked Line with Data Markers | xlLineMarkersStacked100 | |
| 3-D Line | xl3DLine | |
| Pie | Pie | xlPie |
| Exploded Pie | xlPieExploded | |
| 3-D Pie | xl3DPie | |
| Exploded 3-D Pie | xl3DPieExploded | |
| Pie of Pie | xlPieOfPie | |
| Bar of Pie | xlBarOfPie | |
| XY (Scatter) | Scatter | xlXYScatter |
| Scatter with Smoothed Lines | xlXYScatterSmooth | |
| Scatter with Smoothed Lines and No Data Markers | xlXYScatterSmoothNoMarkers | |
| Scatter with Lines | xlXYScatterLines | |
| Scatter with Lines and No Data Markers | xlXYScatterLinesNoMarkers | |
| Bubble | Bubble | xlBubble |
| Bubble with 3-D Effects | xlBubble3DEffect | |
| Area | Area | xlArea |
| 3-D Area | xl3DArea | |
| Stacked Area | xlAreaStacked | |
| 3-D Stacked Area | xl3DAreaStacked | |
| 100% Stacked Area | xlAreaStacked100 | |
| 3-D 100% Stacked Area | xl3DAreaStacked100 | |
| Doughnut | Doughnut | xlDoughnut |
| Exploded Doughnut | xlDoughnutExploded | |
| Radar | Radar | xlRadar |
| Radar with Data Markers | xlRadarMarkers | |
| Filled Radar | xlRadarFilled | |
| Surface | 3-D Surface | xlSurface |
| Surface (Top View) | xlSurfaceTopView | |
| 3-D Surface (wire-frame) | xlSurfaceWireframe | |
| Surface (Top View wire-frame) | xlSurfaceTopViewWireframe |
| Chart type | Description | Constant | |
| Stock Quotes | High-Low-Close | xlStockHLC | |
| Volume-High-Low-Close | xlStockVHLC | ||
| Open-High-Low-Close | xlStockOHLC | ||
| Volume-Open-High-Low-Close | xlStockVOHLC | ||
| Cylinder | Clustered Cylinder Column | xlCylinderColClustered | |
| Clustered Cylinder Bar | xlCylinderBarClustered | ||
| Stacked Cylinder Column | xlCylinderColStacked | ||
| Stacked Cylinder Bar | xlCylinderBarStacked | ||
| 100% Stacked Cylinder Column | xlCylinderColStacked100 | ||
| 100% Stacked Cylinder Bar | xlCylinderBarStacked100 | ||
| 3-D Cylinder Column | xlCylinderCol | ||
| Cone | Clustered Cone Column | xlConeColClustered | |
| Clustered Cone Bar | xlConeBarClustered | ||
| Stacked Cone Column | xlConeColStacked | ||
| Stacked Cone Bar | xlConeBarStacked | ||
| 100% Stacked Cone Column | xlConeColStacked100 | ||
| 100% Stacked Cone Bar | xlConeBarStacked100 | ||
| 3-D Cone Column | xlConeCol | ||
| Pyramid | Clustered Pyramid Column | xlPyramidColClustered | |
| Clustered Pyramid Bar | xlPyramidBarClustered | ||
| Stacked Pyramid Column | xlPyramidColStacked | ||
| Stacked Pyramid Bar | xlPyramidBarStacked | ||
| 100% Stacked Pyramid Column | xlPyramidColStacked100 | ||
| 100% Stacked Pyramid Bar | xlPyramidBarStacked100 | ||
| 3-D Pyramid Column | xlPyramidCol | ||
With myChart
If .ChartType = xlBubble Then
.ChartGroups(1).BubbleScale = 200
End If
End With