New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Charts›Create an organizational chart

Google Sheets · Verified tutorial

Create an organizational chart in Google Sheets

Create an organizational chart from A1:B5 using Employee as each node and Manager as its parent. Do not change any values.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Create an organizational chart from A1:B5 using Employee as each node and Manager as its parent. Do not change any values.

Step-by-step

1

Select the targetCreate an organizational chart from A1:B5.

2

Apply the changeEmployee as each node and Manager as its parent.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

An organizational chart uses the complete A1:B5 data range.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select A1:B5 and repeat the final action. An organizational chart uses the complete A1:B5 data range.

Example spreadsheet data

This is the clean fixture used for the verified run.

Employee	Manager
Josephine
Anna	Josephine
Ben	Josephine
Carlos	Anna

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create an organizational chart from A1:B5.
Apply the change. Employee as each node and Manager as its parent.
An organizational chart uses the complete A1:B5 data range.