Home

Creating Sankey Diagrams

%3CLINGO-SUB%20id%3D%22lingo-sub-911024%22%20slang%3D%22en-US%22%3ECreating%20Sankey%20Diagrams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911024%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20anyone%20have%20any%20guides%20for%20creating%20Sankey%20Diagrams%20in%20Excel.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20deal%20with%20the%20analysis%20of%20a%20reasonably%20long%20process%20which%20has%20various%20customer%20inputs%20and%20outcomes.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20looking%20for%20a%20visual%20way%20to%20show%20everyone%20who%20came%20into%20the%20process%2C%20and%20what%20happened%20to%20each%20person.%3CBR%20%2F%3E%3CBR%20%2F%3ESankey%20Diagrams%20seem%20to%20fit%20that%20bill%20perfectly.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20help%20would%20be%20appreciated.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3E%3CBR%20%2F%3ET%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-911024%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-911064%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Sankey%20Diagrams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911064%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420814%22%20target%3D%22_blank%22%3E%40Tom_By%3C%2FA%3E%26nbsp%3B%20cant%20help%20directly%20in%20Excel%2C%20bit%20there%20is%20some%20guidance%20on%20doing%20Sankey%20in%20Visio%20(you%20could%20embed)%26nbsp%3B%3CFONT%3E%3CA%20href%3D%22http%3A%2F%2Fwww.visguy.com%2F2008%2F01%2F02%2Fsankey-diagram-shapes-for-visio%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.visguy.com%2F2008%2F01%2F02%2Fsankey-diagram-shapes-for-visio%2F%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-911253%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Sankey%20Diagrams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911253%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420814%22%20target%3D%22_blank%22%3E%40Tom_By%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20not%20out%20of%20the%20box%20for%20Excel%2C%20but%20you%20may%20find%20add-in(s)%20in%20Store%20or%20third-party%20solutions.%20It%20names%20as%20well%20as%20Data%20Flow%20chart%20is%20to%20search.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-911320%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Sankey%20Diagrams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911320%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420814%22%20target%3D%22_blank%22%3E%40Tom_By%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20possible%20to%20create%20diagrams%20from%20shapes%20using%20VBA%20but%20it%20is%20not%20for%20the%20faint-hearted.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Tom_By
Occasional Visitor
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
3 Replies

@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

@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 

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

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies