ChartType

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

Enumeration Members

Section titled "Enumeration Members"

Area

Section titled "Area"

Area

 
Area = 1

Area3D

Section titled "Area3D"

3D Area.

 
Area3D = -4098

Area3DStacked

Section titled "Area3DStacked"

3D Stacked Area.

 
Area3DStacked = 78

Area3DStacked100

Section titled "Area3DStacked100"

100% Stacked Area.

 
Area3DStacked100 = 79

AreaStacked

Section titled "AreaStacked"

Stacked Area.

 
AreaStacked = 76

AreaStacked100

Section titled "AreaStacked100"

100% Stacked Area.

 
AreaStacked100 = 77

Bar3DClustered

Section titled "Bar3DClustered"

3D Clustered Bar.

 
Bar3DClustered = 60

Bar3DStacked

Section titled "Bar3DStacked"

3D Stacked Bar.

 
Bar3DStacked = 61

Bar3DStacked100

Section titled "Bar3DStacked100"

3D 100% Stacked Bar.

 
Bar3DStacked100 = 62

BarClustered

Section titled "BarClustered"

Clustered Bar.

 
BarClustered = 57

BarOfPie

Section titled "BarOfPie"

Bar of Pie.

 
BarOfPie = 71

BarStacked

Section titled "BarStacked"

Stacked Bar.

 
BarStacked = 58

BarStacked100

Section titled "BarStacked100"

100% Stacked Bar.

 
BarStacked100 = 59

BoxAndWhisker

Section titled "BoxAndWhisker"

Box and whisker (Office2016 or later)

 
BoxAndWhisker = 114

Bubble

Section titled "Bubble"

Bubble.

 
Bubble = 15

Bubble3DEffect

Section titled "Bubble3DEffect"

Bubble with 3D effects.

 
Bubble3DEffect = 87

Column3D

Section titled "Column3D"

3D Column.

 
Column3D = -4100

Column3DClustered

Section titled "Column3DClustered"

3D Clustered Column.

 
Column3DClustered = 54

Column3DStacked

Section titled "Column3DStacked"

3D Stacked Column.

 
Column3DStacked = 55

Column3DStacked100

Section titled "Column3DStacked100"

3D 100% Stacked Column.

 
Column3DStacked100 = 56

ColumnClustered

Section titled "ColumnClustered"

Clustered Column.

 
ColumnClustered = 51

ColumnStacked

Section titled "ColumnStacked"

Stacked Column.

 
ColumnStacked = 52

ColumnStacked100

Section titled "ColumnStacked100"

100% Stacked Column.

 
ColumnStacked100 = 53

Combo

Section titled "Combo"

Combination of different chart types.

 
Combo = 113

ConeBarClustered

Section titled "ConeBarClustered"

Clustered Cone Bar.

 
ConeBarClustered = 102

ConeBarStacked

Section titled "ConeBarStacked"

Stacked Cone Bar.

 
ConeBarStacked = 103

ConeBarStacked100

Section titled "ConeBarStacked100"

100% Stacked Cone Bar.

 
ConeBarStacked100 = 104

ConeCol

Section titled "ConeCol"

3D Cone Column.

 
ConeCol = 105

ConeColClustered

Section titled "ConeColClustered"

Clustered Cone Column.

 
ConeColClustered = 99

ConeColStacked

Section titled "ConeColStacked"

Stacked Cone Column.

 
ConeColStacked = 100

ConeColStacked100

Section titled "ConeColStacked100"

100% Stacked Cone Column.

 
ConeColStacked100 = 101

CylinderBarClustered

Section titled "CylinderBarClustered"

Clustered Cylinder Bar.

 
CylinderBarClustered = 95

CylinderBarStacked

Section titled "CylinderBarStacked"

Stacked Cylinder Bar.

 
CylinderBarStacked = 96

CylinderBarStacked100

Section titled "CylinderBarStacked100"

100% Stacked Cylinder Bar.

 
CylinderBarStacked100 = 97

CylinderCol

Section titled "CylinderCol"

3D Cylinder Column.

 
CylinderCol = 98

CylinderColClustered

Section titled "CylinderColClustered"

Clustered Cone Column.

 
CylinderColClustered = 92

CylinderColStacked

Section titled "CylinderColStacked"

Stacked Cone Column.

 
CylinderColStacked = 93

CylinderColStacked100

Section titled "CylinderColStacked100"

100% Stacked Cylinder Column.

 
CylinderColStacked100 = 94

Doughnut

Section titled "Doughnut"

Doughnut.

 
Doughnut = -4120

DoughnutExploded

Section titled "DoughnutExploded"

Exploded Doughnut.

 
DoughnutExploded = 80

Funnel

Section titled "Funnel"

Funnel (Office365 only)

 
Funnel = 115

Histogram

Section titled "Histogram"

Histogram chart (Office2016 or later)

 
Histogram = 117

Line

Section titled "Line"

Line.

 
Line = 4

Line3D

Section titled "Line3D"

3D Line.

 
Line3D = -4101

LineMarkers

Section titled "LineMarkers"

Line with Markers.

 
LineMarkers = 65

LineMarkersStacked

Section titled "LineMarkersStacked"

Stacked Line with Markers.

 
LineMarkersStacked = 66

LineMarkersStacked100

Section titled "LineMarkersStacked100"

100% Stacked Line with Markers.

 
LineMarkersStacked100 = 67

LineStacked

Section titled "LineStacked"

Stacked Line.

 
LineStacked = 63

LineStacked100

Section titled "LineStacked100"

100% Stacked Line.

 
LineStacked100 = 64

Pareto

Section titled "Pareto"

Pareto chart with bars and lines (Office2016 or later)

 
Pareto = 116

Pie

Section titled "Pie"

Pie.

 
Pie = 5

Pie3D

Section titled "Pie3D"

3D Pie.

 
Pie3D = -4102

Pie3DExploded

Section titled "Pie3DExploded"

Exploded 3D Pie.

 
Pie3DExploded = 70

PieExploded

Section titled "PieExploded"

Exploded Pie.

 
PieExploded = 69

PieOfPie

Section titled "PieOfPie"

Pie of Pie.

 
PieOfPie = 68

PyramidBarClustered

Section titled "PyramidBarClustered"

Clustered Pyramid Bar.

 
PyramidBarClustered = 109

PyramidBarStacked

Section titled "PyramidBarStacked"

Stacked Pyramid Bar.

 
PyramidBarStacked = 110

PyramidBarStacked100

Section titled "PyramidBarStacked100"

100% Stacked Pyramid Bar.

 
PyramidBarStacked100 = 111

PyramidCol

Section titled "PyramidCol"

3D Pyramid Column.

 
PyramidCol = 112

PyramidColClustered

Section titled "PyramidColClustered"

Clustered Pyramid Column.

 
PyramidColClustered = 106

PyramidColStacked

Section titled "PyramidColStacked"

Stacked Pyramid Column.

 
PyramidColStacked = 107

PyramidColStacked100

Section titled "PyramidColStacked100"

100% Stacked Pyramid Column.

 
PyramidColStacked100 = 108

Radar

Section titled "Radar"

Radar.

 
Radar = -4151

RadarFilled

Section titled "RadarFilled"

Filled Radar.

 
RadarFilled = 82

RadarMarkers

Section titled "RadarMarkers"

Radar with Data Markers.

 
RadarMarkers = 81

RegionMap

Section titled "RegionMap"

Region map (geographic) chart (Office365 only)

 
RegionMap = 121

StockHLC

Section titled "StockHLC"

High-Low-Close.

 
StockHLC = 88

StockOHLC

Section titled "StockOHLC"

Open-High-Low-Close.

 
StockOHLC = 89

StockVHLC

Section titled "StockVHLC"

Volume-High-Low-Close.

 
StockVHLC = 90

StockVOHLC

Section titled "StockVOHLC"

Volume-Open-High-Low-Close.

 
StockVOHLC = 91

Sunburst

Section titled "Sunburst"

Sunburst chart (Office2016 or later)

 
Sunburst = 118

Surface

Section titled "Surface"

Surface (a.k.a. Contour).

 
Surface = 83

SurfaceTopView

Section titled "SurfaceTopView"

3D Surface (Top View).

 
SurfaceTopView = 85

SurfaceTopViewWireframe

Section titled "SurfaceTopViewWireframe"

3D Surface (Top View wireframe).

 
SurfaceTopViewWireframe = 86

SurfaceWireframe

Section titled "SurfaceWireframe"

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

 
SurfaceWireframe = 84

Treemap

Section titled "Treemap"

Tree map chart (Office2016 or later)

 
Treemap = 119

Unknown

Section titled "Unknown"

Not an actual value; used for variable initialization.

 
Unknown = 0

Waterfall

Section titled "Waterfall"

Waterfall chart (Office2016 or later)

 
Waterfall = 120

XYScatter

Section titled "XYScatter"

Scatter.

 
XYScatter = -4169

XYScatterLines

Section titled "XYScatterLines"

Scatter with Lines.

 
XYScatterLines = 74

XYScatterLinesNoMarkers

Section titled "XYScatterLinesNoMarkers"

Scatter with Lines and No Data Markers.

 
XYScatterLinesNoMarkers = 75

XYScatterSmooth

Section titled "XYScatterSmooth"

Scatter with Smoothed Lines.

 
XYScatterSmooth = 72

XYScatterSmoothNoMarkers

Section titled "XYScatterSmoothNoMarkers"

Scatter with Smoothed Lines and No Data Markers.

 
XYScatterSmoothNoMarkers = 73