Microsoft Office Tutorials and References
In Depth Information
Chapter 10: Charting and Analyzing Data
Although Figure 10-1 shows a column chart, Excel can create a variety of
other types of charts so you can look at your data in different ways, as shown
in Figure 10-2. Some other types of charts Excel can create include
Column chart: Displays quantities as vertical columns that “grow”
upward. Useful for creating charts that compare two items, such as sales
per month or sales per salesperson.
Line chart: Displays quantities as lines. Essentially shows the tops of a
Area chart: Identical to a line chart except that it shades the area
underneath each line.
Bar chart: Essentially a column chart turned on its side where bars
“grow” from left to right.
Pie chart: Compares multiple items in relation to a whole, such as which
product sales make up a percentage of a company’s overall profits.
Excel can create both two- and three-dimensional charts. A 3-D chart can look
neat, but sometimes the 3-D visual can obscure the true purpose of the chart,
which is to simplify data and make it easy for you to understand in the first