{"id":4738,"date":"2020-01-24T19:17:22","date_gmt":"2020-01-24T19:17:22","guid":{"rendered":"http:\/\/wiki.davelevy.info\/?p=4738"},"modified":"2024-08-15T09:33:25","modified_gmt":"2024-08-15T09:33:25","slug":"sankey-diagrams","status":"publish","type":"post","link":"https:\/\/davelevy.info\/wiki\/sankey-diagrams\/","title":{"rendered":"Sankey diagrams"},"content":{"rendered":"\n

Post election, I wanted to make some sankey diagrams<\/a>. 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 … <\/p>\n\n\n\n\n\n\n\n

2024<\/h3>\n\n\n\n

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 <\/a>from Chartguide which points at poweruser.com<\/a> which is not free. For my source collections, see Where did the votes come from?<\/a> on this wiki.<\/p>\n\n\n\n

I then looked at Tableau, they offer a free use, if you publish your charts. <\/p>\n\n\n\n

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

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

      Quite a few articles point at “R”.<\/p>\n\n\n\n

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

      Featured Image<\/strong>: from datascience-enthusiast.com\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

      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 …<\/p>\n","protected":false},"author":1,"featured_media":4740,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_share_on_mastodon":"0"},"categories":[27,3],"tags":[1037,1391,911],"class_list":["post-4738","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software","category-technology","tag-data-visualisation","tag-sankey-diagrams","tag-technology"],"share_on_mastodon":{"url":"https:\/\/mastodon.social\/@davelevy_eu\/112825033132824410","error":""},"jetpack_featured_media_url":"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2020\/01\/sankey.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/4738","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/comments?post=4738"}],"version-history":[{"count":9,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/4738\/revisions"}],"predecessor-version":[{"id":11308,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/4738\/revisions\/11308"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media\/4740"}],"wp:attachment":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media?parent=4738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/categories?post=4738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/tags?post=4738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}