摘要:Excel ChartType 對應至 Chart 控制項 ChartType
作個記錄
參考資料:
2. 圖表類型
3. 自訂屬性清單
| Excel ChartType 列舉型別 | Chart控制項 ChartType | 3D Style Enabled | IsClustered | CustomProperties | Notes |
|---|---|---|---|---|---|
| xl3DArea | Area | TRUE | |||
| xl3DAreaStacked | StackedArea | TRUE | |||
| xl3DAreaStacked100 | StackedArea100 | TRUE | |||
| xl3DBarClustered | Bar | TRUE | TRUE | ||
| xl3DBarStacked | StackedBar | TRUE | |||
| xl3DBarStacked100 | StackedBar100 | TRUE | |||
| xl3DColumn | Column | TRUE | |||
| xl3DColumnClustered | Column | TRUE | TRUE | ||
| xl3DColumnStacked | StcakedColumn | TRUE | |||
| xl3DColumnStacked100 | StackedColumn100 | TRUE | |||
| xl3DLine | Line | TRUE | |||
| xl3DPie | Pie | TRUE | |||
| xl3DPieExploded | Pie | TRUE | Exploded = True | ||
| xlArea | Area | ||||
| xlAreaStacked | StackedArea | ||||
| xlAreaStacked100 | StackedArea100 | ||||
| xlBarClustered | Bar | ||||
| xlBarOfPie | N/A | ||||
| xlBarStacked | StackedBar | ||||
| xlBarStacked100 | StackedBar100 | ||||
| xlBubble | Bubble | MarkerStyle=Circle | |||
| xlBubble3DEffect | N/A | ||||
| xlColumnClustered | Column | ||||
| xlColumnStacked | StackedColumn | ||||
| xlColumnStacked100 | StackedColumn100 | ||||
| xlConeBarClustered | N/A | ||||
| xlConeBarStacked | N/A | ||||
| xlConeBarStacked100 | N/A | ||||
| xlConeCol | N/A | ||||
| xlConeColClustered | N/A | ||||
| xlConeColStacked | N/A | ||||
| xlConeColStacked100 | N/A | ||||
| xlCylinderBarClustered | Bar | TRUE | TRUE | DrawingStyle = Cylinder | |
| xlCylinderBarStacked | StackedBar | DrawingStyle = Cylinder | |||
| xlCylinderBarStacked100 | StackedBar100 | DrawingStyle = Cylinder | |||
| xlCylinderCol | Column | DrawingStyle = Cylinder | |||
| xlCylinderColClustered | Column | TRUE | TRUE | DrawingStyle = Cylinder | |
| xlCylinderColStacked | StackedColumn | DrawingStyle = Cylinder | |||
| xlCylinderColStacked100 | StackedColumn100 | DrawingStyle = Cylinder | |||
| xlDoughnut | Doughnut | ||||
| xlDoughnutExploded | Doughnut | Exploded = true | |||
| xlLine | Line | ||||
| xlLineMarkers | Line | 需指定MarkerStyle | |||
| xlLineMarkersStacked | N/A | ||||
| xlLineMarkersStacked100 | N/A | ||||
| xlLineStacked | N/A | ||||
| xlLineStacked100 | N/A | ||||
| xlPie | Pie | ||||
| xlPieExploded | Pie | Exploded = true | |||
| xlPieOfPie | N/A | ||||
| xlPyramidBarClustered | N/A | ||||
| xlPyramidBarStacked | N/A | ||||
| xlPyramidBarStacked100 | N/A | ||||
| xlPyramidCol | N/A | ||||
| xlPyramidColClustered | N/A | ||||
| xlPyramidColStacked | N/A | ||||
| xlPyramidColStacked100 | N/A | ||||
| xlRadar | Radar | AreaDrawingStyle = Polygon | 指定Series邊框顏色 , 指定Series顏色為透明 | ||
| xlRadarFilled | Radar | AreaDrawingStyle = Polygon | |||
| xlRadarMarkers | Radar | AreaDrawingStyle = Polygon | 需指定MarkerStyle, 指定Series邊框顏色 , 指定Series顏色為透明 | ||
| xlStockHLC | N/A | ||||
| xlStockOHLC | Stock | ||||
| xlStockVHLC | N/A | ||||
| xlStockVOHLC | N/A | ||||
| xlSurface | N/A | ||||
| xlSurfaceTopView | N/A | ||||
| xlSurfaceTopViewWireframe | N/A | ||||
| xlSurfaceWireframe | N/A | ||||
| xlXYScatter | Point | ||||
| xlXYScatterLines | Line | 需指定MarkerStyle | |||
| xlXYScatterLinesNoMarkers | Line | ||||
| xlXYScatterSmooth | Spline | 需指定MarkerStyle | |||
| xlXYScatterSmoothNoMarkers | Spline |