How to Make a SANKEY diagram for Free (Step-by-Step)
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- In this video you'll learn how to make a Sankey diagram from scratch, for FREE, even if you never coded before.
If you want to know more about what is a Sankey diagram see this video before ( • What is a SANKEY diagr... )
To make the Sankey diagram, I use www.sankeymati...
If you want to be able to feed information on SankeyMatic through GoogleSheets you can use this template: docs.google.co...
I hope you'll find this video useful. Don't forget to like this video and subscribe to our channel for more videos.
#sankey #sankeydiagram #datavizualisation #sankeychart
-------------------------------------------------------------------------------------------------
💻 For more information about Metabolism of Cities (visit metabolismofcit...) and make sure to subscribe to our newsletter 📧 metabolismofci...
🎓 Take one of our online courses on Urban Metabolism 👨🎓👩🎓(education.meta...)
📊 Have a look at our Metabolism of Cities Data Hub - for all data about urban resource use and pollution flows 💡🚿🏭🚚🚂🍏♻️ (data.metabolis...)
📌 Subscibe to our TH-cam channel for more videos on Urban Metabolism
📌Follow us on Twitter - / citymetabolism
📌Follow us on Instagram - / metabolismofcities
📌Follow us on LinkedIn - / 18773645
#urbanmetabolism #materialflowanalysis #circulareconomy
That's really one of the best explanations of how to make a Sankey! Thank's a lot! Nice Job! 😁👍
Thank you so much! This is so helpful, currently, I am doing my master thesis about plastic recycling and your video helped me out of desperation how to visualize my data better for my supervisor 😄 Best of luck for you and wish me luck for my master thesis
Thanks for your comment Mylla. Glad this helps. Fingers crossed for your thesis🤞
Thanks so much for the helpful tutorial, it saved after long struggles with R
This was a very helpful tutorial, thx! I would be interested to see a follow up to this on how to finalise Sankey with Adobe Illustrator or related program. I liked those isometric graphics of London in particular in other video.
Many thanks Sakari! Good point. Ok this will go on the list for future videos.
Sankeymatic seems like a great tool. I think it will save me the money I was planning to expend in e!Sankey. Thank you very much
Nice to hear that you found it helpful Patricio. There are plenty of great tools out there (rawgraphs.io/ is another one) that are free to be honest. Good luck on your Sankey endeavours.
@@MetabolismofCities Awesome. Thanks again and keep up the great work with the channel and webpage!
@@patricion.3607 🙏 thank you for your kind comment. Do share your Sankeys when you're done.
I found this VERY helpful. It took me a bit to find the proper name to the SANKEY or flow diagram. I started by searching images for “ribbon graphs”…. Eventually I got here and you have a new subscriber ! I can’t wait to put it in use, my use case as a finance person is to explain P&L to non-finance people.
Thank you Signal. Yes indeed hard to find it. Another way to call it is alluvial graph. Glad to hear that it will be useful in your work
Thanky you. Had a really hard time finding a software for a simple creation of sankey diagram without much effort.
Amazing tool. Material flows are a very interesting topic to guide intervention points where local governments can vary management option scenarios! Sankey diagrams helps with this easy visualization - a picture is worth a thousand words…
Thanks Aubrey! We have another video on Material Flow Analysis if you're interested th-cam.com/video/UNuXWhFAJTc/w-d-xo.html
Just dropping a line to thank you for your tutorial. Very interesting indeed
Many thanks!!
Hsve used sankeymatic a few times, but today found out some limitations. I don't think you can have more than four nodes in series. It throws up a "text not recognised" error.
Thank you so much for explaining and sharing your google spreadsheet 🙏🙏🙏
Glad it was helpful!
This easy to follow and works well. great video and thanks for sharing!
Metabolism of Cities, can you give me a quick comparison of Google Sheets to the latest version of Microsoft Excel? Many thanks for an excellent video.
How about creating a Sankey TV App with an M3U8...
Thank you for the clear examples of tools and how to build a Sankey diagram. Very Helpful! :)
Thanks for your comment Shaun! Glad that it was helpful!
Hi this is so helpful!! Thankyou for such a detailed tutorial!
Hi, very glad you found this helpful! Enjoy making Sankey diagrams!
Thank you, found this very helpful. Was always curious how these charts were made.
What could we do to have SankeyMATIC supporting circular mass flows? Now any circular flows go towards the output side of the node. I would rather see them at the input side of the node...
Unfortunately, this is a downside of SankeyMatic, it can't do circular flows. You can try to contact its creator for some help (I think this feature is in the pipeline but don't know when this would be available).
Really, really helpful. Thank you so much for your good teaching !
Thanks for the great explanation you have made
Hi sorry do you know if it is possible to not have the number if all are [1] ?
Thank you so much for such a helpful tutorial.
You're very welcome! Glad it helped!
Excellent presentation, thank you
Just awesome - Thank you!
Thanks for the great videos! Came here after seeing the What is a sankey Diagram video? I'm currently working on a project to visualize energy flows where they use Sankey Diagrams and I'd never heard of them. They're quite confusing to a layperson who's never seen one before or have little knowledge on the subject! Your videos really helped clear it up.
One question I had was more general to Sankey diagrams, rather than building it in SankeyMATIC, but I'd love to know if it's possible to do it in the software. I found it confusing that the nodes aren't labelled aside from what the specific one is. For example when you spoke about imported and natural resources, those nodes are describing how energy is collected (in-country or out of country). Or when listing housing, taxes, etc. Those are your costs. Same with "gold, silver, copper" those would be materials.
Is there a way to add these category labels for the group of nodes? I feel this would improve user experience to give an idea of what we're talking about at each node stage. Do you agree? I'd love to hear your thoughts.
Another quick question is about units that the flows are measured in. Is there a way to show the unit somewhere? Eg. money and currency, energy, weight, etc.
Thanks for such a great video! Looking forward to learning more
Super helpful. Thank you so much for this tutorial.
So helpful, thank you very much!
Thanks Gabrielle, very glad it was helpful! Hope that you will be able to do your own Sankey diagrams.
Hello, this is very useful - Do you know if Power BI could create circular flows like ifu's e-sankey? Many thanks!!
Many thanks. Not sure about Power BI, not a big user.
Fabulous Video!!! You are a live saver.
Glad it helped!
A big thank you!
Our pleasure! Hope you're going to have fun doing you own Sankeys.
thanksss a lot! this is so helpful!!
Thanks Kristina. Glad it helped!
This is helpful.Thanks for such a detailed tutorial~
Great to hear it is helpful!
Thank you, very helpful!
Glad it was helpful!
Thank you. Very useful. However, there is an issue that Sankey diagrams adds everything if the names of the nodes appear twice. For example: IF i have to look at death rate in each London, East Midland, West Midlands and so on, the death rate is added. Is there a way to avoid that please
Thanks Nitin! Yes, indeed that is a problem with SankeyMatic it cannot make circular flows. However you can reuse the same nodes (as destination and not targets), if you for instance use a small symbol before or after. For instance write London_In and London_Out. You can then click on remove the labels and add them in another software (for instance ppt).
Thank you for a great tutorial!
@Charles Kuhn Glad you enjoyed it. Hope it will help you in your future endeavours.
Thank you. I do also like the software you prepared your tutorial with, what's the name?
Must be Excel :)
Very helpful!!
Many thanks Ebbie!
Thank you for the video, do you know how to control the order of the nodes?
Hi Kimberly, thanks for your comment. The order seems indeed quite random. You can reorder them by dragging them to a higher or lower position (some patience is needed). Be careful though, only do this once you have finished inputting the data and previewing the diagram (else the nodes will be rearranged and you will have to start all over). Hope this helps
@@MetabolismofCities thank you!
Πολύ καλος!!
Can it be automated that the remaining money goes to savings?
It would be possible but not through this software. You would need to code this (for instance python) and have the variable savings be automatically measured based on the other variables and then plot it. There are some nice libraries to plot Sankey diagrams in python
@@MetabolismofCities thanks! Just searching for phyton library Sankey?
@@johannes21e6 you can have a look at this one for instance plotly.com/python/sankey-diagram/ (else for simple Sankeys seaborn library might be enough)
Thank you very much! (How?) is it possible to build subcategories e.g. under hobbies?
Problem solved! :-)
@@Sciencefriend Good to hear! Did you just add Hobbies [ x ] Hobby 1 ; Hobbies [ x ] Hobby 2 ; etc. ?
@@MetabolismofCities Yes, I thought so. However, it still doesn't quite work out. Let's say I have an income. The income splits into taxes and net. With net again a branch goes away for example in cars. This should then branch out again to the right in the graph into Car 1, Car 2, Car 3. I can't get the split in the graph to open to the RIGHT. I always get car 1 to car three on the left side. Idea? What am I doing wrong?
thx a lot
Hmm let's see so here is the code we would propose, does that work?
Income [1000] Net
Income [250] Taxes
Net [400] Car 1
Net [400] Car 2
Net [200] Car 3