Zoomable d3.js partition charts straight from Excel

It’s been a while since I played around with d3.js. Previously I’ve covered Sankey diagrams, trees, force diagrams and a few others – all straight out of excel. A couple of suggestions on the Google Moderator suggestion area of the Excel Liberation site were asking for this capability to be applied to create zoomable partition charts like Mike Bostock’s example

Turns out this was just a a couple of minor tweaks on the d3tree capability. Here is an example screenshot visualizing some US census data against which presidents were born where.

and a live version for those whose browser supports it

You can download the example in the cdataset.xlsm workbook from the excel liberation site. The test data is in the d3zoompart worksheet and the options can be set in the d3treeparameters worksheet. You can get full information and the code for all this at the Excel Liberation site.

About brucemcp 225 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.


ten − 2 =