Chart.ChartType procedure builder

Chart.ChartType (Excel)

Returns or sets the chart type.

Possible Values are 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, xlBoxwhisker, 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, xlFunnel, xlHistogram, xlLine - Line, xlLineMarkers - Line with Markers, xlLineMarkersStacked - Stacked Line with Markers, xlLineMarkersStacked100 - 100% Stacked Line with Markers, xlLineStacked - Stacked Line, xlLineStacked100 - 100% Stacked Line, xlPareto, xlPie - Pie, xlPieExploded - Exploded Pie, xlPieOfPie - Pie of Pie, xlPyramidBarClustered - Clustered Pyramid Bar, xlPyramidBarStacked - Stacked Pyramid Bar, xlPyramidBarStacked100 - 100% 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, xlRegionMap - Map chart, xlStockHLC - High-Low-Close, xlStockOHLC - Open-High-Low-Close, xlStockVHLC - Volume-High-Low-Close, xlStockVOHLC - Volume-Open-High-Low-Close, xlSunburst, xlSurface - 3D Surface, xlSurfaceTopView - Surface (Top View), xlSurfaceTopViewWireframe - Surface (Top View wireframe), xlSurfaceWireframe - 3D Surface (wireframe), xlTreemap, xlWaterfall, 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.

Some chart types aren't available for PivotChart reports.

ActiveChart.ChartType = xl3DArea