Spread Windows Forms 11.0 Product Documentation
Chart Settings Imported
Spread Windows Forms 11.0 Product Documentation > Import and Export Reference > Excel-Formatted Files Import > Chart Settings Imported

This table summarizes how Spread imports charts from an Excel-formatted file.

Excel Chart Type and View Spread Chart Type and View Remarks
Column  
Clustered Column Clustered Column  
Stacked Column Stacked Column  
100% Stacked Column 100% Stacked Column  

3D Clustered Column

3D Clustered Column

 
3D Stacked Column 3D Stacked Column  
100% 3D Stacked Column 100% 3D Stacked Column  
3D Column 3D Column  
Clustered Cylinder Clustered Cylinder  
Stacked Cylinder Stacked Cylinder  
100% Stacked Cylinder 100% Stacked Cylinder  
3D Cylinder 3D Cylinder  
Clustered Cone Clustered Full Cone  
Stacked Cone Stacked Full Cone  
100% Stacked Cone 100% Stacked Full Cone  
3D Full Cone 3D Full Cone  
Clustered Pyramid Clustered Full Pyramid  
Stacked Pyramid Stacked Full Pyramid  
100 Stacked Pyramid 100% Stacked Full Pyramid  
3D Pyramid 3D Full Pyramid  
Line  
Line Line  
Stacked Line Stacked Line  
100% Stacked Line 100% Stacked Line  
Line with Markers Line with Markers  
100% Stacked Line with Markers 100% Stacked Line with Markers  
3D Line 3D Line  
Pie  
Pie 2D Pie  
3D Pie 3D Pie  
Pie of Pie   This setting is not imported.
Exploded Pie Exploded Pie  
3D Exploded Pie 3D Exploded Pie  
Bar of Pie   This setting is not imported.
Bar  
Clustered Bar Clustered Bar  
Stacked Bar Stacked Bar  
100% Stacked Bar 100% Stacked Bar  
3D Clustered Bar 3D Clustered Bar  
3D Stacked Bar 3D Stacked Bar  
100% 3D Stacked Bar 100% 3D Stacked Bar  
Clustered Horizontal Cylinder Clustered Horizontal Cylinder  
Stacked Horizontal Cylinder Stacked Horizontal Cylinder  
100% Stacked Horizontal Cylinder 100% Stacked Horizontal Cylinder  
Clustered Horizontal Cone Clustered Horizontal Full Cone  
Stacked Horizontal Full Cone Stacked Horizontal Cone  
100% Stacked Horizontal Cone 100% Stacked Horizontal Full Cone  
Clustered Horizontal Pyramid Clustered Horizontal Full Pyramid  
Stacked Horizontal Pyramid Stacked Horizontal Full Pyramid  
100% Stacked Horizontal Pyramid 100% Stacked Horizontal Full Pyramid  
Area  
Area Area  
Stacked Area Stacked Area  
100% Stacked Area 100% Stacked Area  
3D Area 3D Area  
Stacked 3D Area Stacked 3D Area  
100% Stacked 3D Area 100% Stacked 3D Area  
XY (Scatter)  
Scatter with Markers XY Point  
Scatter with Smooth Lines and Markers XY Line with Markers and Smooth Lines  
Scatter with Smooth Lines XY Line with Smooth Lines  
Scatter with Straight Lines XY Line  
Scatter with Straight Lines and Markers XY Line with Markers  
Bubble  
Bubble 2D Bubble  
Bubble with a 3D effect 2D Bubble The 3D effect is not imported.
Stock  
High Low Close High Low Close  
Open High Low Close Candlestick  
Volume High Low Close Clustered Bar with High Low Close  
Volume Open High Low Close Clustered Bar with Candlestick  
Surface  
3D Surface   This setting is not imported.
Wireframe 3D Surface   This setting is not imported.
Contour   This setting is not imported.
Doughnut  
Doughnut Doughnut  
Exploded Doughnut Exploded Doughnut  
Radar  
Radar Radar Line  
Radar with Markers Radar Line with Markers  
Filled Radar Radar Area  
Box Whisker    
Box Whisker Box Whisker  
Pareto    
Pareto Pareto  
Funnel    
Funnel Funnel  
Histogram    
Histogram Histogram  
Waterfall    
Waterfall Waterfall  
Sunburst    
Sunburst Sunburst
Treemap    
Treemap Treemap  

Spread only imports series that match the Spread plot area type.

If the Excel plot area contains a combination of different series types (such as column and pie), then Spread chooses the type of plot area to import based on the first series.

LabelVisible, LabelTextDirection, LabelFormatter, LabelContainsCategoryName, LabelContainsSeriesName, LabelContainsValues, and LabelSeparator values are imported.