« Designers fuss over little details and so should you | Main | Graphical forms impose assumptions on the data »

Comments

Ken

Spatial works fairly well, but I would try alternatives and compare. I find it difficult to decide until you've seen it in real life.

I would try states as rows with columns for each of the 4 outcomes then use the same colour scheme. Ordering of columns may not matter but trying the ones with most yellow first may work best. Then order states by either alphabetical or by difference in number of orange and green outcomes, which is probably better. Would be interesting to see how this was done in R.

Adam Schwartz

It seems to me, that map or no map isn't so much the issue as is how I'd expect the state to have acted given what I know about the state's liberal/conservative bent. The response to exective action map, being mostly filled in, looks a great deal like a map of red states/blue states would look.

Knowing the expectation of behavior, it makes TX, NE, and KS stand out on the "offers in-state tuition" chart. So, I think I'd like to see a display mechanism which adjusts for the delta. Does this tell us anything about motivation - states that don't hold the child accountable for the parent's actions, perhaps??? Pure speculation on my part.

I suspect the other option has to do with size of population impacted. A harsh policy in a populous state (having little to do with landmass) has more potential negative impacts than in a less populous state.

Either way, the map itself seems like a geography lesson.

Chris Pudney

Not a direct answer but by coincidence the NYT published these "maps" visualizing gay marriage state-by-state:

http://www.nytimes.com/interactive/2015/03/04/us/gay-marriage-state-by-state.html

I particularly like this treatment as it removes the distortion arising from states of different sizes while retaining a measure of geographical coherence.

Whether it's appropriate in the case of the illegal immigration example is another matter.

Ahmed

can anyone recommend a free tool to create data maps? aka similar to excel power maps but for those who are on excel 2007?

junkcharts

Thanks for the suggestions, and keep them coming. The reason this is a nice exercise is that there are arguments for both. In addition, there are some creative ways and like Ken said, you really can't compare unless you have sketched alternatives.
Chris: that's a nice one, thanks for the link.
Ahmed: are you specifically wanting to do this within Excel?

Jmkeuning

"can anyone recommend a free tool to create data maps? aka similar to excel power maps but for those who are on excel 2007?"

Try Tableau Public
http://www.tableau.com/public/

The comments to this entry are closed.

Kaiser Fung. Business analytics and data visualization expert. Author and Speaker.
Visit my website. Follow my Twitter. See my articles at Daily Beast, 538, HBR.

See my Youtube and Flickr.

Book Blog



Link to junkcharts

Graphics design by Amanda Lee

The Read



Keep in Touch

follow me on Twitter

Residues