O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Choosing the Best Chart Type for Your Data

Excel enables you to create an impressive variety of different types of charts. Some of the charts are useful for many purposes, whereas others are highly specialized. Table 7–1 describes the types of charts that Excel provides and suggests typical uses for them. The table lists the charts in the same order as Excel's Chart panel, which I'll describe shortly and which puts the most widely used chart types first.

Table 7–1. Excel's Chart Types and Suggested Uses

Chart Category Description Suggested Uses
Column Displays data in vertical bars. Comparing equivalent items (such as sales results) or sets of data that change over time (such as rainfall).
Line Displays each series in a line. Showing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required