Chart Settings Imported
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.