Chart Settings Exported
Charts are exported to Excel-formatted files when they are part of the Spread control. The following table lists the general chart type and views and how they are exported to Excel.
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 | This setting is not exported. | |
Line | ||
Line | Line | |
Stacked Line | Stacked Line | |
100% Stacked Line | 100% Stacked Line | |
Line with Marker | Line with Marker | |
100% Stacked Line with Markers | 100% Stacked Line with Markers | |
Stacked Line with Markers | 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 Markers | 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 Markers | 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, etc. Spread exports the first plot area when exporting multiple plot areas.