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
- Thank you for your interest.
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
VelsonManchester05 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.
Manchester05 Does the attached come close? It was created using Insert, SmartArt, horizontal hierarchy.
You change the level of an item by using Tab (indent) or Shift-tab (outdent)
Thank you. I was out at meetings yesterday.
The Smart looks useful, the Art is fairly redundant.
As far as I can see from the Smart Art help page, all the text needs to be typed into the text pane.
However, I am editing the databases daily (with > 2 million data points) which I should like the hierarchy to reflect.
Can the smart art tool import live data from, say, a spreadsheet? If so, what format and links does that database need to have?
Velson
