Enumeration ChartType

Constants which identify the chart's type, i.e., area chart, bar chart, pie chart, etc.

Enumeration members

Area

Area: = 1

Area

Area3D

Area3D: = -4098

3D Area.

Area3DStacked

Area3DStacked: = 78

3D Stacked Area.

Area3DStacked100

Area3DStacked100: = 79

100% Stacked Area.

AreaStacked

AreaStacked: = 76

Stacked Area.

AreaStacked100

AreaStacked100: = 77

100% Stacked Area.

Bar3DClustered

Bar3DClustered: = 60

3D Clustered Bar.

Bar3DStacked

Bar3DStacked: = 61

3D Stacked Bar.

Bar3DStacked100

Bar3DStacked100: = 62

3D 100% Stacked Bar.

BarClustered

BarClustered: = 57

Clustered Bar.

BarOfPie

BarOfPie: = 71

Bar of Pie.

BarStacked

BarStacked: = 58

Stacked Bar.

BarStacked100

BarStacked100: = 59

100% Stacked Bar.

BoxAndWhisker

BoxAndWhisker: = 114

Box and whisker (Office2016 or later)

Bubble

Bubble: = 15

Bubble.

Bubble3DEffect

Bubble3DEffect: = 87

Bubble with 3D effects.

Column3D

Column3D: = -4100

3D Column.

Column3DClustered

Column3DClustered: = 54

3D Clustered Column.

Column3DStacked

Column3DStacked: = 55

3D Stacked Column.

Column3DStacked100

Column3DStacked100: = 56

3D 100% Stacked Column.

ColumnClustered

ColumnClustered: = 51

Clustered Column.

ColumnStacked

ColumnStacked: = 52

Stacked Column.

ColumnStacked100

ColumnStacked100: = 53

100% Stacked Column.

Combo

Combo: = 113

Combination of different chart types.

ConeBarClustered

ConeBarClustered: = 102

Clustered Cone Bar.

ConeBarStacked

ConeBarStacked: = 103

Stacked Cone Bar.

ConeBarStacked100

ConeBarStacked100: = 104

100% Stacked Cone Bar.

ConeCol

ConeCol: = 105

3D Cone Column.

ConeColClustered

ConeColClustered: = 99

Clustered Cone Column.

ConeColStacked

ConeColStacked: = 100

Stacked Cone Column.

ConeColStacked100

ConeColStacked100: = 101

100% Stacked Cone Column.

CylinderBarClustered

CylinderBarClustered: = 95

Clustered Cylinder Bar.

CylinderBarStacked

CylinderBarStacked: = 96

Stacked Cylinder Bar.

CylinderBarStacked100

CylinderBarStacked100: = 97

100% Stacked Cylinder Bar.

CylinderCol

CylinderCol: = 98

3D Cylinder Column.

CylinderColClustered

CylinderColClustered: = 92

Clustered Cone Column.

CylinderColStacked

CylinderColStacked: = 93

Stacked Cone Column.

CylinderColStacked100

CylinderColStacked100: = 94

100% Stacked Cylinder Column.

Doughnut

Doughnut: = -4120

Doughnut.

DoughnutExploded

DoughnutExploded: = 80

Exploded Doughnut.

Funnel

Funnel: = 115

Funnel (Office365 only)

Histogram

Histogram: = 117

Histogram chart (Office2016 or later)

Line

Line: = 4

Line.

Line3D

Line3D: = -4101

3D Line.

LineMarkers

LineMarkers: = 65

Line with Markers.

LineMarkersStacked

LineMarkersStacked: = 66

Stacked Line with Markers.

LineMarkersStacked100

LineMarkersStacked100: = 67

100% Stacked Line with Markers.

LineStacked

LineStacked: = 63

Stacked Line.

LineStacked100

LineStacked100: = 64

100% Stacked Line.

Pareto

Pareto: = 116

Pareto chart with bars and lines (Office2016 or later)

Pie

Pie: = 5

Pie.

Pie3D

Pie3D: = -4102

3D Pie.

Pie3DExploded

Pie3DExploded: = 70

Exploded 3D Pie.

PieExploded

PieExploded: = 69

Exploded Pie.

PieOfPie

PieOfPie: = 68

Pie of Pie.

PyramidBarClustered

PyramidBarClustered: = 109

Clustered Pyramid Bar.

PyramidBarStacked

PyramidBarStacked: = 110

Stacked Pyramid Bar.

PyramidBarStacked100

PyramidBarStacked100: = 111

100% Stacked Pyramid Bar.

PyramidCol

PyramidCol: = 112

3D Pyramid Column.

PyramidColClustered

PyramidColClustered: = 106

Clustered Pyramid Column.

PyramidColStacked

PyramidColStacked: = 107

Stacked Pyramid Column.

PyramidColStacked100

PyramidColStacked100: = 108

100% Stacked Pyramid Column.

Radar

Radar: = -4151

Radar.

RadarFilled

RadarFilled: = 82

Filled Radar.

RadarMarkers

RadarMarkers: = 81

Radar with Data Markers.

RegionMap

RegionMap: = 121

Region map (geographic) chart (Office365 only)

StockHLC

StockHLC: = 88

High-Low-Close.

StockOHLC

StockOHLC: = 89

Open-High-Low-Close.

StockVHLC

StockVHLC: = 90

Volume-High-Low-Close.

StockVOHLC

StockVOHLC: = 91

Volume-Open-High-Low-Close.

Sunburst

Sunburst: = 118

Sunburst chart (Office2016 or later)

Surface

Surface: = 83

Surface (a.k.a. Contour).

SurfaceTopView

SurfaceTopView: = 85

3D Surface (Top View).

SurfaceTopViewWireframe

SurfaceTopViewWireframe: = 86

3D Surface (Top View wireframe).

SurfaceWireframe

SurfaceWireframe: = 84

Surface (a.k.a. Contour - wireframe).

Treemap

Treemap: = 119

Tree map chart (Office2016 or later)

Unknown

Unknown: = 0

Not an actual value; used for variable initialization.

Waterfall

Waterfall: = 120

Waterfall chart (Office2016 or later)

XYScatter

XYScatter: = -4169

Scatter.

XYScatterLines

XYScatterLines: = 74

Scatter with Lines.

XYScatterLinesNoMarkers

XYScatterLinesNoMarkers: = 75

Scatter with Lines and No Data Markers.

XYScatterSmooth

XYScatterSmooth: = 72

Scatter with Smoothed Lines.

XYScatterSmoothNoMarkers

XYScatterSmoothNoMarkers: = 73

Scatter with Smoothed Lines and No Data Markers.