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 Installer Error 124

Troubleshooting Microsoft Edge Installer Error 124

Stuck with Microsoft Edge Installer Error 124? Get proven, step-by-step fixes to resolve it quickly. Master troubleshooting for smooth Edge installation on Windows. No tech skills needed!

How to Fix Microsoft Edge Page Unresponsive Error 2026

How to Fix Microsoft Edge Page Unresponsive Error 2026

Tired of Microsoft Edge "Page Unresponsive" error freezing your tabs in 2026? Get proven, step-by-step fixes to restore lightning-fast browsing. No tech skills needed!

Solving Edge Browser No Internet Secured Glitch (2026)

Solving Edge Browser No Internet Secured Glitch (2026)

Stuck with the Edge browser "No Internet Secured" glitch in 2026? Discover proven, step-by-step fixes to restore your connection fast. Clear cache, reset settings, and more for seamless browsing.

Troubleshooting Microsoft Edge Transparency Multi GPU

Troubleshooting Microsoft Edge Transparency Multi GPU

Tackle Troubleshooting Microsoft Edge "Transparency" Multi GPU issues head-on with step-by-step fixes. Restore smooth, crystal-clear tabs and effects on dual NVIDIA/Intel setups effortlessly.

Solving Microsoft Edge Status In Page Error During Browsing

Solving Microsoft Edge Status In Page Error During Browsing

Tired of Microsoft Edge "Status In Page Error" ruining your browsing? Get proven, step-by-step fixes to resolve it fast. Clear cache, reset settings, and more for seamless surfing.

Troubleshooting Microsoft Edge Certificate Mismatch Warning

Troubleshooting Microsoft Edge Certificate Mismatch Warning

Struggling with Microsoft Edge Certificate Mismatch warning? Discover step-by-step troubleshooting fixes for this common SSL error. Clear cache, update Edge, and more for secure browsing.

How to Reset Microsoft Edge to Default Factory Settings

How to Reset Microsoft Edge to Default Factory Settings

Struggling with a sluggish Microsoft Edge? Discover how to reset Microsoft Edge to default factory settings in minutes. Step-by-step guide with visuals to fix crashes, pop-ups, and performance issues effortlessly.

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.