Spread ASP.NET 17
Spread for ASP.NET 17 Product Documentation / Import and Export Reference / Excel-Formatted File Import / Chart Settings Imported
In This Topic
    Chart Settings Imported
    In This Topic

    The following 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  
    Stacked Line with Markers 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.