Forum Discussion
Creating Sankey Diagrams
Hi,
Does anyone have any guides for creating Sankey Diagrams in Excel.
I deal with the analysis of a reasonably long process which has various customer inputs and outcomes.
I am looking for a visual way to show everyone who came into the process, and what happened to each person.
Sankey Diagrams seem to fit that bill perfectly.
Any help would be appreciated.
Thanks
T
Does anyone have any guides for creating Sankey Diagrams in Excel.
I deal with the analysis of a reasonably long process which has various customer inputs and outcomes.
I am looking for a visual way to show everyone who came into the process, and what happened to each person.
Sankey Diagrams seem to fit that bill perfectly.
Any help would be appreciated.
Thanks
T
Hi Tom,
If you are looking for a Sankey diagram that fits the bill perfectly, I recommend using the Sankey Diagram by VisioChart for Excel.
https://appsource.microsoft.com/en-us/product/office/WA200007892
Hi Tom,
If you are looking for a Sankey diagram that fits the bill perfectly, I recommend using the Sankey Diagram by VisioChart for Excel.https://appsource.microsoft.com/en-us/product/office/WA200007892?tab=Overview
I hope it would fulfill your requirements.- Here is a solution: https://www.psawyer.de/blog/Sandkey/
Hi Tom_By
Hope you and your loved ones are doing well.
I totally agree with you that "Sankey Diagrams seem to fit that bill perfectly".
I would like to recommend "ChartExpo For Excel" add-in for Sankey diagram. Very easy to create chart and there is no coding (VBA) skill required.
ChartExpo for Excel Add-In: https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr
ChartExpo for Google Sheets Add-On:
https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr
For detail video: https://www.youtube.com/watch?v=DSt000BPhOg
I hope it would fulfill your requirements.
All the best
HiTom_By ,
To create Sankey diagrams in Excel, you will need to install an external add-in tool called Power-user. You can install it here - https://www.powerusersoftwares.com/. After installing the add-in, you will have to follow various steps as discussed here and that's it. It's very simple. Thanks.
It is possible to create diagrams from shapes using VBA but it is not for the faint-hearted.
That's not out of the box for Excel, but you may find add-in(s) in Store or third-party solutions. It names as well as Data Flow chart is to search.
Tom_By cant help directly in Excel, bit there is some guidance on doing Sankey in Visio (you could embed) http://www.visguy.com/2008/01/02/sankey-diagram-shapes-for-visio/
Ian
