Hello -
I'm looking for a way to generate a tree diagram in excel from data. My ideal would be to have one sheet which has the relationships between items defined with column headers "from" and "to" - this would describe all of the different objects, and relationships between them that I would want in the tree diagram - and one sheet that has the tree diagram on it.
What i'm looking for is a VBA that would use the relational data from the 'data' sheet, to auto-build a tree diagram on the 'tree chart' sheet.
See attached example workbook.
Thanks!
Jacob
Bookmarks