Spread Windows Forms 8.0 Product Documentation
Chart Settings Exported

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.

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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback