Data visualization from excel table: Tree diagram / Hierarchy

Copper Contributor
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 data in a more digestable way, ideally in a treemap, where I can see the hierarchy more easily.

 

Snapshot extract of my data:

Leftmost column = Category

Middle column = Sub-Category

Right colum = Sub-Sub-Category

Tom_Brasch_0-1676877826512.png

 

 

Ideally I want to create a visualization like the one below (illustrative) where my data from the table can be shown similar to this with same logic, category, sub-category, sub-sub-category. 

Tom_Brasch_1-1676877826358.png

 

 

Do you have any ideas on how to do that (ideally not manually typing in everything myself, but creating a visualization automatically based on selected data)?

 

Best and thanks already for the support🙂

 

Thomas

7 Replies

@Tom_Brasch 

One option (Windows only, 32-bit Office only) is a TreeView control. See the attached workbook.

You'll have to allow macros when you open it.

 

Another option would be a SmartArt diagram.

@Tom_Brasch 

And here is a solution using SmartArt.

@Tom_Brasch 

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.

 

ScottJBrown_0-1686903775898.png

Its not built-in into Excel. I used a third party add-in which provide this chart in Excel.

 

Regards,

ScottJ.

@HansVogelaar  - Example one is exactly what I need. How do I get there with Excel 365? Any help would be greatly appreciated! ❤️

 

CJ

@CJ_McCollough 

As far as I know, it should work in Excel 365. Do you have a specific problem?

@HansVogelaar 

thx for the swift reply. It looks like the treeview option isn't possible with the 64 bit. I guess I'll have to keep looking.