Excel Tree Diagram from Data Using VBA

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