Forum Discussion
Manchester05
Oct 11, 2023Copper Contributor
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...
- Oct 12, 2023You'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
JKPieterse
Oct 12, 2023Silver Contributor
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
Manchester05
Oct 12, 2023Copper Contributor
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
Thank you
Velson