Forum Discussion

Tom_Brasch's avatar
Tom_Brasch
Copper Contributor
Feb 20, 2023

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 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

 

 

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. 

 

 

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

Resources