SAS Learning Post

How to ‘stack the deck’ for a better graph!

To stack the deck means to cheat or to fix something so a desired outcome is achieved. This term originated in card games, but can also be applied to other things. And here, I apply it (both metaphorically and literally) to creating a better graph!

I recently saw the following graph created by NPR. It was an interesting topic, and a nice clean-looking simple graph, which made me like it. The title indicated that the graph showed “the decline of farming jobs, and the rise of everything else,” and when I looked at the graph, the white collar, blue collar, and services jobs did indeed appear to be increasing (look at the ‘slope’ of their areas in the graph – they all point dramatically towards the top/right corner).

SAS graph, SAS Tutorials and Materials

But upon closer examination, I noticed a problem. The percent of blue collar jobs had actually been decreasing quite a bit in the last few decades, rather than increasing. And that fact was disguised by the way NPR’s graph was laid out – it sort of creates the illusion that blue collar jobs (the blue area) was increasing. I decided to try my hand (no pun intended!) at creating a better graph, using SAS software!

When it comes to stacked graphs, the stacking order can be very important (this is where the ‘stacking the deck’ analogy comes in). Just like stacking a deck of cards, you can cleverly arrange your stacked bar chart to help guarantee it will achieve the desired outcome.

By default, SAS stacks the bar segments alphabetically, but with a little bit of programming you can take complete control over the stacking order. I like to arrange the stacking order such that the things that hold constant over time have basically horizontal color bands, and the things that are changing over time have a slope to them. This takes quite a bit of trial-and-error (and studying your data) to determine the best stacking order so that “the desired outcome is achieved” when users look at your graph. Here’s the layout I finally came up with:

SAS graph, SAS Tutorials and Materials

Here are a few of the changes/improvements over the original graph:

  • You can more easily tell that blue collar jobs decreased over time, rather than increase.
  • Breaking the footnote items into separate lines, and color-coding them to match the graph, make them easier to read.
  • The horizontal reference lines make it easier to detect smaller changes over time.
  • The ‘missing’ data for 1890 is more obvious.

A stacked bar chart is fine for showing the shifts in jobs over the decades, but I also wanted an easy way to compare them. For example, where there more blue collar, or service jobs, in 2010? Using overlaid lines (rather than a stacked chart) would make that much easier. Therefore I created the following:

SAS graph, SAS Tutorials and Materials

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s