Preparing Effective Charts and Graphs
SECTION 3C: 100-Percent Horizontal Bar Graph

Study the data and graphic below illustrating the relative proportions of fat, carbohydrates, and protein in several energy bars. Focus on these questions:
  1. How effectively is the graph labeled? Explain.

    The graph needs a clear, informative title after the number and label at the bottom. The horizontal and vertical axes need labels. Readers also need a legend to understand what each color represents in the graph. Finally, each segment should be labeled with specific data: the number and source of calories.

  2. How effective is the design of the bars and the use of colors?

    The bars are too narrow, and the shaded background is distracting.

  3. How appropriate is the scale? Explain.

    The scale appropriately begins at zero and stops at 100 percent. Dividing the scale into 10 segments provides enough information to help readers understand the data but not so much so that the axis is cluttered with data labels.

REVISED GRAPH
The revised graph shown below corrects the problems described in the sample answers.
Figure 1. Comparison of Relative Proportion of Calories from Fat, Carbohydrates, and Protein in Four Energy Bars
Note, however, that this type of graph—a 100-percent bar graph—shows only percentages, not raw data. In this case, the graph does not show the total calories of each of the four bars. Selecting a type of graph that does not show total calories could be misleading if the purpose of the graph is to help readers choose the healthiest bar. The subdivided-bar graph below contains this extra information.
Figure 1. Comparison of Relative Proportion of Calories from Fat, Carbohydrates, and Protein in Four Energy Bars
ORIGINAL DATA AND GRAPH


Figure 1.
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