Forum Discussion
Solved
tree hierarachy chart
I want to create an hierarchy chart, comparable to the 1752 version below. I have a growing collection of data points which can each categorised into an hierarchy position and level. Is there a too...
- 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
Velson
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 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
- 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- I am very grateful sharing for your wealth of knowledge. It looks as though I need to go off-line for an intensive sharp learning curve of VBA, before my spreadsheets become too difficult to re-jig to link efficiently with the VBA methods.
Thank you
Velson