1 of 1 people found this helpful
A Sankey might make sense for this data. Have you tried the approach outlined by Ian Baldwin that you included above? His is a great approach as it allows you to create a sankey without restructuring your data ahead of time. If restructuring is an option, then take a look at a recent post of mine which provides a relatively simple template for creating a sankey: Chart Templates Part 1: Sankeys - Ken Flerlage: Analytics Architecture, Strategy, & Visualization. I threw your sample data into the template and got the following. I've attached the workbook and Excel file.
If this assists in resolving your question, please mark my response as the 'correct answer'. This will help other users with similar questions. Thanks!
This is awesome! I'll be trying to recreate what you just did using those instructions. Great tool, thanks a lot!