Create an Organizational Chart in Google Sheets

To create an organizational chart in Google Sheets, put each person or position in the first column and that person’s manager in the second, then select the table and choose Insert > Chart. In the Chart editor, open Chart type and choose Organizational chart; Sheets will draw the reporting structure from the parent-child relationships in your data.

What a Google Sheets organizational chart shows

An organizational chart, or org chart, represents who reports to whom. Google Sheets builds this visual from a simple table rather than asking you to draw and connect boxes manually. Each row describes one node in the hierarchy: usually an employee, a role, a team, or a department. The parent field identifies the next level above it.

This approach is useful for a small company directory, a project team, a volunteer group, or a classroom structure. It is also convenient when the reporting lines change often: update the table and the chart can reflect those changes without rebuilding every box. It is not, however, a full people-management system. The chart does not establish whether a reporting relationship is accurate, and it does not replace a secure staff directory or an HR system.

Prepare the source data

Make a compact table with one row per chart item. The first column contains the item to display, and the second contains its parent. For example, a small company might start with these rows:

First column header: Name
Second column header: Reports to
Rows: Maya Chen | blank; Luis Patel | Maya Chen; Erin Brooks | Maya Chen; Noor Ali | Luis Patel

In that example, Maya is the root of the chart, Luis and Erin report to Maya, and Noor reports to Luis. Leave the root item’s parent cell empty. Enter the parent’s label exactly as it appears in the first column for every other row. A third column can provide optional tooltip text, such as a person’s title or team, so viewers can get additional context from the chart.

Keep labels distinct. If two employees share a name, use an unambiguous label such as Erin Brooks — Finance and Erin Brooks — Operations, or include a role or identifier. The parent reference must point to one specific node; repeated labels can make a hierarchy unclear. Avoid merged cells, blank rows within the data, and decorative notes inside the table. Those may interfere with selecting a clean chart range.

Create the chart step by step

Enter the labels and reporting relationships in adjacent columns, with headers in the top row.
Select the complete table, including its headers and any optional tooltip column.
Choose Insert > Chart. Sheets adds a chart and opens the Chart editor, usually at the right side of the browser window.
In the editor’s Setup tab, open the Chart type list and select Organizational chart.
Check that the chart uses the intended data range and that the first column represents the nodes while the second represents their parent relationships. If the result looks wrong, verify the selected range and the source table before changing the chart’s appearance.
Move or resize the chart on the sheet, or use the chart’s three-dot menu to move it to its own sheet if you want it separated from the data.

The chart is linked to its source range. When you edit a name or parent relationship in the table, the chart can update to show the revised hierarchy. If you add more people below the selected range, expand the chart’s data range in Setup so the new rows are included. Keeping the table and chart on the same sheet makes it easier for editors to find the source, while a separate chart sheet can be cleaner for presenting or printing.

Format and organize the result

After choosing the organizational chart type, use the Chart editor’s Customize tab for the options available for that chart. The available controls depend on the chart type; do not expect every control used for a bar or pie chart to apply to an org chart. Use the chart’s size and placement to give longer names enough room, and keep labels consistent so viewers can scan the branches quickly. If you include titles in the optional third column, use a format that makes them easy to distinguish from names.

For a chart that needs to be shared, consider separating presentation from maintenance. Keep the source table on a clearly labeled tab such as Org Data, and place the chart on a tab named Org Chart. Freeze the header row or add a short note explaining which column records the manager. These small choices reduce the chance that someone will mistake a title or department for a reporting relationship.

Sheets arranges the hierarchy automatically; it does not provide the same freeform control as a drawing canvas. If you need exact box positions, custom connectors, or a highly branded layout, create a rough hierarchy in Sheets and consider a diagramming tool for the final graphic. You can also copy a chart into another Google Workspace document, but check the result after pasting because layout and editability may differ from the original sheet.

Keep the chart accurate as the team changes

Think of the source table as the authoritative record and the chart as its visual view. When someone changes teams, update that person’s parent value rather than trying to drag a box to a new branch. When a person leaves, decide whether to remove the row or retain it in a separate historical list; leaving a former employee in the active hierarchy can mislead readers. Before sharing a chart externally, review which names, titles, and other details are visible.

For a larger organization, keep a consistent naming convention and define what each row represents. Mixing people, departments, and temporary project roles in one hierarchy can confuse readers, even if the chart technically renders. If managers are entered by email address or employee ID for uniqueness, remember that the displayed node label is controlled by the first column. A separate optional tooltip field can hold useful context without making every box excessively long.

Common problems and how to fix them

The chart is blank or shows the wrong type: Confirm that the full table is selected and that Organizational chart is selected in Chart type. Check that the first two columns contain node labels and parent labels, not unrelated fields.
A person appears as a top-level node: Check that the parent cell is not empty and that its text exactly matches the intended manager’s node label. An extra space or a different spelling can break the match.
Some rows do not appear: Review the chart’s data range in Setup. Rows added below the original range may need to be included. Also check for empty node labels or misplaced blank rows.
There are multiple roots or an unexpected branch: Look for blank parent cells and verify each relationship. A blank parent denotes a root; an accidental blank can create an extra top-level item.
Names are hard to tell apart: Add a surname, role, department, or another distinguishing detail to the displayed label. Do not rely on two identical node names to communicate which manager is intended.
The chart seems out of date: Confirm that the edited cells are inside the chart’s data range and that the source rows were changed, rather than a copied version elsewhere on the sheet.

A useful troubleshooting habit is to inspect the table first. Org-chart errors are usually data or range problems, not a need to redraw the chart. Correcting the parent reference often fixes an entire branch at once.

Google Sheets compared with other ways to make an org chart

Sheets is a good fit when the hierarchy already lives in a spreadsheet and the chart should be easy to update collaboratively. It is quick to set up and keeps the relationships in ordinary cells. Its limitations become more noticeable when the organization is very large, when the chart needs precise placement, or when the design must meet strict branding or print-layout requirements.

Google Slides or a diagramming application may be preferable when presentation matters more than maintaining the hierarchy as data. Those tools can offer more control over shapes and layout, but manual diagrams may require more work to keep current. Microsoft Excel also has charting and diagram options, but its interface and available features are not identical to Google Sheets. The steps here are for Sheets in a web browser; do not assume that an Excel menu path or a feature such as SmartArt is available in Sheets.

Before choosing, consider who will maintain the chart, how often reporting lines change, whether the source list already exists, and whether viewers need a live, editable chart or a polished static diagram. For a frequently updated team list, the data-linked Sheets chart may be convenient. For an organization-wide publication, you may prefer to verify the structure in Sheets and produce a carefully reviewed final graphic elsewhere.

Sharing, access, and privacy

An org chart can reveal names, roles, and internal reporting lines. Use Google Sheets’ sharing controls to give people only the access they need, and check the file’s sharing settings before sending a link. Editors can change the underlying data; viewers generally need view access rather than edit access. If the chart is intended for a public audience, consider whether names or detailed role information should be removed.

Also remember that access to a chart does not automatically make the underlying information appropriate to publish. Follow your organization’s policies for staff data, and avoid including sensitive personal details in either the displayed labels or tooltip text. For a public-facing chart, a structure based on departments or roles may be more suitable than a full employee directory.

Frequently Asked Questions

Can Google Sheets make an organizational chart automatically?
Yes. Put each node in the first column and its parent in the second, select the data, and choose Insert > Chart. Select Organizational chart in the Chart editor’s Chart type list.

What should I put in the parent column for the top person?
Leave the root person’s parent cell blank. For other rows, enter the label of the person or node they report to, matching the label in the first column.

Can I add job titles to the chart?
Yes. Add an optional third column for tooltip information, such as a title or department. You can also include a short role in the first-column label if you need it visible without relying on a tooltip.

Will the chart update when I change the table?
Changes to data in the chart’s source range can update the chart. If you add rows beyond that range, check Setup and extend the range so those rows are included.

Can I make the boxes appear in a specific order?
Sheets arranges organizational charts automatically, so exact freeform positioning is limited. If precise placement is essential, use the chart as a reference and build the final diagram in a tool designed for custom layouts.

Can I create an org chart in Excel the same way?
Not necessarily. Excel and Google Sheets have different interfaces and chart features. These instructions describe Google Sheets in a web browser, so use Excel-specific guidance for an Excel workbook.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.