Preparing Effective Charts and Graphs
SECTION 1C: Enter Data into a Spreadsheet Program

A spreadsheet page is typically divided into rows and columns. The intersection of a row and a column forms a box called a cell. You can type text or numbers in cells. Text is commonly used to create labels identifying data in a particular row or column. When you enter data in a cell, the program allows you to specify the type of data (for example, date, number, currency, time) and how it will be displayed (for example, Friday, March 31, 2006 or 03/31/2006 or 31-Mar-06).

Data in a spreadsheet
The spreadsheet below shows an annual school budget for boys and girls athletics during a three-year span. Text is used to label columns (budget years) and rows (boys or girls). Budget data are formatted as currency displaying the symbol "$" and without any decimal places. Cell C3 shows that in 2004 $3,100 was spent on the athletic program for girls.


HOME: Introduction to this tutorial
1. Overview of the Process
  1. Analyze Your Audience and Purpose
  2. Understand the Limitations of Spreadsheet Programs
  3. Enter Data into a Spreadsheet Program
  4. Select Data to Include in a Graphic
  5. Choose the Appropriate Kind of Graphic
  6. Customize the Graphic for Your Audience and Purpose
  7. Select Where to Place the Graphic in the Spreadsheet
  8. Insert the Graphic into a Word-Processing or Presentation Program
  9. Integrate the Graphic and the Text
2. Designing Effective Charts & Graphs
  1. Make Sure Your Graphic Has a Purpose
  2. Aim for Simplicity
  3. Be Honest
  4. Present a Manageable Amount of Information
  5. Follow Common Conventions for Graphics
  6. Label Your Graphic
3. Sample Graphics for Analysis
  1. Pie Chart
  2. Gantt Chart
  3. 100-Percent Horizontal Bar Graph
  4. Vertical Bar Graph
  5. Line Graph


Previous PageNext Page
 Bedford/St. Martin's | Business & Technical | About the Author | Catalog | Order a Book | Contact Us