Create org chart in Excel like Visio

[FryGirl]

I just switched jobs and used Visio combined with Excel to make organization charts.

Well of course I no longer have access to Visio nor does it look like I can get it.

Anybody know of a way to do the same thing in Excel probably through VBA?

I don't have Visio here at home, but what I remember, one column holds the titles for the boxes and the other column has the hierarchy structure.

 

[StephenCrump]

Craig Hatmaker has just answered your prayers. Check this out:

https://sites.google.com/site/beyondexcel/project-updates

 

[FryGirl]

Yes, that looks promising, however, not going to be able to install an add-in on a work computer.

 

[StephenCrump]

You don't have to run it as an add-in.

As long as you can use VBA at work(?) you can adapt the code to your own workbook.