Post election, I wanted to make some sankey diagrams. My usual data visualisation tools are Excel or Libre Calc and I don’t think they include this charting option, but I want to do it. Here are my unfinished notes …

2024

So I decided to have another go. Microsoft and Libre Office still don’t do it, so I had a look at what was there, preferring Excel because I am better with it. I found this article from Chartguide which points at poweruser.com which is not free. For my source collections, see Where did the votes come from? on this wiki.

I then looked at Tableau, they offer a free use, if you publish your charts.

  1. https://www.tableau.com/
  2. https://www.tableau.com/en-gb/products/desktop
  3. https://www.tableau.com/en-gb/community/public and https://public.tableau.com/app/discover
  4. How to build a sankey chart in tableau at tableau/community, which points at Tableau Chart Templates Part 1: Sankeys** ⭐ by the Flerlage twins, and which I am currently working on. It helped me make this, which could be better; I used their sales sample data which is on this page. The scale of the indexes is wrong, the hover is displaying too much.
  5. and How to build sankey diagram in tableau without data prep from the Information Lab which I have not yet read
  6. How to build a sankey chart in tableau by Alfred Chan at the data school; really? this is hard! I used this but may give up on Tableau.

2020

  1. How to make a sankey diagram in excel, by google
  2. Here’s an article on using Excel & VBA.
  3. A cloud based generator, needs investigating,
  4. as does this one, http://sankeymatic.com/
  5. A blog article on Microsoft’s Power BI blog about Sankey diagrams (I have done this twice before).
  6. And what google suggests foe Libre Office.
  7. Here’s a list at a site called Sankey Diagrams.
  8. And it seems, there’s always Tableau.

Quite a few articles point at “R”.

The Microsoft answer is Power BI,- here’s their Getting Started page, and is it free? This page suggests it might be … but then you may have to deal with a new DML.

Featured Image: from datascience-enthusiast.com/

2 Replies

  1. Sankey diagram is a very useful visualization to show the flow of data. Many people create using R or other tools which require you to do some or extensive coding. But ChartExpo provides you a better and easiest way to create the Sankey Diagram in no time without coding only on few clicks.

Leave a Reply to Imon Kearns Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.