Data Visualization

Recreating William Playfair’s Import/Export Charts

I’ve been reading William Playfair’s Commercial and Political Atlas, in which he invented the line chart. In the book, Playfair examines the imports and exports between Britain and various countries. To illustrate these trade relationships, Playfair created the first ever line charts that show the change in trade over time.

The Inspiration

Each section of the book covered a different country, and each one contained a chart that showed the imports and exports like this:

Two line series are shown, one for imports and one for exports, and shading is used to show when there was a “balance in favor of England” (when there were more exports than imports).

My Recreation

I’ve been captivated by these charts and wanted to recreate them, but with modern data. You can find tons of US trade data at the US Census Bureau’s website, including a spreadsheet that has all the data in one place. I downloaded that data and put together a little application to create Playfair-esque charts.

Click this screenshot to play with the app yourself:
View source is enabled.

The app displays all the countries that the US has trade data for, month by month going back as far as 1985. Each country is displayed in the list on the left with a sparkline chart of the trade data. A red fill indicates we are importing from a given country more than we are exporting, and a light green fill indicates we are exporting more than we are importing.

Exploring the data

The charts tell some really interesting stories. Some of the charts show a nearly identical relationship of imports to exports, both growing at the same rates, like these charts of the UK and Guatemala.

While some other charts show different relationships. Notice how exports to Hong Kong have been steadily increasing, but imports from Hong Kong have been declining.

Or we can see what imposing sanctions on a country looks like, as illustrated by sanctions on Burma that were put into place in 2003:

Or what a coup in Haiti looks like:

Or what a massive tsunami can do to a place like the Maldives:

We can see the massive growth of China (and notice how interestingly seasonal each year is, peaking in October):

And one final one that I find very interesting, isn’t a country, but the import and export of what is classified as “Advanced Technology Products“, which includes things like biotech and advanced electronics products. Notice how up until the early 2000s we were exporting more of these products than we were importing, but by 2002 that balance shifted and the gap continues to increase:

I had fun creating this app, but one thing I didn’t expect was how much fun researching the charts was going to be. The charts that stuck out with trends that were abnormal all had interesting stories to tell about the history of the country.

In closing, I’ll end with a quote from Playfair in which he describes the concept of displaying numeric values in a line chart (remember, he was the first person to actually do this):

As the eye is the best judge of proportion, being able to estimate it with more quickness and accuracy than any other of our organs, it follows, that wherever relative quantities are in question … this mode of representing it is peculiarly applicable; it gives a simple, accurate, and permanent idea, by giving form and shape to a number of separate ideas, which are otherwise abstract and unconnected.

Well said, Mr. Playfair, well said. Your charts are just as effective nearly 200 years later.


9 thoughts on “Recreating William Playfair’s Import/Export Charts

  1. Marc Baiges says:

    very nice adaptation, and great choice for the fonts!

    I jumped directly to the example without reading the post before… and couldn’t tell what data I was seeing.

    I mean, I understood it later when I read the post and saw it was from an US perspective, so green areas were positive balance for the US and red areas negatives, but otherwise, I wasn’t sure how to read the graph by itself.

    In the original chart there is no legend neither, but Playfair overlays the name of each series, what helps understanding it.

    Btw, I would never have said that Spain exported so much to US :-S


  2. Pingback: somerandomdude: Recreating William Playfair’s Import/Export Charts — Some Random Dude

  3. Pingback: Recreating William Playfair’s Import/Export Charts — Some Random Dude

  4. Pingback: Seeing Complexity

  5. Pingback: A short visual history of charts and graphs « Seeing Complexity

  6. Martin says:

    Nice work, came to this from your recent infinity chart.
    Speaking about these charts, those of Playfair’s are still easier to read than yours. 🙂 Mainly for two reasons:
    – data granularity – you are using sub-1 year precision when you axes are only 1 yr. I think they are two separate stories to tell – 1/ trade pattern year to year with some averaging being done, to smoothen the line and 2/ trade pattern over the course of a year.
    – clearer and in some cases direct labeling in Playfair’s charts.
    My 2c

  7. Pingback: History of Data Visualization « Data Visualization

Comments are closed.