Preparing Effective Charts and Graphs
SECTION 1F: Customize the Graphic for Your Audience and Purpose

When customizing your graphic, let your understanding of your audience and purpose guide your design decisions. For example, if your line graph must be readable from a distance of three feet, you might decide to increase the thickness of the lines and the size of the text. If your graphic features an excessively long vertical axis, you can use larger units for that axis.

You can modify elements of your graphic while using the Chart Wizard as well as by double-clicking an element after you have created your graphic. In addition to modifying graphic elements, you can select which data series are displayed and change how data series are arranged in your graphic.

In the three following examples, the writer changes the focus of a bar graph that compares a company's injury rates related to manufacturing three different materials with the average injury rates for that industry. The writer changes the focus by switching the way data are plotted along the horizontal (x) axis and by removing a data series. In the first example, data are plotted by rows. In the second example, data are plotted by columns. In the final example, data are plotted by columns and the data series for plastics is removed.

In this example, data are plotted by rows.


In this example, the same data are plotted by columns.


The writer has removed the data series for plastics in this example.


The Chart Wizard also allows you to add, delete, and modify many of the design elements that form your graphic.

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