Forum Discussion
Tom_Brasch
Feb 20, 2023Copper Contributor
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...
HansVogelaar
Feb 20, 2023MVP
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.
- CJ_McColloughSep 19, 2024Copper Contributor
HansVogelaar - Example one is exactly what I need. How do I get there with Excel 365? Any help would be greatly appreciated! ❤️
CJ
- HansVogelaarSep 19, 2024MVP
As far as I know, it should work in Excel 365. Do you have a specific problem?
- CJ_McColloughSep 19, 2024Copper Contributor
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.