xlChartType

Specifies the chart type.

xl3DArea3D Area chart type (-4098)
xl3DAreaStacked3D Area Stacked chart type (78)
xl3DAreaStacked1003D Area Stacked 100 chart type (79)
xl3DBarClustered3D Bar Clustered chart type (60)
xl3DBarStacked3D Bar Stacked chart type (61)
xl3DBarStacked1003D Bar Stacked 100 chart type (62)
xl3DColumn3D Column chart type (-4100)
xl3DColumnClustered3D Column Clustered chart type (54)
xl3DColumnStacked3D Column Stacked chart type (55)
xl3DColumnStacked1003D Column Stacked 100 chart type (56)
xl3DLine3D Line chart type (-4101)
xl3DPie3D Pie chart type (-4102)
xl3DPieExploded3D Pie Exploded chart type (70)
xlAreaArea chart type (1)
xlAreaStackedArea Stacked chart type (76)
xlAreaStacked100Area Stacked 100 chart type (77)
xlBarClustered57
xlBarOfPie71
xlBarStacked58
xlBarStacked10059
xlBoxWhisker(Added in 2016) (121)
xlBubble15
xlBubble3DEffect87
xlColumnClustered51
xlColumnStacked52
xlColumnStacked10053
xlConeBarClustered102
xlConeBarStacked103
xlConeBarStacked100104
xlConeCol105
xlConeColClustered99
xlConeColStacked100
xlConeColStacked100101
xlCylinderBarClustered95
xlCylinderBarStacked96
xlCylinderBarStacked10097
xlCylinderCol98
xlCylinderColClustered92
xlCylinderColStacked93
xlCylinderColStacked10094
xlDoughnut-4120
xlDoughnutExploded80
xlHistogram(Added in 2016) (118)
xlLine4
xlLineMarkers65
xlLineMarkersStacked66
xlLineMarkersStacked10067
xlLineStacked63
xlLineStacked10064
xlPareto(Added in 2016) (122)
xlPie5
xlPieExploded69
xlPieOfPie68
xlPyramidBarClustered109
xlPyramidBarStacked110
xlPyramidBarStacked100111
xlPyramidCol112
xlPyramidColClustered106
xlPyramidColStacked107
xlPyramidColStacked100108
xlRadar-4151
xlRadarFilled82
xlRadarMarkers81
xlRegionMap(Added in 2019) Map Chart (140)
xlStockHLC88
xlStockOHLC89
xlStockVHLC90
xlStockVOHLC91
xlSunburst(Added in 2016) Sunburst chart type (120)
xlSurface83
xlSurfaceTopView85
xlSurfaceTopViewWireframe86
xlSurfaceWireframe84
xlTreemap(Added in 2016) Treemap chart type (117)
xlWaterfall(Added in 2016) Waterfall chart type (119)
xlXYScatterXY Scatter chart type (-4169)
xlXYScatterLinesXY Scatter Lines chart type (74)
xlXYScatterLinesNoMarkersXY Scatter Lines with No Markers chart type (75)
xlXYScatterSmoothXY Scatter Smooth chart type (72)
xlXYScatterSmoothNoMarkersXY Scatter Smooth with No Markers chart type (73)

xl3DArea
3D Area chart type (-4098)
xl3DAreaStacked
3D Area Stacked chart type (78)
xl3DAreaStacked100
3D Area Stacked 100 chart type (79)
xl3DBarClustered
3D Bar Clustered chart type (60)
xl3DBarStacked
3D Bar Stacked chart type (61)
xl3DBarStacked100
3D Bar Stacked 100 chart type (62)
xl3DColumn
3D Column chart type (-4100)
xl3DColumnClustered
3D Column Clustered chart type (54)
xl3DColumnStacked
3D Column Stacked chart type (55)
xl3DColumnStacked100
3D Column Stacked 100 chart type (56)
xl3DLine
3D Line chart type (-4101)
xl3DPie
3D Pie chart type (-4102)
xl3DPieExploded
3D Pie Exploded chart type (70)
xlArea
Area chart type (1)
xlAreaStacked
Area Stacked chart type (76)
xlAreaStacked100
Area Stacked 100 chart type (77)
xlBarClustered
57
xlBarOfPie
71
xlBarStacked
58
xlBarStacked100
59
xlBoxWhisker
(Added in 2016) (121)
xlBubble
15
xlBubble3DEffect
87
xlColumnClustered
51
xlColumnStacked
52
xlColumnStacked100
53
xlConeBarClustered
102
xlConeBarStacked
103
xlConeBarStacked100
104
xlConeCol
105
xlConeColClustered
99
xlConeColStacked
100
xlConeColStacked100
101
xlCylinderBarClustered
95
xlCylinderBarStacked
96
xlCylinderBarStacked100
97
xlCylinderCol
98
xlCylinderColClustered
92
xlCylinderColStacked
93
xlCylinderColStacked100
94
xlDoughnut
-4120
xlDoughnutExploded
80
xlHistogram
(Added in 2016) (118)
xlLine
4
xlLineMarkers
65
xlLineMarkersStacked
66
xlLineMarkersStacked100
67
xlLineStacked
63
xlLineStacked100
64
xlPareto
(Added in 2016) (122)
xlPie
5
xlPieExploded
69
xlPieOfPie
68
xlPyramidBarClustered
109
xlPyramidBarStacked
110
xlPyramidBarStacked100
111
xlPyramidCol
112
xlPyramidColClustered
106
xlPyramidColStacked
107
xlPyramidColStacked100
108
xlRadar
-4151
xlRadarFilled
82
xlRadarMarkers
81
xlRegionMap
(Added in 2019) Map Chart (140)
xlStockHLC
88
xlStockOHLC
89
xlStockVHLC
90
xlStockVOHLC
91
xlSunburst
(Added in 2016) Sunburst chart type (120)
xlSurface
83
xlSurfaceTopView
85
xlSurfaceTopViewWireframe
86
xlSurfaceWireframe
84
xlTreemap
(Added in 2016) Treemap chart type (117)
xlWaterfall
(Added in 2016) Waterfall chart type (119)
xlXYScatter
XY Scatter chart type (-4169)
xlXYScatterLines
XY Scatter Lines chart type (74)
xlXYScatterLinesNoMarkers
XY Scatter Lines with No Markers chart type (75)
xlXYScatterSmooth
XY Scatter Smooth chart type (72)
xlXYScatterSmoothNoMarkers
XY Scatter Smooth with No Markers chart type (73)

REMARKS
* -4111 is a combination chart or unrecognised chart type.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top