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.
Introducing our Online Power BI Class:
Would you like to join me on a date with Power BI? In this comprehensive online class, learn all about Power BI so you can create beautiful, insightful & interactive reports. Join me and rest of the play mates for our first ever Power BI Play Date.Click here to know more and join us.
Leave a Reply
|frAGILE software development||Do not disturb : I am scheduling a meeting|