| Chart type | Description | Constant | |
| Column | Clustered Column | xlColumnClustered | |
| 3D Clustered Column | xl3DColumnClustered | ||
| Stacked Column | xlColumnStacked | ||
| 3D Stacked Column | xl3DColumnStacked | ||
| 100% Stacked Column | xlColumnStacked100 | ||
| 3D 100% Stacked Column | xl3DColumnStacked100 | ||
| 3D Column | xl3DColumn | ||
| Bar | Clustered Bar | xlBarClustered | |
| 3D Clustered Bar | xl3DBarClustered | ||
| Stacked Bar | xlBarStacked | ||
| 3D Stacked Bar | xl3DBarStacked | ||
| 100% Stacked Bar | xlBarStacked100 | ||
| 3D 100% Stacked Bar | xl3DBarStacked100 | ||
| Line | Line | xlLine | |
| Line with Markers | xlLineMarkers | ||
| Stacked Line | xlLineStacked | ||
| Stacked Line with Markers | xlLineMarkersStacked | ||
| 100% Stacked Line | xlLineStacked100 | ||
| 100% Stacked Line with Markers | xlLIneMarkersStacked100 | ||
| 3D Line | xl3DLine | ||
| Pie | Pie | xlPie | |
| Exploded Pie | xlPieExploded | ||
| 3D Pie | xl3Dpie | ||
| Exploded 3D Pie | xl3DPieExploded | ||
| Pie of Pie | xlPieOfPie | ||
| Bar of Pie | xlBarOfPie | ||
| XY (Scatter) | Scatter | xlXYScatter | |
| Scatter with Smoothed Lines | xlXYScatterSmooth | ||
| Chart type | Description | Constant | |
| 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 3D Effects | xlBubble3DEffect | ||
| Area | Area | xlArea | |
| 3D Area | xl3DArea | ||
| Stacked Area | xlAreaStacked | ||
| 3D Stacked Area | xl3DAreaStacked | ||
| 100% Stacked Area | xlAreaStacked100 | ||
| 3D 100% Stacked Area | xl3DAreaStacked100 | ||
| Doughnut | Doughnut | xlDoughnut | |
| Exploded Doughnut | xlDoughnutExploded | ||
| Radar | Radar | xlRadar | |
| Radar with Data Markers | xlRadarMarkers | ||
| Filled Radar | xlRadarFilled | ||
| Surface | 3D Surface | xlSurface | |
| Surface (Top View) | xlSurfaceTopView | ||
| 3D Surface (Wireframe) | xlSurfaceWireframe | ||
| Surface (Top View Wireframe) | xlSurfaceTopViewWireframe | ||
| 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 | ||
| 3D 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 | |
| 3D 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 | |
| 3D Pyramid Column | xlPyramidCol |
With Worksheets(1).ChartObjects(1).Chart
If .ChartType = xlBubble Then
.ChartGroups(1).BubbleScale = 200
End If
End With