Instructions for creating genealogical and organizational charts on Google Sheets

Google Sheets is an online office application that helps us easily draft professional, online spreadsheets. Similar to Microsoft Excel, this application also provides users with many tools to support spreadsheet creation, one of which is support for creating charts and diagrams . That's why, today Download.vn will introduce you how to create a genealogical and organizational chart on Google Sheets.

Drawing  an organizational chart and genealogy in Google Sheets will help us arrange the positions and order of members in a group, business or company according to structure. To help everyone quickly and easily create this diagram, we invite you to follow the article Instructions for creating a genealogical and organizational diagram on Google Sheets.

Instructions for drawing genealogical and organizational charts on Google Sheets

Some notes before drawing an organizational chart:

  • To create an organizational chart for people's names, create a data table with the first column being the names of the people you want to appear on the chart. The second column is the name of a higher level manager than the first column.
  • If creating a location map, enter each low location in the first column and the second column as the high location.
  • If you want to make a genealogy chart, the first column is the name of each family member in the first column and the parents in the second column.

Step 1: First we will access the Google Sheets page on the computer's browser. Then, go to the data table for which you want to create a genealogical, organizational chart.

Step 2: In the Spreadsheet interface, highlight the cells containing the information you want to create a chart for.

Instructions for creating genealogical and organizational charts on Google Sheets

Step 3: At this point, click on Insert above the Menu bar.

Step 4: Then, in the Insert window , click on Chart.

Instructions for creating genealogical and organizational charts on Google Sheets

Step 5: On the right side of the screen, the Chart Editor window will now appear , click on Chart type.

Instructions for creating genealogical and organizational charts on Google Sheets

Step 6: Now, in the Map Type window , click and select the Organization Chart type.

Instructions for creating genealogical and organizational charts on Google Sheets

Step 7: Right now on the screen, we will see the organizational chart displayed with the division of positions, names or family genealogies depending on the content displayed in the table.

Instructions for creating genealogical and organizational charts on Google Sheets

Step 8: If you want to edit the diagram, click on the three-dot icon in the upper right corner of the chart. Then, click Edit chart.

Instructions for creating genealogical and organizational charts on Google Sheets

Step 9: Finally, in the Customize window on the left side of the screen, we can adjust the Size and Color of the buttons in the chart.

Instructions for creating genealogical and organizational charts on Google Sheets

Video instructions on creating genealogical charts and organizing them on Google Sheets

Wishing you success!

Leave a Comment

Troubleshooting Microsoft Edge Youtube Black Screen 2026

Troubleshooting Microsoft Edge Youtube Black Screen 2026

Struggling with YouTube black screen on Microsoft Edge in 2026? Discover proven, step-by-step troubleshooting fixes to restore smooth video playback instantly. Quick solutions that work!

Troubleshooting Microsoft Edge Sidebar Not Opening Glitch

Troubleshooting Microsoft Edge Sidebar Not Opening Glitch

Tired of Microsoft Edge sidebar not opening glitch? Discover quick, effective troubleshooting steps to restore your sidebar instantly. Step-by-step guide with latest fixes for seamless browsing.

How to Fix Microsoft Edge Firewall Blocking Games Fix

How to Fix Microsoft Edge Firewall Blocking Games Fix

Tired of Microsoft Edge "Firewall" blocking your games? Discover proven, step-by-step fixes to unblock games quickly. Get back to seamless gaming with our ultimate guide – no tech skills needed!

Why is Microsoft Edge Better than Chrome in 2026?

Why is Microsoft Edge Better than Chrome in 2026?

Unlock why Microsoft Edge surpasses Chrome in 2026 with blazing speed, unbeatable battery life, AI power, and ironclad privacy. Discover game-changing features that make Edge the smartest switch for power users.

How to Fix PDF Preview Handler Errors in Microsoft Edge

How to Fix PDF Preview Handler Errors in Microsoft Edge

Struggling with PDF Preview Handler Errors in Microsoft Edge? Discover step-by-step fixes to restore seamless PDF previews in File Explorer. Quick troubleshooting, registry tweaks, and prevention tips for the latest Edge versions. Get it fixed now!

How to Manage Microsoft Edge Multiple Profiles and Sync

How to Manage Microsoft Edge Multiple Profiles and Sync

Discover how to effortlessly manage Microsoft Edge multiple profiles and sync across devices. Create, switch, sync favorites, passwords, and more for personalized browsing without hassle.

Solving Microsoft Edge Hsts Attack Warning Fix (2026)

Solving Microsoft Edge Hsts Attack Warning Fix (2026)

Struggling with Microsoft Edge HSTS Attack Warning? Get the ultimate 2026 fixes with step-by-step guides to resolve this frustrating security alert fast. Clear cache, reset settings, and stay secure!

Solving Microsoft Edge Core Isolation Not Turning On

Solving Microsoft Edge Core Isolation Not Turning On

Struggling with Microsoft Edge Core Isolation not turning on? Discover step-by-step fixes for Core Isolation issues, including BIOS tweaks, driver updates, and Windows repairs to boost your security instantly.

Troubleshooting Game Bar Party Chat Audio Not Working

Troubleshooting Game Bar Party Chat Audio Not Working

Struggling with Game Bar Party Chat audio not working? Discover step-by-step troubleshooting for Xbox Game Bar voice chat issues. Quick fixes for no sound, mic problems, and more on Windows. Get back to gaming!

How to Fix Microsoft Edge Update Error 0x80073712

How to Fix Microsoft Edge Update Error 0x80073712

Struggling with Microsoft Edge Update Error 0x80073712? Discover step-by-step fixes like SFC scan, DISM repair, and Edge reset to resolve it fast. No tech skills needed!

Solving Microsoft Edge Private Connection Warnings

Solving Microsoft Edge Private Connection Warnings

Tired of Microsoft Edge "Private Connection" warnings blocking your browsing? Get step-by-step solutions to solve Microsoft Edge Private Connection errors fast. Secure, updated fixes for seamless surfing.

How to Fix Microsoft Edge Result_Code_Hung Error

How to Fix Microsoft Edge Result_Code_Hung Error

Struggling with Microsoft Edge "Result_Code_Hung" Error? Discover proven, step-by-step fixes to resolve hangs and crashes instantly. Get smooth browsing back today!

How to Delete Microsoft Edge History, Cache, and Cookies Completely

How to Delete Microsoft Edge History, Cache, and Cookies Completely

Learn how to delete Microsoft Edge history, cache, and cookies completely with this step-by-step guide. Clear your browsing data fast and securely in the latest Edge version for ultimate privacy.

Solving Edge Browser Profile Error on Every Launch

Solving Edge Browser Profile Error on Every Launch

Tired of the frustrating Edge Browser "Profile Error" popping up every launch? Follow our step-by-step guide to solving Edge Browser "Profile Error" permanently with quick, reliable fixes for the latest versions. No tech skills needed!

Solving Microsoft Edge Precision Driver Compatibility

Solving Microsoft Edge Precision Driver Compatibility

Tired of Microsoft Edge Precision Driver compatibility glitches? Get step-by-step solutions to restore smooth performance, fix lag, and optimize your setup. Proven fixes for the latest Edge versions.