fbpx
Search
Close this search box.

Generate organization charts in excel – howto?

Share

Facebook
Twitter
LinkedIn

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.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

16 Responses to “Generate organization charts in excel – howto?”

  1. Rick says:

    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?

    Thanks!

    Rick

  2. Chandoo says:

    @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)

    Or

    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.

  3. tony says:

    Nice, very nice.
    Is there anyway I can save my org chart to an excel workbook on my pc?

  4. Chandoo says:

    @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.

  5. Tracy says:

    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?

  6. Chandoo says:

    @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.

  7. Lag says:

    Hi
    Thanks for the tip. Is it possible to add picture and/or Job Title. I tried in the spreadsheet without success ?

  8. Brandon says:

    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!!

  9. Keith says:

    How did you get the scroll bars on the google org chart, I have done one but cant get the scroll bars on?

    Keith 

  10. Thomas says:

    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.

    • Jerry says:

      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.

  11. Jagmohan says:

    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...

  12. worldwision says:

    A tool to create organization chart from Excel file:
    http://visualdaq.com/orgdoc/Organization-Chart-From-Excel.html

  13. Anny says:

    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

  14. Shalin says:

    What is the org chart software you used to create these diagrams?

Leave a Reply