• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Organizational Charts

W

workforce

New Member
I need some ideas about how to create several departmental organizational charts on separate sheets that feed the data entered into them back to a master database spreadsheet/table is this possible or would it be very complicated?
 
Workforce,


Welcome to the forums, it depends, what is the size of the organization you are dealing with?


Faseeh
 
800 employees but the org charts will be broken up into sites for which the max number of individuals might be something like30, sites range from 6-30 employees
 
You can add shapes and then link then to the cells that contains site-wise names but again that will be hectic. its up to you if you can do that.
 
Yeah that seems like alot of work haha.... but how do you go about that so I can play around with it and see if it would work.
 
Have you looked at using the Microsoft Org Chart addin?

http://office.microsoft.com/en-001/excel-help/open-the-organization-chart-add-in-for-microsoft-office-programs-HA010120847.aspx


or Microsft Visio

http://office.microsoft.com/en-001/visio-help/whats-new-in-visio-HA102749364.aspx


or Google

http://chandoo.org/wp/2008/04/15/generate-organization-charts-in-excel-howto/
 
You must log in or register to reply here.
Back
Top