Tufte Charts in Excel

A reader wrote in to suggest a couple of useful blog topics. His first idea was for us to create...

A set of working examples in Excel of the graph types Edward Tufte recommends in “Visual Display of Quantitative Information”

The closest anyone has come in Excel, as far as I can make out is the tease that William Oswald left on http://www.compassgr.com/sites/mark/index.htm. Here he has included pictures of the output, but not the files themselves.

Here are a couple examples from Oswald's site:

Column with Overlay

Dot Chart with Distribution

It's hard to back down from a challenge like that—so we set about to create an Excel spreadsheet with working replicas of the Oswald replicas of Tufte charts. For the most part, the resulting charts are straightforward to manipulate and represent a massive leap forward from the Excel ordinary. Download the file, change the data and make them your own.

TufteChartsbyJuice.xls

A couple of my favorites :

Multi-series Scatterplot

Line Chart with Period Shading

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License. All source code is released under a BSD License unless otherwise specified.

11 comments | Show all comments only the last 5 are shown


August 31, 2006
Will Oswald said:

I came across this site as a link through from the Edward Tufte site. As I offered on the Ask E.T. bulletin board, if anyone is interested in the Excel version of the charts you've shown here, I'd be more than happy to send them through. Great idea, by the way, on the use of the REPT function - I'll be using that a lot more!


September 11, 2006
Al said:

I'm glad I stumbled into this site today. I think my excel charts will look much better from here on in. There are some great ideas here.

For a minimalist quartile plot that highlights the inner quartile, try using solid lines for the inner quartile error bars and dashed lines for the outer quartile error bars. (If you need painstaking precision, you'll may want to put in a 2pt dash marker on the upper and lower quartile datapoints so that you can tell where the line ends and the dashed line begins.)

I had first tried making the inner quartile a bolder line, but didn't like how it thickened the line to one side only. The dash-to-solid line is much less distracting.


September 12, 2006
Zach said:

Al,

I like your approach. Do you want to send me your revision and I can add it to the downloadable file?


November 23, 2006
Nishant said:

Hi,
its gr8 to see all u knowledgeable souls talking to each other. But for lesser mortals like me, can someone tell me how these charts have been made? I tried to tinckle with the excel provided here but still cud not understand how to make them. I know i can just replace the data in these files. But i want to learn how to make these.


January 22, 2008
Skytte said:

Has the sparkline fad faded?

Your name

Email (optional, will not be shared)

Type the word "juice" (required to confuse the spammers)

Your comment


Add a comment