Organization Chart in Google Sheets: Make and Share One

Yes. Google Sheets can turn employee and manager data into an organizational chart: put each person in one column and their manager in the next, then choose Insert > Chart and select Organizational chart in the Chart editor. The chart is linked to the sheet data, so it can be updated as reporting relationships change.

What a Google Sheets organization chart shows

An organization chart, also called an org chart, is a visual map of who reports to whom. In Sheets, the chart is built from relationships in your rows rather than from a collection of boxes that you position by hand. A typical chart begins with a leader at the top and branches down through managers and their direct reports.

For example, a small company might have Priya Shah as its chief executive, with Luis Gomez and Mei Chen reporting to her. If Luis manages Jordan Lee and Sam Patel, those two employees appear below Luis. The chart makes that structure easier to scan than a long staff list, especially when a team has several management levels.

This feature is useful for a basic reporting structure, but it is not a complete human-resources system. It does not infer managers from job titles, decide who should report to whom, or verify that the chart reflects company policy. The spreadsheet supplies the relationships; the chart displays them.

Prepare the employee and manager data

Start with a clean table in a Google Sheets file opened in a web browser. The first column identifies each person, the second identifies that person’s direct manager, and an optional third column can provide extra text shown as a tooltip. A simple layout could look like this:

Column A — Name: Priya Shah, Luis Gomez, Mei Chen, Jordan Lee, and Sam Patel.
Column B — Manager: leave Priya’s cell blank; enter Priya Shah for Luis and Mei, and Luis Gomez for Jordan and Sam.
Column C — Tooltip: optionally enter details such as a role, department, or work location.

Use the same spelling for a manager’s name wherever that person is referenced. For example, if the employee row says Luis Gomez, the Manager cells for his reports should also say Luis Gomez—not Luis, L. Gomez, or a different variation. This consistency lets the chart match people to their parent nodes.

Each person should appear once as a person in the Name column, and the top-level leader should have no manager listed. Avoid blank rows in the middle of the data range. If two people have the same name, make their labels distinguishable, such as Jordan Lee — Sales and Jordan Lee — Operations, and use those exact labels when identifying their managers. Keep the wording concise: long labels and large teams can make a chart harder to read.

Create the chart in Google Sheets

Once the table is ready, create the visualization from the browser version of Sheets. These steps use Google Sheets menu names; Excel has different chart and hierarchy tools.

Select the full data range, including the column headings and any tooltip column. For example, select A1:C6 if the headings are in row 1 and there are five people.
Choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, usually at the right of the spreadsheet.
In the editor’s Setup tab, open Chart type and choose Organizational chart. If Sheets has chosen another chart type automatically, change it here.
Check the preview. Confirm that the top leader is at the root and that reports appear under the intended manager. Correct the table if the hierarchy is wrong.
Close the Chart editor when the chart looks right. Drag the chart to move it, or drag a corner to resize it on the sheet.

The Name and Manager columns are the essential relationship data. The optional tooltip column adds information that a viewer can inspect by pointing at a node. If the chart does not appear as expected, first check that the selected range includes the right columns, that the root has no manager, and that manager labels match names exactly.

Format the chart and make it readable

Double-click the chart to reopen the Chart editor. The Customize tab contains formatting controls available for the selected chart type. Options can vary as Sheets changes its interface, so use the controls shown for Organizational chart rather than expecting every setting available for a bar or pie chart. Where available, adjust node appearance, font, or chart style to improve contrast and legibility.

Make a quick readability check at the size people will actually use. A chart that looks clear on a large monitor may become difficult to read when printed or viewed on a phone. Keep role or department details in the tooltip column instead of adding lengthy descriptions to every name. If colors carry meaning—for example, to distinguish departments—include a key or label so viewers are not left guessing.

For a presentation or a printed handout, resize the chart and adjust the sheet layout before exporting or printing. A wide organization may need landscape orientation or more than one page. A chart is a visual summary, not a substitute for accessible, searchable employee data, so retain the underlying table for people who need to find a name or relationship quickly.

Keep reporting relationships accurate

The chart reflects its source data. When someone joins, leaves, or changes managers, edit the relevant row in the table and check that the chart updates. Avoid maintaining one copy of the reporting structure in the chart and another in an unrelated list; separate versions can drift out of date. If a chart seems stale, confirm that its data range still includes the new rows and that the chart is using the intended range.

For example, suppose Jordan moves from Luis’s team to Mei’s team. Change Jordan’s Manager cell from Luis Gomez to Mei Chen. The relationship data now expresses the new structure; review the rendered chart to make sure the change is visible and that no old row or duplicate entry remains. For a reorganization affecting many people, make a backup copy of the spreadsheet or duplicate the tab before editing. That gives you a comparison point if the change needs review.

Consider adding a date or version note near the table, such as Reporting structure updated: November 2026. This does not prove that the information is correct, but it helps readers understand when it was last reviewed. Assign someone responsibility for checking the source data periodically, particularly if people use the chart to route approvals or find team contacts.

Sharing, access, and sensitive details

A chart in a spreadsheet follows the spreadsheet’s sharing permissions. Use the Share button in Google Sheets to choose who can view or edit the file. Viewers can see the chart and source data they have access to; editors can change the file. If recipients only need a visual reference, consider whether they need edit access to the underlying employee information.

Names, reporting lines, and tooltip details can be sensitive in some workplaces. Include only information appropriate for the intended audience. A work location or role may be useful; personal contact details, performance notes, or other private information usually do not belong in a broadly shared chart. Check both the sheet’s sharing settings and the content of all columns before sending a link. Removing a detail from the visible chart does not make it private if it remains in an accessible cell.

Limitations and alternatives to consider

A Sheets organizational chart is convenient when the hierarchy can be represented as a straightforward set of parent-and-child relationships. It is less suitable when a person reports to several managers, when the structure includes complex cross-functional teams, or when you need precise placement, branded graphics, or a carefully designed presentation. A conventional org chart emphasizes a single reporting path; it does not explain every project collaboration or informal influence.

For a small or medium-sized reporting structure, the chart can be a practical way to make a data table visual. For a polished diagram with custom positions, shapes, and connectors, a manual drawing tool may offer more control, but someone must maintain the diagram as changes occur. Google Slides can be useful when the main goal is a presentation graphic. For a hierarchy graphic in Microsoft Excel, the usual alternative is a SmartArt hierarchy graphic rather than Google Sheets’ Organizational chart type; the editing workflow and connection to tabular data differ.

Choose based on how often the structure changes and how it will be used. If the source table is already maintained in Sheets and updates are frequent, a chart tied to that data avoids redrawing each box manually. If the structure is unusual or the final output must meet strict design requirements, a purpose-built diagram may be a better fit. In either case, keep a clear source of truth and identify who is responsible for updating it.

Common problems and fixes

The chart is empty or incomplete: Check that the selected range includes the Name and Manager columns, and that the people are inside the selected rows. Reopen Setup and confirm Organizational chart is the chosen type.
A person appears in the wrong place: Inspect that person’s Manager cell. It should contain the name of the intended direct manager, spelled exactly as it appears in the Name column.
The top leader is missing or not at the top: Make sure the root person has a blank Manager cell and that the other rows ultimately connect to that person.
Names or relationships are ambiguous: Give people with matching names distinct labels and use the same full labels in the Manager column.
The chart is hard to read: Shorten node labels, use tooltips for secondary detail, enlarge the chart, or divide a very large structure into department-level charts with clear titles.

Frequently Asked Questions

Does Google Sheets have a built-in organization chart?
Yes. Organizational chart is a chart type in the Google Sheets Chart editor. It uses a table of people and their managers to draw a hierarchy.

What columns do I need for an org chart in Google Sheets?
Use one column for each person’s name and another for that person’s manager. A third column can be used for tooltip information. Leave the manager cell blank for the top-level person.

Can I make an organization chart update when I change the sheet?
The chart is based on spreadsheet data, so edits to names or manager relationships can be reflected in the chart. After changing the table, check the chart and its data range to confirm it displays the intended structure.

Can I make an org chart in Google Sheets with multiple managers?
The standard organizational chart is designed to show a hierarchy with a parent relationship for each person. If someone has multiple reporting relationships, a single tree may not represent the arrangement clearly; use a diagram designed for that structure or create separate views.

Can I download or print the chart?
You can use Google Sheets’ available download and print options for the spreadsheet, but the result depends on the sheet layout and page settings. Resize and position the chart first, then check the print preview or exported file to confirm that labels are legible.

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.