ChartType
Constants which identify the chart's type, i.e., area chart, bar chart, pie chart, etc.
Enumeration Members
Section titled "Enumeration Members"Area
Area = 1Area3D
Section titled "Area3D"3D Area.
Area3D = -4098Area3DStacked
Section titled "Area3DStacked"3D Stacked Area.
Area3DStacked = 78Area3DStacked100
Section titled "Area3DStacked100"100% Stacked Area.
Area3DStacked100 = 79AreaStacked
Section titled "AreaStacked"Stacked Area.
AreaStacked = 76AreaStacked100
Section titled "AreaStacked100"100% Stacked Area.
AreaStacked100 = 77Bar3DClustered
Section titled "Bar3DClustered"3D Clustered Bar.
Bar3DClustered = 60Bar3DStacked
Section titled "Bar3DStacked"3D Stacked Bar.
Bar3DStacked = 61Bar3DStacked100
Section titled "Bar3DStacked100"3D 100% Stacked Bar.
Bar3DStacked100 = 62BarClustered
Section titled "BarClustered"Clustered Bar.
BarClustered = 57BarOfPie
Section titled "BarOfPie"Bar of Pie.
BarOfPie = 71BarStacked
Section titled "BarStacked"Stacked Bar.
BarStacked = 58BarStacked100
Section titled "BarStacked100"100% Stacked Bar.
BarStacked100 = 59BoxAndWhisker
Section titled "BoxAndWhisker"Box and whisker (Office2016 or later)
BoxAndWhisker = 114Bubble
Section titled "Bubble"Bubble.
Bubble = 15Bubble3DEffect
Section titled "Bubble3DEffect"Bubble with 3D effects.
Bubble3DEffect = 87Column3D
Section titled "Column3D"3D Column.
Column3D = -4100Column3DClustered
Section titled "Column3DClustered"3D Clustered Column.
Column3DClustered = 54Column3DStacked
Section titled "Column3DStacked"3D Stacked Column.
Column3DStacked = 55Column3DStacked100
Section titled "Column3DStacked100"3D 100% Stacked Column.
Column3DStacked100 = 56ColumnClustered
Section titled "ColumnClustered"Clustered Column.
ColumnClustered = 51ColumnStacked
Section titled "ColumnStacked"Stacked Column.
ColumnStacked = 52ColumnStacked100
Section titled "ColumnStacked100"100% Stacked Column.
ColumnStacked100 = 53Combo
Section titled "Combo"Combination of different chart types.
Combo = 113ConeBarClustered
Section titled "ConeBarClustered"Clustered Cone Bar.
ConeBarClustered = 102ConeBarStacked
Section titled "ConeBarStacked"Stacked Cone Bar.
ConeBarStacked = 103ConeBarStacked100
Section titled "ConeBarStacked100"100% Stacked Cone Bar.
ConeBarStacked100 = 104ConeCol
Section titled "ConeCol"3D Cone Column.
ConeCol = 105ConeColClustered
Section titled "ConeColClustered"Clustered Cone Column.
ConeColClustered = 99ConeColStacked
Section titled "ConeColStacked"Stacked Cone Column.
ConeColStacked = 100ConeColStacked100
Section titled "ConeColStacked100"100% Stacked Cone Column.
ConeColStacked100 = 101CylinderBarClustered
Section titled "CylinderBarClustered"Clustered Cylinder Bar.
CylinderBarClustered = 95CylinderBarStacked
Section titled "CylinderBarStacked"Stacked Cylinder Bar.
CylinderBarStacked = 96CylinderBarStacked100
Section titled "CylinderBarStacked100"100% Stacked Cylinder Bar.
CylinderBarStacked100 = 97CylinderCol
Section titled "CylinderCol"3D Cylinder Column.
CylinderCol = 98CylinderColClustered
Section titled "CylinderColClustered"Clustered Cone Column.
CylinderColClustered = 92CylinderColStacked
Section titled "CylinderColStacked"Stacked Cone Column.
CylinderColStacked = 93CylinderColStacked100
Section titled "CylinderColStacked100"100% Stacked Cylinder Column.
CylinderColStacked100 = 94Doughnut
Section titled "Doughnut"Doughnut.
Doughnut = -4120DoughnutExploded
Section titled "DoughnutExploded"Exploded Doughnut.
DoughnutExploded = 80Funnel
Section titled "Funnel"Funnel (Office365 only)
Funnel = 115Histogram
Section titled "Histogram"Histogram chart (Office2016 or later)
Histogram = 117Line.
Line = 4Line3D
Section titled "Line3D"3D Line.
Line3D = -4101LineMarkers
Section titled "LineMarkers"Line with Markers.
LineMarkers = 65LineMarkersStacked
Section titled "LineMarkersStacked"Stacked Line with Markers.
LineMarkersStacked = 66LineMarkersStacked100
Section titled "LineMarkersStacked100"100% Stacked Line with Markers.
LineMarkersStacked100 = 67LineStacked
Section titled "LineStacked"Stacked Line.
LineStacked = 63LineStacked100
Section titled "LineStacked100"100% Stacked Line.
LineStacked100 = 64Pareto
Section titled "Pareto"Pareto chart with bars and lines (Office2016 or later)
Pareto = 116Pie.
Pie = 5Pie3D
Section titled "Pie3D"3D Pie.
Pie3D = -4102Pie3DExploded
Section titled "Pie3DExploded"Exploded 3D Pie.
Pie3DExploded = 70PieExploded
Section titled "PieExploded"Exploded Pie.
PieExploded = 69PieOfPie
Section titled "PieOfPie"Pie of Pie.
PieOfPie = 68PyramidBarClustered
Section titled "PyramidBarClustered"Clustered Pyramid Bar.
PyramidBarClustered = 109PyramidBarStacked
Section titled "PyramidBarStacked"Stacked Pyramid Bar.
PyramidBarStacked = 110PyramidBarStacked100
Section titled "PyramidBarStacked100"100% Stacked Pyramid Bar.
PyramidBarStacked100 = 111PyramidCol
Section titled "PyramidCol"3D Pyramid Column.
PyramidCol = 112PyramidColClustered
Section titled "PyramidColClustered"Clustered Pyramid Column.
PyramidColClustered = 106PyramidColStacked
Section titled "PyramidColStacked"Stacked Pyramid Column.
PyramidColStacked = 107PyramidColStacked100
Section titled "PyramidColStacked100"100% Stacked Pyramid Column.
PyramidColStacked100 = 108Radar
Section titled "Radar"Radar.
Radar = -4151RadarFilled
Section titled "RadarFilled"Filled Radar.
RadarFilled = 82RadarMarkers
Section titled "RadarMarkers"Radar with Data Markers.
RadarMarkers = 81RegionMap
Section titled "RegionMap"Region map (geographic) chart (Office365 only)
RegionMap = 121StockHLC
Section titled "StockHLC"High-Low-Close.
StockHLC = 88StockOHLC
Section titled "StockOHLC"Open-High-Low-Close.
StockOHLC = 89StockVHLC
Section titled "StockVHLC"Volume-High-Low-Close.
StockVHLC = 90StockVOHLC
Section titled "StockVOHLC"Volume-Open-High-Low-Close.
StockVOHLC = 91Sunburst
Section titled "Sunburst"Sunburst chart (Office2016 or later)
Sunburst = 118Surface
Section titled "Surface"Surface (a.k.a. Contour).
Surface = 83SurfaceTopView
Section titled "SurfaceTopView"3D Surface (Top View).
SurfaceTopView = 85SurfaceTopViewWireframe
Section titled "SurfaceTopViewWireframe"3D Surface (Top View wireframe).
SurfaceTopViewWireframe = 86SurfaceWireframe
Section titled "SurfaceWireframe"Surface (a.k.a. Contour - wireframe).
SurfaceWireframe = 84Treemap
Section titled "Treemap"Tree map chart (Office2016 or later)
Treemap = 119Unknown
Section titled "Unknown"Not an actual value; used for variable initialization.
Unknown = 0Waterfall
Section titled "Waterfall"Waterfall chart (Office2016 or later)
Waterfall = 120XYScatter
Section titled "XYScatter"Scatter.
XYScatter = -4169XYScatterLines
Section titled "XYScatterLines"Scatter with Lines.
XYScatterLines = 74XYScatterLinesNoMarkers
Section titled "XYScatterLinesNoMarkers"Scatter with Lines and No Data Markers.
XYScatterLinesNoMarkers = 75XYScatterSmooth
Section titled "XYScatterSmooth"Scatter with Smoothed Lines.
XYScatterSmooth = 72XYScatterSmoothNoMarkers
Section titled "XYScatterSmoothNoMarkers"Scatter with Smoothed Lines and No Data Markers.
XYScatterSmoothNoMarkers = 73