ig.excel.ChartType
Dependencies
-
area
- Type:
- ig.excel.ChartType
- Default:
- 1
Area
-
area3D
- Type:
- ig.excel.ChartType
- Default:
- -4098
3D Area.
-
area3DStacked
- Type:
- ig.excel.ChartType
- Default:
- 78
3D Stacked Area.
-
area3DStacked100
- Type:
- ig.excel.ChartType
- Default:
- 79
100% Stacked Area.
-
areaStacked
- Type:
- ig.excel.ChartType
- Default:
- 76
Stacked Area.
-
areaStacked100
- Type:
- ig.excel.ChartType
- Default:
- 77
100% Stacked Area.
-
bar3DClustered
- Type:
- ig.excel.ChartType
- Default:
- 60
3D Clustered Bar.
-
bar3DStacked
- Type:
- ig.excel.ChartType
- Default:
- 61
3D Stacked Bar.
-
bar3DStacked100
- Type:
- ig.excel.ChartType
- Default:
- 62
3D 100% Stacked Bar.
-
barClustered
- Type:
- ig.excel.ChartType
- Default:
- 57
Clustered Bar.
-
barOfPie
- Type:
- ig.excel.ChartType
- Default:
- 71
Bar of Pie.
-
barStacked
- Type:
- ig.excel.ChartType
- Default:
- 58
Stacked Bar.
-
barStacked100
- Type:
- ig.excel.ChartType
- Default:
- 59
100% Stacked Bar.
-
boxAndWhisker
- Type:
- ig.excel.ChartType
- Default:
- 114
Box and whisker (Office2016 or later)
-
bubble
- Type:
- ig.excel.ChartType
- Default:
- 15
Bubble.
-
bubble3DEffect
- Type:
- ig.excel.ChartType
- Default:
- 87
Bubble with 3D effects.
-
column3D
- Type:
- ig.excel.ChartType
- Default:
- -4100
3D Column.
-
column3DClustered
- Type:
- ig.excel.ChartType
- Default:
- 54
3D Clustered Column.
-
column3DStacked
- Type:
- ig.excel.ChartType
- Default:
- 55
3D Stacked Column.
-
column3DStacked100
- Type:
- ig.excel.ChartType
- Default:
- 56
3D 100% Stacked Column.
-
columnClustered
- Type:
- ig.excel.ChartType
- Default:
- 51
Clustered Column.
-
columnStacked
- Type:
- ig.excel.ChartType
- Default:
- 52
Stacked Column.
-
columnStacked100
- Type:
- ig.excel.ChartType
- Default:
- 53
100% Stacked Column.
-
combo
- Type:
- ig.excel.ChartType
- Default:
- 113
Combination of different chart types.
-
coneBarClustered
- Type:
- ig.excel.ChartType
- Default:
- 102
Clustered Cone Bar.
-
coneBarStacked
- Type:
- ig.excel.ChartType
- Default:
- 103
Stacked Cone Bar.
-
coneBarStacked100
- Type:
- ig.excel.ChartType
- Default:
- 104
100% Stacked Cone Bar.
-
coneCol
- Type:
- ig.excel.ChartType
- Default:
- 105
3D Cone Column.
-
coneColClustered
- Type:
- ig.excel.ChartType
- Default:
- 99
Clustered Cone Column.
-
coneColStacked
- Type:
- ig.excel.ChartType
- Default:
- 100
Stacked Cone Column.
-
coneColStacked100
- Type:
- ig.excel.ChartType
- Default:
- 101
100% Stacked Cone Column.
-
cylinderBarClustered
- Type:
- ig.excel.ChartType
- Default:
- 95
Clustered Cylinder Bar.
-
cylinderBarStacked
- Type:
- ig.excel.ChartType
- Default:
- 96
Stacked Cylinder Bar.
-
cylinderBarStacked100
- Type:
- ig.excel.ChartType
- Default:
- 97
100% Stacked Cylinder Bar.
-
cylinderCol
- Type:
- ig.excel.ChartType
- Default:
- 98
3D Cylinder Column.
-
cylinderColClustered
- Type:
- ig.excel.ChartType
- Default:
- 92
Clustered Cone Column.
-
cylinderColStacked
- Type:
- ig.excel.ChartType
- Default:
- 93
Stacked Cone Column.
-
cylinderColStacked100
- Type:
- ig.excel.ChartType
- Default:
- 94
100% Stacked Cylinder Column.
-
doughnut
- Type:
- ig.excel.ChartType
- Default:
- -4120
Doughnut.
-
doughnutExploded
- Type:
- ig.excel.ChartType
- Default:
- 80
Exploded Doughnut.
-
histogram
- Type:
- ig.excel.ChartType
- Default:
- 117
Histogram chart (Office2016 or later)
-
line
- Type:
- ig.excel.ChartType
- Default:
- 4
Line.
-
line3D
- Type:
- ig.excel.ChartType
- Default:
- -4101
3D Line.
-
lineMarkers
- Type:
- ig.excel.ChartType
- Default:
- 65
Line with Markers.
-
lineMarkersStacked
- Type:
- ig.excel.ChartType
- Default:
- 66
Stacked Line with Markers.
-
lineMarkersStacked100
- Type:
- ig.excel.ChartType
- Default:
- 67
100% Stacked Line with Markers.
-
lineStacked
- Type:
- ig.excel.ChartType
- Default:
- 63
Stacked Line.
-
lineStacked100
- Type:
- ig.excel.ChartType
- Default:
- 64
100% Stacked Line.
-
pareto
- Type:
- ig.excel.ChartType
- Default:
- 116
Pareto chart with bars and lines (Office2016 or later)
-
pie
- Type:
- ig.excel.ChartType
- Default:
- 5
Pie.
-
pie3D
- Type:
- ig.excel.ChartType
- Default:
- -4102
3D Pie.
-
pie3DExploded
- Type:
- ig.excel.ChartType
- Default:
- 70
Exploded 3D Pie.
-
pieExploded
- Type:
- ig.excel.ChartType
- Default:
- 69
Exploded Pie.
-
pieOfPie
- Type:
- ig.excel.ChartType
- Default:
- 68
Pie of Pie.
-
pyramidBarClustered
- Type:
- ig.excel.ChartType
- Default:
- 109
Clustered Pyramid Bar.
-
pyramidBarStacked
- Type:
- ig.excel.ChartType
- Default:
- 110
Stacked Pyramid Bar.
-
pyramidBarStacked100
- Type:
- ig.excel.ChartType
- Default:
- 111
100% Stacked Pyramid Bar.
-
pyramidCol
- Type:
- ig.excel.ChartType
- Default:
- 112
3D Pyramid Column.
-
pyramidColClustered
- Type:
- ig.excel.ChartType
- Default:
- 106
Clustered Pyramid Column.
-
pyramidColStacked
- Type:
- ig.excel.ChartType
- Default:
- 107
Stacked Pyramid Column.
-
pyramidColStacked100
- Type:
- ig.excel.ChartType
- Default:
- 108
100% Stacked Pyramid Column.
-
radar
- Type:
- ig.excel.ChartType
- Default:
- -4151
Radar.
-
radarFilled
- Type:
- ig.excel.ChartType
- Default:
- 82
Filled Radar.
-
radarMarkers
- Type:
- ig.excel.ChartType
- Default:
- 81
Radar with Data Markers.
-
stockHLC
- Type:
- ig.excel.ChartType
- Default:
- 88
High-Low-Close.
-
stockOHLC
- Type:
- ig.excel.ChartType
- Default:
- 89
Open-High-Low-Close.
-
stockVHLC
- Type:
- ig.excel.ChartType
- Default:
- 90
Volume-High-Low-Close.
-
stockVOHLC
- Type:
- ig.excel.ChartType
- Default:
- 91
Volume-Open-High-Low-Close.
-
sunburst
- Type:
- ig.excel.ChartType
- Default:
- 118
Sunburst chart (Office2016 or later)
-
surface
- Type:
- ig.excel.ChartType
- Default:
- 83
Surface (a.k.a. Contour).
-
surfaceTopView
- Type:
- ig.excel.ChartType
- Default:
- 85
3D Surface (Top View).
-
surfaceTopViewWireframe
- Type:
- ig.excel.ChartType
- Default:
- 86
3D Surface (Top View wireframe).
-
surfaceWireframe
- Type:
- ig.excel.ChartType
- Default:
- 84
Surface (a.k.a. Contour - wireframe).
-
treemap
- Type:
- ig.excel.ChartType
- Default:
- 119
Tree map chart (Office2016 or later)
-
unknown
- Type:
- ig.excel.ChartType
- Default:
- 0
Not an actual value; used for variable initialization.
-
waterfall
- Type:
- ig.excel.ChartType
- Default:
- 120
Waterfall chart (Office2016 or later)
-
xYScatter
- Type:
- ig.excel.ChartType
- Default:
- -4169
Scatter.
-
xYScatterLines
- Type:
- ig.excel.ChartType
- Default:
- 74
Scatter with Lines.
-
xYScatterLinesNoMarkers
- Type:
- ig.excel.ChartType
- Default:
- 75
Scatter with Lines and No Data Markers.
-
xYScatterSmooth
- Type:
- ig.excel.ChartType
- Default:
- 72
Scatter with Smoothed Lines.
-
xYScatterSmoothNoMarkers
- Type:
- ig.excel.ChartType
- Default:
- 73
Scatter with Smoothed Lines and No Data Markers.