How to Create Org Chart in Google Sheets

To create an organisation chart in Google Sheets, place the employees in Column A and beside them in column B place who they report to. Once your data entry in complete, select all the 'Employees' cells in Column A and all the 'Reports to' cells in Column B, then click the Insert menu and select the 'Chart' option. You are then given the option to choose a type of chart on the right hand side of the screen. Under the heading 'Other' you will see an option to choose an organisational chart. Select this option and an org chart will be generated and populated with the data you entered in columns A and B. You can edit the data in columns A and B and the org chart changes in real time.