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.