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.

[xaquison]

No one could have made this video easier and clearer. Thank you!

[noonieblount]

WOW! This is so helpful! I'm in the process of doing a family tree and came across this video and you have no idea how much this has helped me :) 3/23/21

[AndreaLowery-ijtw]

Super easy, concise and clear! Thank you so much.

[theduke]

Thanks for this man. Every other video I watched had no audio or voice over. If I wanted that I'd just read a Google post about this stuff.. I'm a pretty visual learner but it helps so much when someone is actually talking on video.

[aia]

Thank you! This was so clear and to the point. Incredibly helpful!

[sourabhpathak]

I come on this video unintentionally 😅, but the trick and value I got from this video is Awesome! 👍😇

[NewFlower]

Thank you for this easy and straight-to-the-point chart. New

[famakinwaoyinkansola]

Thank you for this video. Very easy to understand 👍🏾

[nomadicyou]

Awesome video, so quick and to the point, Than you!

[megabite]

Simple, fast and to the point !
Thanks

[midnightglancer]

Very helpful and easy to follow!!! Thanks Sir.

[pristaviaofficialchannel]

Thank you for this video. Helped a ton!

[fancii]

Great video! How does one have two entities going into one like parents to child? Can you make a video for that please?

[koshizmusic]

Very neat! This could have many other applications as well. Process flow charts, value mapping, that sort of thing.

[pengseya_accladp]

this helpful thank you for your sharing

[JoseToro-yr]

Thanks for the video. If they were long messages, we would have to copy the entire message. Is there any way to do it with IDs?

[gloriaappoh-segbawu]

Very helpful! Is there a way to include a column for positions please?

[sirmoneymoves]

I have 45 people in my organization, and when I create the chart I can only see the far left side of the chart. It doesn’t allow me to move the page at all. Any solution for this?

[mikeasmel]

Is there a way to add 1) a dotted line report? 2) a second reporting line (if someone reports to 2 different people)?

it needs a lot of improvements. child-parent relation etc.