Sankey diagrams direct from Excel – update

Being able to create Sankey Diagrams in D3 directly from Excel continues to be one of the most popular topics on the Excel Liberation site even though I first posted this a long time ago now.

As a result of some requests on our forum, I’ve added a new feature – the ability to add url links to either the nodes, or the paths between them (or both). Here’s a screenshot of a sankey example. Hovering over a link or a node shows where you’ll go if you click it.

You can specify where to find the links in your excel data in the Sankeyparameter sheet, which looks like this. The linkurl and nodeurl Items describe which data columns contain URLs for links and nodes respectively. If empty, then no links will be generated

A fragment of the data looks like this. If any cell is blank in the columns specified by the linkurl and nodeurl column, then no url will be available for that link or node.

And that’s it. Click the button to generate your Sankey, and play around with it as below.

You can download this from Excel liberation site (the cDataSet.xlsm workbook).

(function() {
var po = document.createElement(‘script’); po.type = ‘text/javascript’; po.async = true;
po.src = ‘https://apis.google.com/js/plusone.js’;
var s = document.getElementsByTagName(‘script’)[0]; s.parentNode.insertBefore(po, s);
})();

About brucemcp 224 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.

Be the first to comment

Leave a Reply

Your email address will not be published.


*