You can add a chart control to the sheet using code or the Spread Designer to create
impressive 2D or 3D charts. You can also allow the user to resize the chart and
the range of data used in the chart control.
There are several visual elements to a chart such as the plot, legend, and label
areas; the axis, and the series. The plot area is the area in which data points
are drawn. The legend area can be used to help end users identify different chart
elements such as the series. The label area contains additional information about
the chart. The axis displays the scale for a single dimension of a plot area. Each
series is a collection of data points.
Choose from the following twelve charts and customize up to 85 different chart types.
Column Charts
The
Column type has the following types of views - Clustered Column, Stacked
Column, 100% Stacked Column, High Low Column, 3D Clustered Column, 3D Stacked Column,
100% 3D Stacked Column, 3D Column, 3D High Low Column, Clustered Cylinder, Stacked
Cylinder, 100% Stacked Cylinder, 3D Cylinder, High Low Column Cylinder, Clustered
Full Cone, Stacked Full Cone, 100% Stacked Full Cone, 3D Full Cone, High Low Column
Full Cone, Clustered Full Pyramid, Stacked Full Pyramid, 100% Stacked Full Pyramid,
3D Pyramid, and High Low Column Pyramid.
Line Charts
The
Line type has the following types of views - Line, Stacked Line, 100%
Stacked Line, Line with Markers, Stacked Line with Markers, 100% Stacked Line with
Markers, and 3D Line.
Pie Charts
The
Pie type has the following types of views - 2D Pie, 3D Pie, 2D Exploded
Pie, and 3D Exploded Pie.
Bar Charts
The
Bar type has the following types of views - Clustered Bar, Stacked Bar,
100% Stacked Bar, High Low Bar, 3D Clustered Bar , 3D Stacked Bar, 100% 3D Stacked
Bar, 3D High Low Bar, Clustered Horizontal Cylinder, Stacked Horizontal Cylinder,
100% Stacked Horizontal Cylinder, High Low Bar Cylinder, Clustered Horizontal Full
Cone, Stacked Horizontal Full Cone, 100% Stacked Horizontal, High Low Bar Full Cone,
Clustered Horizontal Full Pyramid, Stacked Horizontal Full Pyramid, 100% Stacked
Horizontal, and High Low Bar Pyramid.
Area Charts
The
Area type has the following types of views - Area, Stacked Area, 100%
Stacked Area, High Low Area, 3D Area, 3D Stacked Area, 100% 3D Stacked Area, and
3D High Low Area.
XY Charts
The
XY type has the following types of views - XY Point, XY Line, and XY
Line with Marker.
Bubble Charts
The
Bubble type has the following types of views - 2D Bubble and 3D Bubble.
Stock Charts
The
Stock type has the following types of views - High Low Close, Open High
Low Close, and Candle Stick.
XYZ Charts
The
XYZ type has the following types of views - XYZ Line, XYZ Line with Marker,
XYZ Point, and Surface.
Doughnut Charts
The
Doughnut type has the following types of views - Doughnut and Exploded
Doughnut.
Radar Charts
The
Radar type has the following types of views - Radar Line, Radar Line
with Marker, Radar Point, and Radar Area.
Polar Charts
The
Polar type has the following types of views - Polar Line, Polar Line
with Marker, Polar Point, and Polar Area.