Excel ChartType 對應至 Chart 控制項 ChartType

  • 3844
  • 0
  • 2012-10-01

摘要:Excel ChartType 對應至 Chart 控制項 ChartType

作個記錄

參考資料:

1. 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