An organization chart (often referred to as a “site org chart” in EPC contracts) visually represents the structure of a company or group, showing roles, relationships, and hierarchies. With minimal effort, you can create an organisation chart in Google Sheets. This tutorial will guide you through formatting your data correctly to generate the chart seamlessly.
What Is a Site Organisation Chart?
A site organisational chart is essentially a regular organisation chart but tailored for construction or project sites. The chart structure reflects the site’s hierarchy, such as a project manager at the top, followed by managers, site in-charges, safety officers, planning engineers, and so on. The difference lies in the designations of the employees, not in the process of creating the chart.
Having worked with EPC companies, I have experience preparing these charts. In the past, I used Excel’s drawing tools to create them manually. While effective, they weren’t flexible. Any changes, like adding or removing an employee, required rearranging all the text boxes manually.
In contrast, Google Sheets allows you to create and update site organisation charts effortlessly without relying on drawing tools.
The Four Steps to Create an Organisation Chart in Google Sheets
Here’s how you can create an organisation chart in just a few steps:
- Enter Employee Data
- In Column A, list the names of employees along with their designations in brackets.
- In Column B, enter the names of their immediate supervisors (reporting officers) with designations in brackets.
- Select Your Data
- Highlight the data you’ve entered in columns A and B.
- Insert the Chart
- Go to the menu Insert > Chart.
- Choose Organisational Chart
- In the Chart editor, select Organisational Chart.
Data Formatting Example
Properly formatted data is key to creating an effective organisation chart. Here’s an example:
In this example:
- Alfredo, the project manager, doesn’t report to anyone, so Column B for Alfredo is left blank.
- Maria reports to Alfredo, so Alfredo’s name appears in Column B for Maria.
- Similarly, other employees like David, Sam, and Anne report to Maria.
Plotting the Chart
- Once your data is formatted (e.g., in A1:B14), select it.
- Navigate to Insert > Chart.
- In the Chart editor, select Organisational Chart as the chart type.
- Your chart will now display the hierarchy based on your data.
Organisation Chart Customization Options
Unlike other chart types, organisation charts offer limited customization options. However, you can make a few adjustments using the Customize tab in the Chart editor:
- Node Size
- Change the size of the rectangular nodes to Small, Medium, or Large using the Chart editor.
- Node Colors
- Customize the background color of the nodes or the color of the active/selected node.
Tips and Best Practices
- Always include designations in brackets for clarity.
- Ensure the hierarchy is accurate by correctly assigning reporting officers in Column B.
- Update the chart easily by modifying your data—Google Sheets automatically adjusts the chart.