Oct 13 2019 01:10 AM - last edited on Nov 09 2023 11:10 AM by
Oct 13 2019 02:52 AM
@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
Oct 13 2019 10:16 AM
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.
Oct 13 2019 12:35 PM
It is possible to create diagrams from shapes using VBA but it is not for the faint-hearted.
May 09 2020 09:18 PM
Hi@Tom_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.
Jun 22 2021 05:59 AM
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://bit.ly/3iMJLX3
I hope it would fulfill your requirements.
All the best
Jul 06 2023 01:36 PM - last edited on Nov 08 2023 05:00 PM by Carlos Perez (O365)
Jul 06 2023 01:36 PM - last edited on Nov 08 2023 05:00 PM by Carlos Perez (O365)
@Tom_By Here are two 3rd party add-ins that support Sankey Diagram: The first is a complex data visualization tool: Ultimate Dashboard Tools for Excel.
Another great solution is the Power-user add-in. Both of them provide advanced charts and graphs for Excel.