Charts and Chart Types

Charts are graphic representations of spreadsheet data. Their visual nature expedites quick analysis, color coding, and cues that aid comparisons.

Charts, depending on the chart type, can display one to four dimensions. Pie charts only display one dimension; quadrant charts offer more complex displays.

Charts can be rendered using a variety of chart types:

Chart Type

Compares

Bar

Similar elements, represented as vertical bars.

Line

Items over time.

Spline

Displays the document as a spline chart.

Pie

Contributions.

Area

Items over time.

Curve Area

Items over time, represented as a curved area.

Horizontal Bar

Similar elements.

Marks

Items over time.

Pareto

Trends in data.

Box

Displays the document as a box plot chart.

Quadrant

Two members from one dimension over time.

Bubble

Displays the document as a Bubble chart.

Only the first 50 dimension members can be accommodated on chart axes.