Forum Discussion
tree hierarachy chart
- You'd need VBA for that. I found a discussion here: https://www.mrexcel.com/board/threads/using-vba-for-smart-art.554224/
But if you're OK with VBA, perhaps you need a more sophisticated implementation, like a treeview?
https://jkp-ads.com/articles/treeview.asp
This is sample of my data and suggested output
"Studiorum proposed draft structure
1. Home page
1.1 Data Standards
1.2 About
1.3 Acknowledgements
1.4 Search
2.1 Catalogues
2.1.1 Liber Studiorum (Finberg)
2.1.1.1 Frontispiece (82 at this level)
2.1.1.1.1 Etching (6 at this level)
2.1.1.1.1.1 Engraver (ca 20 at this level)
2.1.1.1.1.1.15 Digital image ref (ca 2 at this level)
2.1.1.1.2 1st state
2.1.1.2 Bridge and cows
2.1.2 Engraved Works (Rawlinson) (87 at this level)
2.1.2.1 The Copper plate Magazine (80 at this level)
2.1.2.1.1 Rochester (16 at this level)
2.1.2.2 The Pocket Magazine
2.1.2.2.1 The Tower of London (16 at this level)"
An example of the formatting of a tree (I cannot add a screen shot) is at
https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?mode=Undef&name=Eukaryota&lvl=3&srchmode=1&keep=1&unlock
Velson
Manchester05 Possibly you could use the Outline feature with Grouping. It isn't visually that same tree structure but it does create the grouping/tree branching and even allows you to expand and collapse sections to focus on different areas. In this thread I also posted a macro that can automatically create that grouping based on a list of tier levels if that helps:
https://techcommunity.microsoft.com/t5/excel/how-to-group-automatically-in-excel/m-p/3411297
I also created a macro that creates a vertical flow chart/tree structure (part of a safety assurance case I'm working on) based on a pivot table. It is a bit more complicated but does demonstrate feasibility:
That is actually only the 'top' level and all the bottom boxes link to other tabs with their additional branches. But based on your link I really think the Outline feature is much closed to what you need and more functional.
