Organizational charts

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.

Organizational 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 showing employee names

Make a copy

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

 

Organizational chart showing employee titles

Make a copy

Customize an organizational chart

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize and then Org.
  4. Change the size or color of the boxes.

Related articles

Was this helpful?
How can we improve it?