{"id":3412,"date":"2016-06-16T13:01:05","date_gmt":"2016-06-16T11:01:05","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3412"},"modified":"2024-06-02T13:24:18","modified_gmt":"2024-06-02T11:24:18","slug":"create-treemap-chart-excel-2016","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-treemap-chart-excel-2016\/","title":{"rendered":"Create a Treemap Chart With Excel 2016"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><strong>Treemap\u00a0Charts<\/strong> are one of the many new <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/radar-chart\/\" target=\"_blank\" rel=\"noopener\">Charts available only in Excel<\/a> 2016.<\/p>\n<p>They are\u00a0<strong>very visual<\/strong> as it can easily show you <strong>patterns<\/strong>, like based\u00a0on your <strong>summary of sales grouped by month<\/strong>.<\/p>\n<p>The <strong>tree branches<\/strong> are <strong>represented by rectangles<\/strong>, wherein each <strong>rectangle&#8217;s size would denote how big the value<\/strong> (in this case, <em>Sales<\/em>) would be.<\/p>\n<p>The treemap chart would\u00a0\u00a0<strong>show each category in each unique color<\/strong> to make it easy to differentiate between each other.<\/p>\n<p>In this example I show you how easy it is to insert a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pie-chart-in-excel\/\" target=\"_blank\">Treemap Chart using Excel<\/a>.<\/p>\n<p>To upgrade to Excel 2016 you can use this link here: <a href=\"https:\/\/www.microsoftstore.com\/store\/msusa\/en_US\/cat\/categoryID.68155000?icid=en_US_homepage_whatsnew_2_OfficeCompare_160607\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Microsoft Office 2016<\/a><\/p>\n<p>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/oVeiniqy8xg?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Treemap-Chart.xlsx<\/span><\/a><\/p>\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Highlight your summary table\u00a0and go to <em><strong>Insert &gt; Recommended Charts<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Treemap Chart With Excel 2016\" class=\"alignnone size-full wp-image-3415\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-01.png\" alt=\"Create a Treemap Chart With Excel 2016\" width=\"315\" height=\"323\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-01.png 315w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-01-293x300.png 293w\" sizes=\"(max-width: 315px) 100vw, 315px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Treemap Chart With Excel 2016\" class=\"alignnone size-full wp-image-3416\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-02.png\" alt=\"Create a Treemap Chart With Excel 2016\" width=\"451\" height=\"134\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-02.png 451w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-02-300x89.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Select <em><strong>All Charts &gt; Treemap&gt; OK<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Treemap Chart With Excel 2016\" class=\"alignnone size-full wp-image-3418\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-03.png\" alt=\"Create a Treemap Chart With Excel 2016\" width=\"634\" height=\"600\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-03.png 634w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-03-300x284.png 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span>\u00a0Now you have your\u00a0<strong>Treemap Chart<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Treemap Chart With Excel 2016\" class=\"alignnone size-full wp-image-3419\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-04.png\" alt=\"Create a Treemap Chart With Excel 2016\" width=\"480\" height=\"289\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-04.png 480w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-04-300x181.png 300w\" sizes=\"(max-width: 480px) 100vw, 480px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span>\u00a0You can further <strong>customize the look and feel<\/strong> of your Treemap Chart, by going to\u00a0<em><strong>Chart Tools &gt;\u00a0Design \/ Format<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Treemap Chart With Excel 2016\" class=\"alignnone size-full wp-image-3420\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-05.png\" alt=\"Create a Treemap Chart With Excel 2016\" width=\"934\" height=\"196\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-05.png 934w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-05-300x63.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-05-768x161.png 768w\" sizes=\"(max-width: 934px) 100vw, 934px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong><\/span>\u00a0In our example, let us go to <em><strong>Chart Tools &gt;\u00a0Design\u00a0<\/strong><\/em>and pick one of the alternate designs.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Treemap Chart With Excel 2016\" class=\"alignnone size-full wp-image-3421\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-06.png\" alt=\"Create a Treemap Chart With Excel 2016\" width=\"760\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-06.png 760w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-06-300x64.png 300w\" sizes=\"(max-width: 760px) 100vw, 760px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Now you have your beautiful looking Treemap\u00a0chart and you can quickly point out to your management\u00a0where the regions with the biggest <em>Sales<\/em> are&#8230;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create a Treemap Chart With Excel 2016\" class=\"alignnone size-full wp-image-3422\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-07.png\" alt=\"Create a Treemap Chart With Excel 2016\" width=\"482\" height=\"290\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-07.png 482w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Treemap-Chart-07-300x180.png 300w\" sizes=\"(max-width: 482px) 100vw, 482px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Treemap\u00a0Charts are one of the many new Charts available only in Excel 2016. They are\u00a0very visual as it can easily show you patterns, like based\u00a0on your summary of sales grouped by month. The tree branches are represented by rectangles, wherein each rectangle&#8217;s size would denote how big the value (in this case, Sales) would [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17291,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Create a Treemap Chart With Excel 2016","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[127,5],"tags":[94,136,135],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3412"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=3412"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3412\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17291"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}