In this tutorial, you will learn how to make an organizational chart in Google Sheets.
An organizational chart is a tool for visualizing the relationships between individuals at an organization or within a group or family. They can be used to clearly show hierarchy or family relationships through connections between nodes that represent the individuals of the group. Organizational charts can be time consuming to make if you have to create them manually, but fortunately Google Sheets makes it quick and easy to generate an organizational chart from just a few columns of data. Read on to learn how.
Prepping the Data
Before adding the organizational chart, the data to chart must be properly set up in Google Sheets following these steps:
Add the following 3 headers to your spreadsheet for the 3 columns of data needed for the organizational chart:
- REPORTS TO
- JOB TITLE
Note that the job title column is optional and can be used for any other information you’d like to display about individuals. For example, in a family tree you might use this column for date of birth. Data in this column will display in a tooltip on hover
Enter individual names in the Name column
Select the cells in the Reports To column and open the Data menu, then choose Data Validation
In the Data Validation dialog, make sure List from Range is selected in the dropdown, then click on the Select Data Range icon in the input field
Click and drag to select the range of names in the Name column, then click OK
Click Save to save the data validation and dropdowns will appear in cells in the Reports To column
Click on the dropdown arrows or start typing a name then choose an option from the dropdown for each person in the organization except the CEO or whoever is at the top of the organizational structure
Fill in Job Titles or whatever tooltip information you desire in the final column
Once you have the data set up following the above steps, you’re ready to make the chart
Select the 3 columns of data from the preceding steps, excluding headers, and open the Insert menu, then choose Chart
In the Chart Editor, under Chart Type, select the Organizational Chart option from near the bottom
An organizational chart will be inserted in your spreadsheet. Resize the chart as needed by clicking and dragging the drag handles to display all data
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to make an organizational chart in Google Sheets. Want more? Check out all the Google Sheets Tutorials.