Matrix to Tree Diagram.xlsx
Hi. I'm hoping someone can help me with figuring out how to convert a 5-column matrix spreadsheet into a tree diagram. I've attached an example of the format for our spreadsheet. There is a main category and 4 potential sub-categories. I've looked into this, and it seems to be along the lines of an org chart type thing, but I can't seem to figure out how to set up the spreadsheet, or if I can just take what's there and do what I need. This spreadsheet will be updated fairly often, so I'll want to be able to convert it to a tree diagram pretty much at will. Is there an embedded Excel feature that might do this that I'm not aware of, or would this possibly take a VBA approach to complete? Thanks for any advice.
Frank
Bookmarks