Types of Charts

The most common chart types include pie, bar, column (default), line, and area. Table 12.2 lists these chart types, their descriptions, and how you would use them.

Table 12.2. Excel's Chart Types
Chart TypeDescription/How to Use It
PiePlots only one category of data, but each wedge of the pie represents a different data series. Use this chart to show the relationship among parts of a whole.
BarHorizontal representations of column charts, often called histograms. Use this chart to compare values at a given point in time, emphasizing the performance of a group of items. Often, different patterns are not required for bar chart data series.
ColumnSimilar to a bar chart; use this chart to emphasize the difference between items over a period ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.