Charts And Diagrams
Page Summary
This page ….
Related Pages

Basics

Making quality charts is part art, part science. It is all skill, patience, and experience. Do not underestimate the value of investing in developing the skill. A great chart can kill — though often without people realizing it. On the other hand, most charts are junk: poorly conceived, poorly executed — they do a bad job of communicating, they waste people's time, and they confuse rather than enlighten. But no one really notices, because they are so used to it.

ADVICE: Take the time. Be disciplined. Experiment.

RULE 1. Every chart should stand on its own : be completely self-documenting

Always assume that a chart will be reproduced out of its original context. It should convey the same information ripped from context as it would in its original place on the page. This means

  • Chart title must be descriptive, accurate, and standardized
  • All axes must be properly labeled
  • Dates: as of, when made, last revised
  • Data sources, other references, and any disclaimers or caveats should be integral to the chart.
  • Who made this chart?

RULE 2. Know what a chart is trying to say. Most charts have a single message — make sure you know what it is and that it is successfully communicated.

  • Distinguish, then, the use of charts for data exploration and their deployment as a means for visually conveying quantitative information.
    • A sometimes useful heuristic: can you write a straightforward declarative sentence as a caption?
  • Although we often make charts while exploring data, charts that we make for reports and publications are designed to show something we have found out. In general, our design strategy is to direct attention to what matters and avoid drawing attention to that which does not.
  • Lying: as a rule, you shouldn't use charts to lie, but if you do, you should be in control of the lies you are telling. See below.

RULE 3. Pick the right chart type for the job.

  • Proportions that add up to 100 : pie chart.
  • Frequency distributions of one variable: bar/column histogram.
  • Correlation between two variables: xy scatterplot
  • Trend over time: line graph
  • Three dimensions
    • Two IV + frequency : sometimes a "3D column chart"
    • Two IV + magnitude : sometimes a "bubble chart"
  • See [http://extremepresentation.typepad.com/files/choosing-a-good-chart-09.pdf] for a pretty good "all on one page" version of this.

RULE 4. Be in control of the visual communication

Background and Review : Types of Variables

  1. Nominal or categorical
  2. Ordinal or ranked categories
  3. Interval — distance means something
  4. Ratio — zero means something

Background and Review : Distribution

Background and Review : Frequency

Chart Types, Indications and Contraindications

excel-pp-chart-template.jpg
http://freshfreestuff.net/wp-content/uploads/2009/09/excel-pp-chart-template.jpg

Bar and Column

When to Use

Counts or levels in categories for nominal (categorical) data. Ordinal, interval or ratio data if grouped into categories or classes.
Relatively small number of categories.
When the story is the shape of a discrete distribution (over categories or time)

When not to Use

Large number of categories
When the story is relative proportions or fractions of a whole (see pie charts)

Proportions vs. Absolute Numbers

image001.jpgimage002.jpgimage003.jpgimage004.jpg

Source Dual Career Report

Variants and Specialty Uses

A stacked bar (or column) chart is used to show both the total in a category and the size of the subcategories of which it is composed.

1305.stackedChart.gif

http://www.roseindia.net/tutorialfiles/1305.stackedChart.gif

Population Pyramid
population_pyramid.png

http://thinkgeography.files.wordpress.com/2008/10/population_pyramid.png

See Also: How to Make a Population Pyramid Chart in Excel.

Line Charts

A line chart typically shows values of a dependent variable on the vertical axis with an ordinal variable along the horizontal axis. The horizontal variable may be discrete (that is, measured only at specific instants, not continuously), but the connection of the data points typically implies something that can at least be thought of as if it were a continuous process.


Each line on a line chart consists of one data series.
image010.jpg

A line chart can show data markers or leave them out, depending on whether we are trying to emphasize individual points or the trend.

image006.png
image007.png
image008.png

Pie Charts

A pie chart is used to show the proportions or parts of something. The area of each slice of the pie is proportional to the share one data value represents vis a vis the total.

The data series for a pie chart must be mutually exclusive and exhaustive of a category or collection. Another way to think of this is that the values have to add up to 100%

Although popular (especially in USA Today 3D exploded view form) in popular media, pie charts are less than stellar tools of visual communication. The human eye/mind is not so good at comparing items of different shapes and less adept at perceiving area than length and we can mentally a set of objects by length better than we can order a set of slices by angle.1

Pie Chart Example

Let's consider what is good about this pie chart.

  1. The "whole" is easy to conceptualize.
  2. Ordering slices by region turns it into a highly abstracted world map.
  3. Color coding by region, using same colors with region names.
  4. Changing label font sizes relative to size of slices.
20080512031830!World_population_pie_chart.JPG


We can also do some interesting combination charts using Pie charts.

dual-career-pie-01.gif

How to make this chart with Excel
pie-with-bar-piece.gif

Scatter Plots

For a scatter plot, aka x-y plot, we use two data series at once. One defines the horizontal position of charted points, the other the vertical.


http://soc125ppol225.wikispot.org/Excel_Scatterplot


Sometimes it is hard to distinguish a scatter-plot from a line chart. Take this example where we have two sets of x-y data, both of which have the same X-values. Make sure you see this before you continue.

image011.jpg

Here we use the categories "fresh(woman)," "soph(omore)," etc. as x values because they correspond to first year, second year, and so on.

image009.png

Some Things to Pay Attention To (Chart Blogs and Other Usefuls)

Color!

"Junkcharts"

Indiemaps

"Small Multiples"

small_multiples.gifunemployment-rate-state-small-multiples1.pngsmall-mult.jpg

http://www.datasprout.org/site/?attachment_id=13

Resources

References

http://www.chartsgraphsdiagrams.com/
http://en.wikipedia.org/wiki/Category:Statistical_charts_and_diagrams
http://www.gapminder.org/videos/the-joy-of-stats/
http://www.gapminder.org
http://www.typesofgraphs.com/organizational.html
http://www.enchantedlearning.com/graphicorganizers/
http://processtrends.com/toc_excel_charts.htm
http://www.mindtools.com/pages/article/Charts_and_Diagrams.htm

Henry Mintzberg and Ludo Van der Heyden "Organigraphs: Drawing How Companies Really Workhttp://hbswk.hbs.edu/archive/898.html

[WWW]http://en.wikipedia.org/wiki/Logic_model

[WWW]http://www.cdc.gov/DHDSP/state_program/evaluation_guides/pdfs/logic_model.pdf

[WWW]http://www.innonet.org/client_docs/File/logic_model_workbook.pdf

[WWW]W.K. Kellogg Foundation Logic Model Development Guide

[WWW]http://uidaho.edu/extension/LogicModel.pdf

[WWW]http://en.wikipedia.org/wiki/Logic_model

[WWW]How to Develop a Logic Model for Districtwide Family Engagement Strategies

[WWW]Download a Worksheet from [WWW]http://www.shapingoutcomes.org/course/model/index.htm
Rhetorical functions in academic writing: Including charts and diagrams

22 Awesome Visualization Libraries: Charts and Diagrams

How-To's

http://www.wikihow.com/Use-Charts-and-Diagrams-in-OpenOffice.Org-Draw

http://www.r-chart.com/2010_07_01_archive.html

http://www.exceluser.com/explore/bullet.htm

http://www.juiceanalytics.com/chart-chooser/

Glossary