{"id":302061,"date":"2021-07-18T18:00:00","date_gmt":"2021-07-18T15:00:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-create-and-customize-a-people-graph-in-microsoft-excel\/"},"modified":"2021-07-18T18:00:00","modified_gmt":"2021-07-18T15:00:00","slug":"how-to-create-and-customize-a-people-graph-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-create-and-customize-a-people-graph-in-microsoft-excel\/","title":{"rendered":"#How to Create and Customize a People Graph in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a25b5c112ce1\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a25b5c112ce1\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-and-customize-a-people-graph-in-microsoft-excel\/#Add_the_People_Graph_Add-In_to_Excel\" >Add the People Graph Add-In to Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-and-customize-a-people-graph-in-microsoft-excel\/#Insert_a_People_Graph\" >Insert a People Graph<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-and-customize-a-people-graph-in-microsoft-excel\/#Customize_Your_People_Graph\" >Customize Your People Graph<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-and-customize-a-people-graph-in-microsoft-excel\/#Refresh_Delete_or_Select_the_People_Graph\" >Refresh, Delete, or Select the People Graph<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Create and Customize a People Graph in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-732855\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/InsertedPeopleGraph-Excel.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/InsertedPeopleGraph-Excel.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/InsertedPeopleGraph-Excel.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"People Graph in Microsoft Excel\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you take advantage of Microsoft Excel\u2019s charts for helpful visual displays of your data, check out the People Graph option to create a simple depiction of the number of people or items you have logged in your spreadsheet.<\/p>\n<p>You can display things like the number of visitors to your website, <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">download<\/a>s of your app, sign-ups for your event, calls to your support center, and much more.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_the_People_Graph_Add-In_to_Excel\"><\/span>Add the People Graph Add-In to Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>People Graph is an add-in developed by Microsoft, and there\u2019s already a button for it in your Excel ribbon. But before you can use it, you\u2019ll have to <em>trust<\/em> the add-in to install it.<\/p>\n<p>Open the Insert tab in Excel and look for the Add-Ins group. Click the button for People Graph.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-732858\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/InsertPeopleGraph-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"On the Insert tab, click People Graph\" width=\"650\" height=\"125\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see a pop-up window with a link to \u201cSee Details.\u201d This takes you to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/click.linksynergy.com\/deeplink?id=2QzUaswX1as&amp;mid=24542&amp;u1=htg\/732854&amp;murl=https%3A%2F%2Fappsource.microsoft.com%2Fen-us%2Fproduct%2Foffice%2Fwa104104476\">the add-in on the Office Store website,<\/a> where you can read an overview, reviews, and other details. Click \u201cTrust This Add-In\u201d to get started.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-732857\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/TrustPeopleGraph-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Trust the add-in\" width=\"650\" height=\"250\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once the add-in is installed in Excel, you can click the button on the Insert tab to use the feature when you need it.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Install and Use Add-ins for Microsoft Office<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Insert_a_People_Graph\"><\/span>Insert a People Graph<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Whenever you hit the People Graph button in the ribbon, you\u2019ll see a sample graph. Click the Data icon that looks like a small grid.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-732859\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/ClickDataPeopleGraph-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"650\" height=\"448\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Optionally, you can enter your graph Title before selecting your data, or you can just head back to this spot to add the title later.<\/p>\n<p>Click \u201cSelect Your Data,\u201d and then drag through the cells that you want to use. Currently, you must use two columns of data, but you can have multiple rows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-732860\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/SelectDataPeopleGraph-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Select Your Data\" width=\"650\" height=\"448\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then, click \u201cCreate\u201d on the People Graph screen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-732861\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/CreatePeopleGraph-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Create\" width=\"650\" height=\"308\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Customize_Your_People_Graph\"><\/span>Customize Your People Graph<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>After you insert your People Graph in Microsoft Excel, you can customize it. Click the gear icon to open the settings. You can then move through the three settings for type, theme, and shape.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-732862\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/SettingsPeopleGraph-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the gear to open Settings\" width=\"650\" height=\"448\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can currently pick from three graph types. Each has a slightly different layout and appearance. Click \u201cType,\u201d and then choose one on the right side.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-732865 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/TypePeopleGraph-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Type\" width=\"650\" height=\"448\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Next, you can select a theme that changes the background and colors of the graph. Click \u201cTheme,\u201d and choose one of the seven options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-732864 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/ThemePeopleGraph-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Theme\" width=\"650\" height=\"448\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Finally, you can use a different shape. So if your data is better represented by a shape other than people, you can choose the best fit. Click \u201cShape\u201d and pick from the 16 options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-732863\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/ShapePeopleGraph-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Shape\" width=\"650\" height=\"448\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can select and drag your People Graph wherever you want it on your spreadsheet. And if you edit the data on which the graph is based, Excel will update the graph automatically.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-732867\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/EditedPeopleGraph-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Edited and moved People Graph in Excel\" width=\"650\" height=\"366\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Refresh_Delete_or_Select_the_People_Graph\"><\/span>Refresh, Delete, or Select the People Graph<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>On the top right of your People Graph, you\u2019ll see an arrow (Windows) or an Info icon (Mac). When you click, you\u2019ll see several actions.<\/p>\n<p>Choose \u201cReload\u201d to refresh the graph, \u201cDelete\u201d to remove it, and \u201cSelect\u201d to select the graph if you want to move it. You also have options to get support, attach a debugger, and view the security info.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-732866\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/InfoPeopleGraph-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the arrow to open more options\" width=\"650\" height=\"448\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019re looking for a simple way to visually display data, especially if it includes a number of people like customers, clients, or contacts, try out the People Graph in Microsoft Excel. And for another helpful type of chart, take a look at how to create a tally graph in Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/732854\/how-to-create-and-customize-a-people-graph-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Create and Customize a People Graph in Microsoft Excel&#8221; If you take advantage of Microsoft Excel\u2019s charts for helpful visual displays of your data, check out the People Graph option to create a simple depiction of the number of people or items you have logged in your spreadsheet. You can display things like&#8230;<\/p>\n","protected":false},"author":1,"featured_media":302062,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/InsertedPeopleGraph-Excel.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-302061","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/302061","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=302061"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/302061\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/302062"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=302061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=302061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=302061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}