Chart Type Enumeration

Find below the list of Excel chart types as per XlChartType enumeration. The chart type can be determined using either the name or value. Read more about the Chart object in Excel in this other page.

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

xlAreaStacked

76

Stacked Area

xlAreaStacked100

77

100% Stacked Area

xlBarClustered

57

Clustered Bar

xlBarOfPie

71

Bar of Pie

xlBarStacked

58

Stacked Bar

xlBarStacked100

59

100% Stacked Bar

xlBubble

15

Bubble

xlBubble3DEffect

87

Bubble with 3D effects

xlColumnClustered

51

Clustered Column

xlColumnStacked

52

Stacked Column

xlColumnStacked100

53

100% Stacked Column

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

xlDoughnutExploded

80

Exploded Doughnut

xlLine

4

Line

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

xlPie

5

Pie

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

xlSurface

83

3D Surface

xlSurfaceTopView

85

Surface (Top View)

xlSurfaceTopViewWireframe

86

Surface (Top View wireframe)

xlSurfaceWireframe

84

3D Surface (wireframe)

xlXYScatter

-4169

Scatter

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




Enumerations


No comments:

Post a Comment

Popular Posts