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

Check the ‘Use row 1 as headers’ option.

Scroll down and select the ‘Organizational chart’ option.

In the Chart editor sidebar, within the ‘Setup’ tab, click on the ‘Chart type’ dropdown.

This will insert a blank chart and also open the chart editor sidebar on the right.

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

We also offer other free OKR templates you can use in Google Sheets How to Create an Organizational Chart in Google Sheets Here is a Google Sheets Organizational Chart Template for you to download to follow along with the steps below. Free Organizational Chart Template for Google Sheets we will create the Google Sheet organization chart using this data. 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.īelow 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.įor example, the CEO reports to no one, but VP Marketing reports to the CEO and so on. The first step in creating the org chart is to make sure that you have the data in the correct format in Google Sheets. How to Make an Org Chart in Google Sheets With the Right Data Browsing our site will help with this, but for those that like a little more structure to their learning, check out the excellent G Suite guides on Udemy. But only if you know how to use them efficiently. The G Suite is Google’s powerful collection of apps and programs that can exponentially increase your productivity.

What Is the Easiest Way to Create an Org Chart?.

Can you Make a Horizontal Org Chart in Google Sheets?.

Does Google Have an Org Chart Template?.

How Do You Create an Organizational Chart in Google Sheets?.

What to Do if the Org Chart is Too Wide to Display.

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

Google Sheet Org Chart Examples – Customizing the Org Chart.

How to Make a Hierarchy Chart in Google Docs.

Include Job Titles for Each Employee by Using Tooltips.Adding Names to the Google Hierarchy Chart.

How to Create an Organizational Chart in Google Sheets.

Free Organizational Chart Template for Google Sheets.

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

Lucidchart link org chart google sheets