Create An Organizational Chart In Google Docs

Here’s how you can put together an org chart in Google Sheets. It will be a live chart meaning as you update the employee names or hierarchy in the spreadsheet, the org chart would update itself. Let’s get started.

Step 1. Open a Google Sheet and put the employee names in column A and the names of the immediate managers in Column B.

Step 2. Select the cells that you’ve just entered and choose Chart from the Insert menu in the spreadsheet.

Step 3. The Chart Editor will open inside Google Sheets. Scroll down the list of available chart types, choose “Organizational Chart” and click Insert to add the chart into your spreadsheet.

*Of course, the instructions refer to creating a chart for hierarchy in a business or organization.  Below, I changed it to be a calling tree.  There are lots of options.