Generate organization charts in excel – howto?
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.
Do you want to be awesome in Excel?
Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
Leave a Reply
|frAGILE software development||Do not disturb : I am scheduling a meeting|