Tuesday, January 26, 2016

How to Create Dynamic Organization Chart using Google Drive Spreadsheet.

An organizational chart (often called organization chart, org chart, organigram(me), or organogram) is a diagram that shows the structure of an organization and the relationships and relative ranks of its parts and positions/jobs.

Here we will demonstrate a simple method to create organization chart using Google Drive Spreadsheet.

Step 1: Sign-In to you Google Drive account and Create a new spreadsheet.

Step 2: Insert data into you spreadsheet:

To Insert data ensure that column A Is Employee and Column B is Manager, i.e. Column B should be the manager/supervisor name for the respective value in Column A and for the person who heads organization the respective Column B should be left blank as below as in our example Steven heads organization and doesn't reports to any other employee in the same organization.


Employee and Manager Name


Step 3: Click on Insert in Menu bar and then select Chart:

Chart Gadget


Step 4: Select the data range for which you want to create org chart, you can also keep Row 1 as row header:

Data Range

Step 5: Choose the relevant style for chart, click on Insert:

You will be able to see chart as shown in snap below, you can save it as a image, edit it. Also if you change the data in the excel sheet i.e. Manager employee relationship, the changes will be reflected in the chart created dynamically.

Final Chart Created.

You can view the Google spreadsheet created by us to demonstrate the process from Here.
Related Posts Plugin for WordPress, Blogger...