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.

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


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?


November 10, 2009
Alan said:

These are fantastic!

One change I would make is for the 'Dot Chart with Distribution,' at least if it's possible, would be an optional description or name for each plot point that would display when mousing over the plot point.


January 7, 2010
Rajiv said:

Thanks Zach-

I made some revisions:
-I turned the quartile plot into a true quartile plot by using lower error bars on the high and low data series. This had the added advantage of properly centering the dots.
-I tweaked the formatting on the dot chart with univariate distributions to reduce vibration on the axes.
-I tweaked the formatting on the column graph - reduced the line thicknesses.

I'd be happy to email the changes to you.


January 25, 2010
Anders said:

Great, thanks for sharing. The solutions are really elegant and simple to implement!

Your name

Email (optional, will not be shared)

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

Your comment


Add a comment