Forum Discussion

Tom_Brasch's avatar
Tom_Brasch
Copper Contributor
Feb 15, 2023

Tree diagram / Hierarchy based on Excel Table

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. 

 

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

 

No RepliesBe the first to reply

Resources