Here is a ridiculously simple workaround for those of you trying to generate an organization chart in excel:
Use google org. chart widget instead 🙂
[If you are reading this in a feedreader this post may not display properly, visit the post page instead.]
Open a new google docs spreadsheet (or work on the example organization chart spreadsheet I have created) and enter your organization employee data in the format shown below: (enter employee name in column 1 and manager name in column 2)
Create a organization chart gadget (menu > gadget > organization chart “add to sheet”), once done, the org chart should look something like this:
Its very easy to do and saves you a lot of time. If you need some example you can access the organization chart spreadsheet I have created.