1. Home
  2. Computing & Technology
  3. Spreadsheets

Chart

By Ted French, About.com

Pie Chart in Excel spreadsheet

Pie Chart in Excel spreadsheet

© Ted French
Definition:

Charts are what we call graphs in math class. They also happen to be called graphs in spreadsheet programs such as Lotus 1-2-3 and Quattro Pro. Only in Microsoft Excel it seems are they called charts.

Charts then, are visual representations of worksheet data. Charts often makes it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see.

Different types of charts serve different purposes.

Pie Charts -- are used to show percentages. For example, a pie chart could be used to show what percentage of your total daily calorie intake is represented by one quadruple cheese and bacon hamburger.

Column Charts -- are used to show comparisons between items of data. Each column in the chart represents the value of one item of data. An example of this would be to compare the calories in a quadruple cheese and bacon hamburger with the calories in a glass of water and a bowl of beet greens.

Bar Charts -- are very similar to column charts, except they run horizontally on the page instead of vertically like column charts.

Line Charts -- are used to show trends over time. Each line in the graph shows the changes in the value of one item of data. For example you could show changes in your weight over a period of months as a result of eating a quadruple cheese and bacon hamburger every day for lunch.

Also Known As: graph
Examples: There are many choices when it comes to charts in Excel - pie charts, bar charts, line charts, and column charts are just a few of the chart types available. No matter which chart type you choose, remember, the first step in creating a chart is to select the data you are going to use before creating it.

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. Spreadsheet Definitions
  5. C
  6. Spreadsheets - Glossary - Excel - Chart Definition

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

All rights reserved.