Forum Discussion
Data visualization from excel table: Tree diagram / Hierarchy
Dear Excel community I have a table in excel that contains information on different hierarchical levels (category, sub-category and sub-sub-category levels). I would now like to visualize the d...
One possible option is to create Sankey Diagram on this data. Sankey Diagram is usually used to visualize information across categories. Here is an example screenshot in Excel.
Its not built-in into Excel. I used a third party add-in which provide this chart in Excel.
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
Regards,
ScottJ.