{"id":345281,"date":"2021-09-27T18:00:33","date_gmt":"2021-09-27T15:00:33","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-create-and-customize-a-treemap-chart-in-microsoft-excel\/"},"modified":"2021-09-27T18:00:33","modified_gmt":"2021-09-27T15:00:33","slug":"how-to-create-and-customize-a-treemap-chart-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-create-and-customize-a-treemap-chart-in-microsoft-excel\/","title":{"rendered":"#How to Create and Customize a Treemap Chart 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-6a2e93053367a\" 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-6a2e93053367a\" 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-treemap-chart-in-microsoft-excel\/#About_Treemap_Charts\" >About Treemap Charts<\/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-treemap-chart-in-microsoft-excel\/#How_to_Create_a_Treemap_in_Excel\" >How to Create a Treemap in Excel<\/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-treemap-chart-in-microsoft-excel\/#How_to_Customize_a_Treemap_in_Excel\" >How to Customize a Treemap in Excel<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Create and Customize a Treemap Chart in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone wp-image-749945 size-full\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/MicrosoftExcelTreemap.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/MicrosoftExcelTreemap.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\/08\/MicrosoftExcelTreemap.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Treemap\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want to display hierarchical data in a compact visual, you can use a treemap chart. In Microsoft Excel, you can create and customize a treemap in just minutes. We\u2019ll show you how.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"About_Treemap_Charts\"><\/span>About Treemap Charts<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As mentioned, treemaps are intended to work with hierarchical data, and this data has one-to-many relationships. Treemaps are a good tool for displaying things like best-selling products, location population, regional sales, and similar parent-child structured data.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create an Organizational Chart in PowerPoint<\/em><\/strong><\/p>\n<p>A treemap uses nested, colored rectangles which you can think of as the branches. Every item in the dataset is represented by a rectangle and the sizes of each correlate to the number data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749905\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/EastWestStates-ExcelTreemap.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Treemap chart\" width=\"650\" height=\"347\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The benefits of a treemap include an easy way to spot patterns, similarities, and anomalies, and a structured method of showing pieces of a whole. The compactness of a treemap also makes it an unobtrusive visual in your spreadsheet.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Create_a_Treemap_in_Excel\"><\/span>How to Create a Treemap in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The best way to organize the data for your treemap is to start with the main category or parent in the first column. Then, add the subcategories, subsequent items, and number data in the columns to the right.<\/p>\n<p>As an example, we\u2019ll use a simple three-column dataset. We have our best-selling products which are categorized by type in the first column. The products within each category are in the second column. And finally, our units sold are in the third column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749906\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/TreemapData-ExcelTreemap.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Treemap hierarchical data\" width=\"378\" height=\"448\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select the data for the chart and head to the Insert tab. Click the \u201cHierarchy\u201d drop-down arrow and select \u201cTreemap.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749908\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/InsertHierarchyTreemap-ExcelTreemap.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"On the Insert tab, click Hierarchy, Treemap\" width=\"613\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The chart will im<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">media<\/a>tely display in your spreadsheet.\u00a0And you can see how the rectangles are grouped within their categories along with how the sizes are determined.<\/p>\n<p>In the screenshot below, you can see the largest product sold, Accessories &gt; Cap, and the smallest, Shoes &gt; Sandals.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749910\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/TreemapWithData-ExcelTreemap.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Treemap largest and smallest items\" width=\"650\" height=\"284\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Next, you can make some changes to the <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\">app<\/a>earance, move or resize the chart, and give it a title.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Customize_a_Treemap_in_Excel\"><\/span>How to Customize a Treemap in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The best place to start customizing your treemap is by giving it a title. By default, the name is Chart Title. Simply click that text box and enter a new name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749911\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ChartTitle-ExcelTreemap.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter a chart title\" width=\"624\" height=\"383\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Next, you can select a style, color scheme, or different layout for the treemap. Select the chart and go to the Chart Design tab that displays. Use the variety of tools in the ribbon to customize your treemap.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749912\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ChartDesignTab-ExcelTreemap.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Chart Design tab in Excel\" width=\"650\" height=\"82\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For fill and line styles and colors, effects like shadow and 3-D, or exact size and proportions, you can use the Format Chart Area sidebar. Either right-click the chart and pick \u201cFormat Chart Area\u201d or double-click the chart to open the sidebar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749914\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/FormatChartArea-ExcelTreemap.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Format Chart Area sidebar\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On Windows, you\u2019ll see two handy buttons on the right of your chart when you select it. With these, you can add, remove, and reposition Chart Elements. And you can pick a style or color scheme with the Chart Styles button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749915\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ChartElementsLegend-ExcelTreemap.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Chart Elements, position Legend\" width=\"650\" height=\"314\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To move your chart to a new spot on your sheet, simply select it, then drag and drop it where you want it. To resize the chart, you can drag inward or outward from a corner or edge.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-749918\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ResizeChart-ExcelTreemap.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Drag to resize the chart in Excel\" width=\"650\" height=\"406\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Charts are super visuals that can help display your data in easy-to-read ways for your audience. So, you might also consider creating a waterfall chart\u00a0or\u00a0a Pareto chart\u00a0in Microsoft 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\/749889\/how-to-create-and-customize-a-treemap-chart-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Create and Customize a Treemap Chart in Microsoft Excel&#8221; If you want to display hierarchical data in a compact visual, you can use a treemap chart. In Microsoft Excel, you can create and customize a treemap in just minutes. We\u2019ll show you how. About Treemap Charts As mentioned, treemaps are intended to work&#8230;<\/p>\n","protected":false},"author":1,"featured_media":345282,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/MicrosoftExcelTreemap.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-345281","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\/345281","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=345281"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/345281\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/345282"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=345281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=345281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=345281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}