Sometimes in SharePoint we need to visualize hierarchical data as organizational chart. Prerequisites: not to use Flash or Silverlight technologies here.
So, in our scenario for storage of organization structure will be used SharePoint List based on Custom List , for rendering engine Google Chart Tools.
Implementation
First, let’s take a look at list’s schema for storing organizational structure
| Name | Type | Description |
|---|---|---|
| ParentOrgElement | Lookup | Used for parent/child relationship |
| OrgDescription | Note | Display text for chart box |
| OrgAdditionalProperties | Note | Visual behavior for chart box |
From Google Charts library we’ll use Organizational Chart package only.
1. Google Charts Tools loading and package initialization
2. Fetch data using SharePoint Web Service from list that contains organizational structure
3. Bind data source and draw chart
Usage
Result page with Org Structure rendered as Chart in List View
Advertisements
Hi, thank you for article, but sometimes it is better to display data directly from Active Directory with actualized data. Plumsail Org Chart implements such behavior, it also supports drag&drop edit interface. http://plumsail.com/sharepoint-products/plumsailorgchart/
I’m not seeing how to implement this… what type of object do you send to visualizeOrgChart()? Where do you specify the list name and the columns?
Found some good org chart templates in creately diagram community. There are 1000s of organizational chart examples and templates in there to be used freely.