摘要: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 |