[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Organizational charts are a simple but effective way to illustrate hierarchical structures, and are sometimes referred to as organigrams, organograms, or Organizational Breakdown Structures (OBS). They can be used to represent hierarchies of any type, including taxonomies or ontologies. However, they are more frequently used to represent role hierarchies within a company or organization. A basic organizational chart for a business helps you visualize all the roles and how they relate to each other. Depending on the intended use for the chart \u2013 internal or external \u2013 you can include additional information, such as the names or contact details of employees.<\/p>\n
An org chart shows who reports to whom. If you need to show how a total breaks down into parts instead, a pie chart in Google Sheets<\/a> is the better fit.<\/p>\n In this guide, you will learn how to make an organizational chart in Google Sheets. First, you will learn how to set up the data to create a simple organizational chart, including only the roles or job titles. After that, you will learn how to add a third column to include more information in the form of tooltips, like employee names. Finally, you will learn how to set up the data to include more information in each column, like adding the employee names below the title or including multiple items in the tooltips.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-create-an-organizational-chart-in” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Set up the relevant data in columns; for example, a column with roles and another with the role they report to. Select both columns and go to Insert > Chart<\/a>. If the \u2018Organizational chart\u2019 type isn\u2019t inserted automatically, click the \u2018Chart type\u2019 drop-down to select it.<\/p>\n Depending on the kind of organizational chart you want to make, you can use different types of information in your columns. In the example below, I want to create a chart that only includes employee job titles and supervisor job titles. In later sections, you will learn how to add columns with additional information that can be shown as tooltips or directly within the chart.<\/p>\n In the first column, include all the roles or employee job titles that you want to include in the organizational chart. In the second column, you should list the supervisor each role reports to.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-organizational-chart-set-up-data.webp” alt=”Google Sheets organizational chart \u2014 Role and Reports to columns listing each job title and its supervisor” title_text=”Role and Reports to columns listing each job title and its supervisor” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Select both columns and go to Insert > Chart. Under \u2018Chart type\u2019, scroll down to \u2018Other\u2019 and select the \u2018Organizational chart\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-organizational-chart-insert-chart.webp” alt=”Google Sheets organizational chart \u2014 Chart editor with Organizational chart as the chart type and Owner at the top” title_text=”Chart editor with Organizational chart as the chart type and Owner at the top” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Go to the \u2018Customize\u2019 tab in the \u2018Chart editor\u2019 and click \u2018Org\u2019 to show the options. You can change the size of the chart, and choose both the selected and unselected colors for the nodes.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-organizational-chart-customize.webp” alt=”Google Sheets organizational chart \u2014 Customize tab, Org section with size, node color and selected node color” title_text=”Customize tab, Org section with size, node color and selected node color” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-download-or-export-your-organizat” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Select the chart and click on the vertical ellipsis in the top-right corner. Select \u2018Download\u2019 and choose the format you prefer:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-organizational-chart-download.webp” alt=”Google Sheets organizational chart \u2014 chart menu open at Download with PNG, PDF and SVG formats” title_text=”Chart menu open at Download with PNG, PDF and SVG formats” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”examples-of-organizational-charts-in-goo” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that you know how to make a simple organizational chart with the roles or job titles, it\u2019s time to learn how to include additional information. In the first example, you will learn how to add a column to use the tooltips to display the names. In the second example, you will learn how to add the names below the title in the nodes. Finally, in the third example, you will learn how to include more than one item of information in the tooltips.<\/p>\n If you don\u2019t want employee names to appear on the chart itself, you can include them as tooltips. The names will appear when users hover over each node.<\/p>\n 1.<\/strong> Add a third column with the employee names, in the order they appear in the first column.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-names-column.webp” alt=”Google Sheets org chart \u2014 Names column added next to the Role and Reports to columns” title_text=”Names column added next to the Role and Reports to columns” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Select the data in all three columns and go to Insert > Chart.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-insert-menu.webp” alt=”Google Sheets org chart \u2014 Insert menu open with Chart highlighted” title_text=”Insert menu open with Chart highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Under \u2018Chart type\u2019, scroll down to \u2018Other\u2019 and select \u2018Organizational chart\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-chart-type-other.webp” alt=”Google Sheets org chart \u2014 Chart editor Other section with the Organizational chart icon selected” title_text=”Chart editor Other section with the Organizational chart icon selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> When you hover over a node in the chart, you will see a tooltip with the employee\u2019s name.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-name-tooltip.webp” alt=”Google Sheets org chart \u2014 tooltip with the name Martha Canon over the Accounting Manager node” title_text=”Tooltip with the name Martha Canon over the Accounting Manager node” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you want to see the names below the job titles in the organizational chart’s nodes, you can join the cell contents with the Google Sheets TEXTJOIN function<\/a> and the new line character, CHAR(10).<\/p>\n 1.<\/strong> Add a new column and type the TEXTJOIN function in the first cell. Use CHAR(10) as the delimiter and TRUE as the second parameter.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-textjoin-function.webp” alt=”Google Sheets org chart \u2014 TEXTJOIN(CHAR(10), TRUE typed in cell D1 with the formula hint” title_text=”TEXTJOIN(CHAR(10), TRUE typed in cell D1 with the formula hint” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Add a comma and select the first cell in the first column. Add another comma and select the first cell in the second column.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-textjoin-select-cells.webp” alt=”Google Sheets org chart \u2014 =TEXTJOIN(CHAR(10),TRUE,A1,C1) joining the job title and name” title_text=”=TEXTJOIN(CHAR(10),TRUE,A1,C1) joining the job title and name” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Close the parenthesis and press \u2018Enter\u2019. Accept the suggested autofill to copy the formula down.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-textjoin-autofill.webp” alt=”Google Sheets org chart \u2014 Suggested autofill box next to the joined job titles and names” title_text=”Suggested autofill box next to the joined job titles and names” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Add another column for the supervisors. Remember to copy from the column you added in the previous step, so the contents match.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-supervisor-column.webp” alt=”Google Sheets org chart \u2014 new supervisor column with job titles and names and the Paste values only option” title_text=”New supervisor column with job titles and names and the Paste values only option” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> Select the two new columns and go to Insert > Chart. Under ‘Chart type’, choose \u2018Organizational chart\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-names-under-titles.webp” alt=”Google Sheets organizational chart \u2014 nodes showing each job title with the employee name below it” title_text=”Nodes showing each job title with the employee name below it” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Imagine you\u2019re creating an organization chart for internal use, such as onboarding. You want to include only the job title in the chart to keep it uncluttered, but also show the employee\u2019s name and email address in the tooltip. You will need to list the roles in the first column and the role they report to in the second, just like in the first section. The third column should contain the content you want to show in the tooltips. In this case, you want a combination of the name and the email address.<\/p>\n 1.<\/strong> To create the third column, you can use TEXTJOIN or the ampersand (&) symbol to join the name and email. The tooltip is displayed on a single line, but I will add the CHAR(32) character to insert a space between them.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-name-email-formula.webp” alt=”Google Sheets org chart \u2014 =$C1&CHAR(32)&$D1 formula joining the name and email in cell E1″ title_text=”=$C1&CHAR(32)&$D1 formula joining the name and email in cell E1″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Copy the formula down using the fill handle<\/a>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-name-email-fill-down.webp” alt=”Google Sheets org chart \u2014 name and email column filled down to row 10″ title_text=”Name and email column filled down to row 10″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Select the first two columns and hold down Ctrl or Cmd to select the column you just created.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-select-columns.webp” alt=”Google Sheets org chart \u2014 Role, Reports to and name and email columns selected together” title_text=”Role, Reports to and name and email columns selected together” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Go to Insert > Chart and select \u2018Organizational chart\u2019 under \u2018Chart type\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-insert-name-email.webp” alt=”Google Sheets org chart \u2014 Chart editor with data range A1:B10,E1:E10 and the organizational chart” title_text=”Chart editor with data range A1:B10,E1:E10 and the organizational chart” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> As you can see, the tooltip now shows the name and email address of the employee when you hover over each node.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-org-chart-name-email-tooltip.webp” alt=”Google Sheets organizational chart \u2014 tooltip with Catlin Malley and her email over the Owner node” title_text=”Tooltip with Catlin Malley and her email over the Owner node” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Creating organizational charts in Google Sheets is easy. You can illustrate hierarchies easily and include as much or as little information as you want. The tooltip feature also allows you to provide information that isn\u2019t visible on the chart itself. You now know how to create a simple organizational chart that only includes roles or job titles. You also know how to add a third column with the information you want to include as tooltips. Additionally, you know how to combine data to display multiple items in each node and in the tooltips.<\/p>\n To learn more about how to create other types of charts in Google Sheets, check out our guides on:<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Apprenez \u00e0 cr\u00e9er un organigramme dans Google Sheets \u00e0 partir de deux colonnes de donn\u00e9es, puis \u00e0 ajouter des noms et des adresses e-mail dans les n\u0153uds ou les info-bulles.<\/p>","protected":false},"author":2,"featured_media":263946,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-263927","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/263927","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=263927"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/263927\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/263946"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=263927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=263927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=263927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to create an organizational chart in Google Sheets?<\/h2>\n
1. Set up data<\/h3>\n
2. Insert chart<\/h3>\n
3. Customize chart<\/h3>\n
How to download or export your organizational chart?<\/h2>\n
Examples of organizational charts in Google Sheets<\/h2>\n
Example 1. Add name column to show as tooltip<\/h3>\n
Example 2. Add names under job titles<\/h3>\n
Example 3. How to make an organizational chart with name & email in tooltips<\/h3>\n
Conclusion<\/h2>\n
\n