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.
16 Responses to “Generate organization charts in excel – howto?”
Hello, thanks for the org chart tip. The Google Gadget does EXACTLY what I want to do in creating an org chart (use datasheet). However, I need to be able to transfer the completed chart to MSPowerpoint. When I attempt to Copy/Paste, the formatting doesn't make the trip. Can you provide suggestion on how to sucessfully interface between the Google org chart gadget and MSPowerpoint?
@Rick. Since GDocs is a web based software and ppt is desktop, formatting inconsistencies are bound to happen. There are however few ways to avoid this:
1. Publish your gadget as an image and use this image in your ppt. (just explore the publishing options)
2. Take a screen capture of your org. chart and crop the area. This is simple and fast. Since things like org. charts dont change so fast (hopefully) you can get away with this solution.
Let me know if you need further help. I can send out a SOS call to other readers.
Nice, very nice.
Is there anyway I can save my org chart to an excel workbook on my pc?
@Tony, Welcome to PHD and thanks for your comments.
One simple way to save the org chart is exporting your chart gadget in google docs as an image and then inserting that in excel. This is simple and whenever you change the data in gdocs, the image will be updated. So you just need to refresh the image in excel.
Since org. charts dont change often (hopefully) you can make do with this solution.
How would you ad an admin or add a name that's a 1/2 step below someone, not quite in line with the others?
@Tracy.. unfortunately, I dont think google provides a way to do this. (may be I am wrong). But you can use Office SmartArt feature to create org charts where this is possible. I think using smartart organization charts is better because they can be formatted etc.
Thanks for the tip. Is it possible to add picture and/or Job Title. I tried in the spreadsheet without success ?
is there ANY way to do something similar within MS Word?! I suspect my employer would not want this data stored outside of our intranet, but its such an easy way to keep track of everything!!
How did you get the scroll bars on the google org chart, I have done one but cant get the scroll bars on?
Make the Org Chart Object smaller than the Org Charts contents
This is really cool, but unfortunately there is no way in #$^ corporate IT will let us use Google docs. It's not on the approved list. Anyone got any ideas... such a simple thing to automate ought to have a solution. Keep reading about Visio but that isn't approved either.
I do believe there are couple of applications for sale in excel that can do similar staff. if you google using 'excel automatic org chart generator', you'll get couple of results.
hi chandoo, your website is amazing, l am too inspired.... thank you. well i created a file to generate organization chart in excel and create a weblog just to share the same... idea is not as smart as the one with google, but saves lot of time. i did all this in excel 2010, i am hopeful that this would even work on excel 2007, check the same here
http://xlmix.blogspot.in/ and suggest what you think...
A tool to create organization chart from Excel file:
I have a complete data branch wise and I need to automatically generate organograms for every branch. Can some one help me with the same.
Thanks in advance
What is the org chart software you used to create these diagrams?