Steps to create org chart in Google Sheets
- Step 1: Click on Insert and choose Chart.
- Step 2: In the Chart editor, select the Column chart option.
- Step 3: Right-click on the chart and select the dropdown option.
- Step 4: In the criteria section, choose dropdown from a range.
- Step 5: Select the desired range and click Done.
Result: The chart will now display an organizational structure based on the selected data range.