Edit

Share via

XlChartType enumeration (Excel)

  • Article

Specifies the chart type.

Name Value Description
xl3DArea -4098 3D Area.
xl3DAreaStacked 78 3D Stacked Area.
xl3DAreaStacked100 79 100% Stacked Area.
xl3DBarClustered 60 3D Clustered Bar.
xl3DBarStacked 61 3D Stacked Bar.
xl3DBarStacked100 62 3D 100% Stacked Bar.
xl3DColumn -4100 3D Column.
xl3DColumnClustered 54 3D Clustered Column.
xl3DColumnStacked 55 3D Stacked Column.
xl3DColumnStacked100 56 3D 100% Stacked Column.
xl3DLine -4101 3D Line.
xl3DPie -4102 3D Pie.
xl3DPieExploded 70 Exploded 3D Pie.
xlArea 1 Area.
xlAreaEx 135 Area Ex.
xlAreaStacked 76 Stacked Area.
xlAreaStacked100 77 100% Stacked Area.
xlAreaStacked100Ex 137 100% Stacked Area Ex.
xlAreaStackedEx 136 Stacked Area Ex.
xlBarClustered 57 Clustered Bar.
xlBarClusteredEx 132 Clustered Bar Ex.
xlBarOfPie 71 Bar of Pie.
xlBarStacked 58 Stacked Bar.
xlBarStacked100 59 100% Stacked Bar.
xlBarStacked100Ex 134 100% Stacked Bar Ex.
xlBarStackedEx 133 Stacked Bar Ex.
xlBoxwhisker 121 Box & Whisker.
xlBubble 15 Bubble.
xlBubble3DEffect 87 Bubble with 3D effects.
xlBubbleEx 139 Bubble Ex.
xlColumnClustered 51 Clustered Column.
xlColumnClusteredEx 124 Clustered Column Ex.
xlColumnStacked 52 Stacked Column.
xlColumnStacked100 53 100% Stacked Column.
xlColumnStacked100Ex 126 100% Stacked Column Ex.
xlColumnStackedEx 125 Stacked Column Ex.
xlCombo -4152 Custom Combination.
xlComboAreaStackedColumnClustered 115 Stacked Area - Clustered Column.
xlComboColumnClusteredLine 113 Clustered Column - Line.
xlComboColumnClusteredLineSecondaryAxis 114 Clustered Column - Line on Secondary Axis.
xlConeBarClustered 102 Clustered Cone Bar.
xlConeBarStacked 103 Stacked Cone Bar.
xlConeBarStacked100 104 100% Stacked Cone Bar.
xlConeCol 105 3D Cone Column.
xlConeColClustered 99 Clustered Cone Column.
xlConeColStacked 100 Stacked Cone Column.
xlConeColStacked100 101 100% Stacked Cone Column.
xlCylinderBarClustered 95 Clustered Cylinder Bar.
xlCylinderBarStacked 96 Stacked Cylinder Bar.
xlCylinderBarStacked100 97 100% Stacked Cylinder Bar.
xlCylinderCol 98 3D Cylinder Column.
xlCylinderColClustered 92 Clustered Cone Column.
xlCylinderColStacked 93 Stacked Cone Column.
xlCylinderColStacked100 94 100% Stacked Cylinder Column.
xlDoughnut -4120 Doughnut.
xlDoughnutEx 131 Doughnut Ex.
xlDoughnutExploded 80 Exploded Doughnut.
xlFunnel 123 Funnel.
xlHistogram 118 Histogram
xlLine 4 Line.
xlLineEx 127 Line Ex.
xlLineMarkers 65 Line with Markers.
xlLineMarkersStacked 66 Stacked Line with Markers.
xlLineMarkersStacked100 67 100% Stacked Line with Markers.
xlLineStacked 63 Stacked Line.
xlLineStacked100 64 100% Stacked Line.
xlLineStacked100Ex 129 100% Stacked Line Ex.
xlLineStackedEx 128 Stacked Line Ex.
xlOtherCombinations 116 Other Combinations.
xlPareto 122 Pareto.
xlPie 5 Pie.
xlPieEx 130 Pie Ex.
xlPieExploded 69 Exploded Pie.
xlPieOfPie 68 Pie of Pie.
xlPyramidBarClustered 109 Clustered Pyramid Bar.
xlPyramidBarStacked 110 Stacked Pyramid Bar.
xlPyramidBarStacked100 111 100% Stacked Pyramid Bar.
xlPyramidCol 112 3D Pyramid Column.
xlPyramidColClustered 106 Clustered Pyramid Column.
xlPyramidColStacked 107 Stacked Pyramid Column.
xlPyramidColStacked100 108 100% Stacked Pyramid Column.
xlRadar -4151 Radar.
xlRadarFilled 82 Filled Radar.
xlRadarMarkers 81 Radar with Data Markers.
xlRegionMap 140 Map chart.
xlStockHLC 88 High-Low-Close.
xlStockOHLC 89 Open-High-Low-Close.
xlStockVHLC 90 Volume-High-Low-Close.
xlStockVOHLC 91 Volume-Open-High-Low-Close.
xlSuggestedChart -2 Suggested.
xlSunburst 120 Sunburst.
xlSurface 83 3D Surface.
xlSurfaceTopView 85 Surface (Top View).
xlSurfaceTopViewWireframe 86 Surface (Top View wireframe).
xlSurfaceWireframe 84 3D Surface (wireframe).
xlTreemap 117 Treemap.
xlWaterfall 119 Waterfall.
xlXYScatter -4169 Scatter.
xlXYScatterEx 138 Scatter Ex.
xlXYScatterLines 74 Scatter with Lines.
xlXYScatterLinesNoMarkers 75 Scatter with Lines and No Data Markers.
xlXYScatterSmooth 72 Scatter with Smoothed Lines.
xlXYScatterSmoothNoMarkers 73 Scatter with Smoothed Lines and No Data Markers.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.