How to Create Site Organisation Chart in Google Sheets

With minimum effort, you can create a Site Organisation Chart in Google Sheets. For that, you need to learn how to format the data to plot it.

You should enter the name of employees in one column and their immediate bosses’ names in the next column.

Then select this data and click on Chart under the Insert menu.

That’s all you want to do to create Site Org Chart in Google Sheets.

Organisational Chart Vs. Site Organisational Chart

Site Organisational Chart is a regular Org. Chart. There is no difference in chart creation.

The changes are in the Chart Node structure, or you can say in the hierarchy.

It’s like a Project manager as the head, then followed by the manager, and under the manager comes site in-charge, safety officers, planning engineers, etc.

That means the only changes are in the designation of employees.

The Chart creation in Google Sheets is automated.

As I have already mentioned, you should learn to format the data correctly, and that you can learn with the help of this Google Sheets tutorial.

Sample Site Org Chart in Google Sheets

Why Should One Consider Google Sheets for Creating Organisational Charts?

In my experience, Google Sheets is one of the best free tools to create a site organization chart.

I’ve worked several years in Construction Sites as part of different projects.

On every site office, we should display the site org chart. It was mandatory as per the Work Order clause.

During that time, I had prepared site organization charts in Excel, using the Excel drawing tools.

It was easy to prepare but not flexible.

I mean, if we want to add or remove an employee from the chart, we may require to arrange the entire boxes again.

In Google Sheets, without using the drawing tool, you can easily create a Site Organisation Chart.

Here is how.

The Four Steps to Create Site Organisation Chart in Google Sheets

I am taking you straightaway to the steps.

  1. Enter the name of the employees in column A.
  2. Then enter the name of their immediate reporting officers or bosses and their designations within brackets in column B.
  3. Select the entered data and then go to the menu Insert > Chart.
  4. Choose Organisational Chart.

That’s all!

Data Formatting in Detail

You should enter the names in two columns as below.

Sample Data for Site Organisational chart

For example, in cell A2 the employee is “Maria,” whose designation is Manager. Her reporting officer or boss is “Alfredo,” and his designation is Project Manager.

So I’ve entered Alfredo’s name in cell B2.

The same is the case with other employees.

Plotting the Chart

Just select the data, here it is in A1:B14, and insert the chart from the Insert menu.

Select the Organisational chart in the Chart editor, and voila!

Org Chart in Google Sheets Insert Menu

The key in this chart creation is how you arrange/format your data.

The ideal way is first to enter the name of the employees, whose name should appear in the Company Organisation chart, in Column A.

Then enter the name of their immediate superior in the next column and which should form the organizational structure.

I suggest you enter each employee’s designations in the bracket also.

Org Chart Formatting and Other Tips

Unlike other charts, there is not much option in this chart formatting.

You can format the Nodes (the rectangular boxes) in different ways.

On the chart editor, you can change the node size to Small, Medium, or
Large.

Other than the above, you can change node colors. I mean the background color of the rectangles and the color of the active/selected rectangle.

And these tutorials may also help.

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Finding Most Frequent Text in Excel with Dynamic Array Formulas

Looking to identify the most frequently occurring text in Excel? You can do this...

Hierarchical Numbering Sequences in Excel

Creating hierarchical numbering sequences in an Excel spreadsheet can significantly improve the way you...

How to Easily Repeat a Sequence of Numbers in Excel

Excel offers multiple ways to accomplish tasks, and the simplicity of each approach depends...

Create a Sequence of Dates at Every Nth Row in Excel (Dynamic Array)

Would you like to create a sequence of dates in every nth row in...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.