Chart Types

With Excel, you can create various types of charts. Some common chart types are shown in Figure 22.1. The chart type you choose depends on your data and on how you want to present that data. These are the major chart types and their purposes:

Pie Use this chart to show the relationship among parts of a whole.

Bar Use this chart to compare values at a given point in time.

Column Similarto the Bar chart; use this chart to emphasize the difference between items.

Line Use this chart to emphasize trends and the change of values over time.

Scatter Similarto a Line chart; use this chart to emphasize the difference between two sets of values.

Area Similar to the Line chart; use this chart to emphasize the amount of change in values over ...

Get Ten Minute Guide to Excel 97 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.