Easy Google Sheets Org Chart Guide With a Free Template

A Google Sheets org chart is quite commonly used in presentations and reports. It’s a simple chart that shows the hierarchy of who reports to whom in an organization.

Below is an example of a simple org chart.

Org Chart Example

If you’re thinking that it’s going to take a lot of time to build these text boxes and the flow chart diagram, here is the good news – it would only take a few clicks.

Google Sheets has an inbuilt chart type called the organizational chart. All you need to do is have the data in a table and Google Sheets will do all the org chart building.

In this tutorial, I will show you how to quickly create an org chart in Google Sheets.

So let’s get started!

How to Make an Org Chart in Google Sheets With the Right Data

The first step in creating the org chart is to make sure that you have the data in the correct format in Google Sheets.

To begin with, all you need are two columns – one that shows the designation and the other column that shows who this person (holding the designation) reports to.

Below I have the table for a small organization where column A has the designation and column B has the designation to whom the person in Column A reports to.

Data for Org Chart

For example, the CEO reports to no one, but VP Marketing reports to the CEO and so on.

Now. we will create the organization chart using this data.

Free Organizational Chart Template for Google Sheets

Here is a Google Sheets Organizational Chart Template for you to download to follow along with the steps below.

How to Create an Organizational Chart in Google Sheets

Here’s how to make an organizational chart in Google Sheets using the table we created:

  1. Select the entire dataset
  2. Click the ‘Insert’ option in the menuClick the Insert option
  3. Click on ‘Chart’. This will insert a blank chart and also open the chart editor pane on the right.Click the Chart option
  4. In the Chart editor pane, within the ‘Setup’ tab, click on the ‘Chart type’ dropdownClick on Chart Type drop down
  5. Scroll down and select the ‘Organizational chart’ optionClick the Org Chart chart type
  6. Check the ‘Use row 1 as headers’ optionCheck the Use row 1 as header option

The above steps would insert an organizational chart in Google Sheets using the selected data (as shown below).

Org Chart Example

Since this chart is linked with the table, in case you make any changes in the table it would be reflected in the organizational chart in real-time.

Adding Names to the Google Hierarchy Chart

In case you also want to have the name of the person who holds a designation after creating an org chart in Google Sheets, there are two ways to do this in Google Sheets.

  • Have the name show up whenever you hover the cursor over the box that contains the designation
  • Have the name as a part of the designation in the box itself

Let’s see how to do each of these.

Include Job Titles for Each Employee by Using Tooltips

For this method, you can have an additional column where you add the names of the people who hold the specific designation (as shown below).

Org data with names

Note that I have added the names column at the right of the two existing columns. This makes it slightly easier to build the organizational chart.

If you want, you can have the names column in the beginning (as the left-most column), and then adjust the organizational chart to pick up the right data from the right column.

Below are the steps to create an org chart with names in Google Sheets:

  1. Select the entire data set
  2. Click the Insert menu
  3. Click on Charts
  4. In the ‘Chart editor’, within the Setup tab, click on the chart type dropdown
  5. Select Organizational chart
  6. Check the ‘Use row 1 as headers’ option

The above steps would insert at the same organizational chart like the one we inserted above without the names.

But when you select the chart and hover the cursor over any of the boxes, it will display the name of the person holding that designation.

Org data that shows names on hover

The benefit of using this technique is that it doesn’t take up a lot of space while still gives us additional information about the name of the person.

On the other hand, the drawback is that in case you decide to export this chart as a PNG file or a PDF file, you will lose the functionality to get the name as the tooltip when you click the box.

Adding Name as the part of the Dataset

This method is exactly the same that we covered in the beginning.

The only difference is that here along with the designation, we also have the name of the person who owns that position.

Below is the data set that I’m going to use to create this organizational chart.

Designation and name in the same cel

For cosmetic reasons, I have added the name of the person in the next line within the same cell. Doing this makes sure that our organizational chart is not too wide.

Below are the steps to create the Google Sheets org chart vertical display using this data:

  1. Select the entire data set
  2. Click the Insert menu
  3. Click on Charts
  4. In the ‘Chart editor’, within the Setup tab, click on the chart type dropdown
  5. Select Organizational chart
  6. Check the ‘Use row 1 as headers’ option

This will give you an org chart as shown below:

Org Chart with names and designation

Since there are names in each box, this type of Org chart may be slightly wider than the one with just the designations.

Related Reading: How to Make a Gantt Chart in Google Sheets

How to Make a Hierarchy Chart in Google Docs

When you finish building the org chart in Sheets you can simply copy paste it into a Google Doc with the keyboard shortcuts Ctrl+C and Ctrl+V.

Google Org Chart Examples – Customizing the Org Chart

While there is not much that you can customize in an organizational chart in Google Sheets, there are two things you can change:

  • The size of the organizational chart (small, medium, and large)
  • The color of the node (which is the box that holds the designation and the names)
  • The color of any selected box/node

To customize these options, select the chart and then click on the Customize tab in the ‘Chart editor’ pane

Customize tab for org chart

Downloading the Org Chart from Google Sheets (as Image or PDF)

While it’s great to be able to quickly create an org chart in Google Sheets, in most likelihood you are going to use this chart in a PowerPoint presentation or as part of a report in Google Docs or Microsoft Word.

And thanks to the awesome Google Sheet, you can easily export the chart as a PNG file or as a PDF with a single click

Below are the steps to download the organizational chart as a PNG file (or is a PDF file)

  1. Select the organization chart that you’ve already created
  2. Click on the three vertical dots that appear on the top right part of the chartClick on the three vertical dots
  3. Go to the download option and then click on PNG or PDFSelect the file format to download the org chart

The above steps would instantly download the chart in the selected file format.

Google Sheets Organizational Chart FAQ

How Do You Create an Organizational Chart in Google Sheets?

  1. Enter the data for each step of the chart into a left column
  2. In the column next to it, place the over-heading for each input on the left. For example, put Fruit next to Apples and Oranges and Vegetables next to Carrots. You could also have Food next to Vegetables and Fruit to be the main box of the org chart
  3. Highlight the cells and click the Chart tool in the toolbox menu
  4. Find and click the Org chart in the options

Does Google Have an Org Chart Template?

Not by default, but you can download the template from this article and change the data around to suit you if you’d like.

So, this is how you can easily create and customize a Google Sheets organizational chart. Once created you can then export it as a PNG, PDF, or SVG vector file for further use.

What Is the Easiest Way to Create an Org Chart?

You can simply download the Google Sheets or chart template and change over the details for your business. Or, there are plenty of apps on the internet that a specifically built for making org charts.

I hope you found this tutorial useful.

Now that you know how to make a Google Sheets Org Chart, here are some other tutorials you may also like:

Most Popular Posts

Sumit

Sumit

Google Sheets and Microsoft Excel Expert.