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

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu