Creating Sankey Diagrams

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.

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 https://mychartguide.com/how-to-draw-sankey-diagram-in-excel/ and that's it. It's very simple. Thanks.

Tom_By 

It is possible to create diagrams from shapes using VBA but it is not for the faint-hearted.

Tom_By 

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