Forum Discussion
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. 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
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
