Use an organizational chart to show the relationship between members of a company, a group of people, or family tree.
Learn how to add & edit a chart.
How to format your data
- First column: Enter the names of all group members.
- Second column: Enter the name of each person’s manager, parent, or other hierarchical relationship.
- Third column (Optional): Enter notes that show up when you point your mouse at each person.
- Rows: Each row represents a different person on the chart.
Examples
Org chart with employee names
| Employee | Manager |
| Alice | Carter |
| Burt | Carter |
| Mary | Carter |
| Chris | Alice |
| Susie | Alice |
| Olive | Burt |
| Ray | Mary |
| Tony | Mary |
| Troy | Burt |
Org chart with job titles
| Hierarchy | Leads |
| CEO | |
| Marketing | CEO |
| Finance | CEO |
| Ops | CEO |
| HR | CEO |
| Team lead | Marketing |
| Team lead | Finance |
| Team lead | Ops |
| Team lead | HR |
| Team members | Team lead |
Customize an organizational chart
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize
Org.
- Change the size or color of the boxes.
Org.