Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Import and Export Reference / Excel-Formatted Files Export / Chart Settings Exported
In This Topic
    Chart Settings Exported
    In This Topic

    Charts are exported to Excel. The following table lists the general chart type and views and how they are exported to Excel.

    Spread Chart Type and View Excel Chart Type and View Remarks
    Column  
    Clustered Column Clustered Column  
    Stacked Column Stacked Column  
    100% Stacked Column 100% Stacked Column  
    High Low Column   This setting is not exported.
    3D Clustered Column 3D Clustered Column  
    3D Stacked Column 3D Stacked Column  
    100% 3D Stacked Column 100% 3D Stacked Column  
    3D Column 3D Column  
    High Low Column in 3D   This setting is not exported.
    Clustered Cylinder Clustered Cylinder  
    Stacked Cylinder Stacked Cylinder  
    100% Stacked Cylinder 100% Stacked Cylinder  
    3D Cylinder 3D Cylinder  
    High Low Column Cylinder   This setting is not exported.
    Clustered Full Cone Clustered Cone  
    Stacked Full Cone Stacked Cone  
    100% Stacked Full Cone 100% Stacked Cone  
    3D Full Cone 3D Full Cone  
    High Low Column Full Cone   This setting is not exported.
    Clustered Full Pyramid Clustered Pyramid  
    Stacked Full Pyramid Stacked Pyramid  
    100 Stacked Full Pyramid 100% Stacked Pyramid  
    3D Full Pyramid 3D Pyramid  
    High Low Column Full Pyramid   This setting is not exported.
    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  
    2D Pie Pie  
    3D Pie 3D Pie  
    Exploded Pie Exploded Pie  
    3D Exploded Pie 3D Exploded Pie  
    Bar  
    Clustered Bar Clustered Bar  
    Stacked Bar Stacked Bar  
    100% Stacked Bar 100% Stacked Bar  
    High Low Bar   This setting is not exported.
    3D Clustered Bar 3D Clustered Bar  
    3D Stacked Bar 3D Stacked Bar  
    100% 3D Stacked Bar 100% 3D Stacked Bar  
    3D High Low Bar   This setting is not exported.
    Clustered Horizontal Cylinder Clustered Horizontal Cylinder  
    Stacked Horizontal Cylinder Stacked Horizontal Cylinder  
    100% Stacked Horizontal Cylinder 100% Stacked Horizontal Cylinder  
    High Low Bar Cylinder   This setting is not exported.
    Clustered Horizontal Full Cone Clustered Horizontal Cone  
    Stacked Horizontal Full Cone Stacked Horizontal Cone  
    100% Stacked Horizontal Full Cone 100% Stacked Horizontal Cone  
    High Low Bar Full Cone   This setting is not exported.
    Clustered Horizontal Full Pyramid Clustered Horizontal Pyramid  
    Stacked Horizontal Full Pyramid Stacked Horizontal Pyramid  
    100% Stacked Horizontal Full Pyramid 100% Stacked Horizontal Pyramid  
    High Low Bar Full Pyramid   This setting is not exported.
    Area  
    Area Area  
    Stacked Area Stacked Area  
    100% Stacked Area 100% Stacked Area  
    High Low Area   This setting is not exported.
    3D Area 3D Area  
    Stacked 3D Area Stacked 3D Area  
    100% Stacked 3D Area 100% Stacked 3D Area  
    3D High Low Area   This setting is not exported.
    XY  
    XY Point XY (Scatter) - Scatter with Markers  
    XY Line XY (Scatter) - Scatter with Straight Lines  
    XY Line with Marker XY (Scatter) - Scatter with Straight Lines and Markers  
    Bubble  
    2D Bubble Bubble  
    3D Bubble Bubble The view type is exported as a 2D view.
    Stock  
    High Low Close High Low Close  
    Open High Low Close   This setting is not exported.
    Candlestick Open High Low Close  
    XYZ  
    XYZ Line Surface - Scatter with Straight Lines  
    XYZ Line with Marker Surface - Scatter with Straight Lines and Markers  
    XYZ Point Surface - Scatter with Markers  
    XYZ Surface   This setting is not exported.
    Doughnut  
    Doughnut Doughnut  
    Exploded Doughnut Exploded Doughnut  
    Radar  
    Radar Line Radar  
    Radar Line with Markers Radar with Markers  
    Radar Point Radar (no lines)  
    Radar Area Filled Radar  
    Polar  
    Polar Line Area   This setting is not exported.
    Polar Line with Marker   This setting is not exported.
    Polar Point   This setting is not exported.
    Polar Area   This setting is not exported.
    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 supports multiple plot areas in a combined chart. Each plot area has a given type and can contain any series of a corresponding type. For example, a YPlotArea can contain any combination of YSeries, a RadarPlotArea can contain any combination of RadarSeries, and so on. Spread exports the first plot area when exporting multiple plot areas.

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

    See Also