Google Sheets - Organizational chart

You can easily create an organizational chart in Google Sheets, as long as you set a correct data structure. Suppose a company has a reporting structure like below: 1. Select the data. Notice the first row of "Position" and "Supervisor" is excluded. Click Insert > Charts . 2. For Chart type , scroll down and select Organizational chart 3. Now you have a pretty organizational chart.