I saw a great blog post on Reshaping Horse Import/Export Data to Fit a Sankey Diagram from Tony Hirst a few minutes ago. In it he shows how to mashup various bits and pieces using scraperwiki, python and d3,js to create a nice sankey representation of EU/Horse import/export.
Since I have previously shown how to create sankey diagrams directly from excel, and also how to get data into Excel from ScraperWiki, I thought I’d just borrow his data, plug it in to excel and create the same sankey chart, except this time via Excel. (thank you Tony).
Here’s the results. You can download the cDataSet.xlsm workbook from the Excel Liberation site. The generated html file is here.