1. Home
  2. Computing & Technology
  3. Spreadsheets

Choosing the Right Graph - Excel Graphs and their Uses

By Ted French, About.com

5 of 5

Excel Pie Charts

Excel 2007 Pie Chart

Excel 2007 Pie Chart

� Ted French

Excel Pie Charts

Pie charts, or circle graphs as they are sometimes known, are a little different from the other three types of graphs discussed.

For one, pie charts do not use horizontal and vertical axes to plot points like the others. They also differ in that they are used to chart only one variable at a time. As a result, it can only be used to show percentages.

The circle of pie charts represents 100%. The circle is subdivided into slices representing data values. The size of each slice shows what part of the 100% it represents.

Pie charts can be used anytime you want to show what percent a particular item represents of a data series such as:

  • A baseball player's batting average can be shown with a pie chart as it represents the percentage of hits when compared to his total number of at bats for a season.

  • A company's profits for each month can be shown with a pie chart as a percentage of the year's total profits.

For more information, read the Excel 2007 Pie Chart Tutorial

Return to page 1

This article is one of the "stops" on the Virtual Amazing Race, a lesson plan suitable for grades 5 and up. Students gather research in a webquest of around-the-world topics and (optionally) create a Web site Using PowerPoint.

Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Free Excel Tutorials
  5. Pie Charts- Excel Pie Charts- Pie Chart Uses

©2009 About.com, a part of The New York Times Company.

All rights reserved.