{"id":8383,"date":"2024-12-22T14:24:28","date_gmt":"2024-12-22T14:24:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/cach-tao-bieu-do-treemap-treemap-chart-trong-excel\/"},"modified":"2024-12-22T14:24:28","modified_gmt":"2024-12-22T14:24:28","slug":"cach-tao-bieu-do-treemap-treemap-chart-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/cach-tao-bieu-do-treemap-treemap-chart-trong-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 Treemap (Treemap Chart) trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>C\u00f9ng v\u1edbi\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/sunburst-chart-trong-excel.html\">bi\u1ec3u \u0111\u1ed3 Sunburst<\/a>,<\/strong> Treemap Chart l\u00e0 m\u1ed9t bi\u1ec3u \u0111\u1ed3 h\u1eefu hi\u1ec7u khi b\u1ea1n mu\u1ed1n th\u1ec3 hi\u1ec7n m\u1ed1i t\u01b0\u01a1ng quan d\u1eef li\u1ec7u theo c\u1ea5p b\u1eadc. H\u00e3y \u0111\u1ecdc v\u1ec1 c\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 Treemap d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6768211b80adb\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-do-treemap-treemap-chart-trong-excel.html#Gioi_thieu_Treemap_Chart\" title=\"Gi\u1edbi thi\u1ec7u Treemap Chart\">Gi\u1edbi thi\u1ec7u Treemap Chart<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-do-treemap-treemap-chart-trong-excel.html#Tao_mot_bieu_do_Treemap\" title=\"T\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 Treemap\">T\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 Treemap<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-do-treemap-treemap-chart-trong-excel.html#Tuy_chinh_bieu_do_Treemap\" title=\"T\u00f9y ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 Treemap\">T\u00f9y ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 Treemap<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-do-treemap-treemap-chart-trong-excel.html#Doi_cach_hien_thi_nhan_Label\" title=\"\u0110\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb nh\u00e3n (Label)\">\u0110\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb nh\u00e3n (Label)<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Gioi_thieu_Treemap_Chart\"><\/span>Gi\u1edbi thi\u1ec7u Treemap Chart<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Treemap chart \u0111\u1eb7c bi\u1ec7t h\u1eefu d\u1ee5ng khi b\u1ea1n mu\u1ed1n so s\u00e1nh t\u1ef7 l\u1ec7 c\u00e1c ph\u1ea7n d\u1eef li\u1ec7u trong c\u00f9ng c\u1ea5p b\u1eadc. Tuy v\u1eady, bi\u1ec3u \u0111\u1ed3 n\u00e0y kh\u00f4ng th\u1ec3 hi\u1ec7n \u0111\u01b0\u1ee3c r\u00f5 r\u00e0ng c\u00e1c c\u1ea5p b\u1eadc t\u1eeb cao nh\u1ea5t xu\u1ed1ng th\u1ea5p nh\u1ea5t (trong tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3, ta s\u1eed d\u1ee5ng bi\u1ec3u \u0111\u1ed3\u00a0<strong>Sunburst\u00a0<\/strong>\u0111\u1ec3 thay th\u1ebf).<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tao_mot_bieu_do_Treemap\"><\/span>T\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 Treemap<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1c b\u01b0\u1edbc t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u0169ng nh\u01b0 d\u1eef li\u1ec7u Treemap chart g\u1ea7n t\u01b0\u01a1ng t\u1ef1 Sunburst chart, ta s\u1ebd l\u1ea5y c\u00f9ng m\u1ed9t ngu\u1ed3n d\u1eef li\u1ec7u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28001\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sunburst-2.png\" width=\"410\" height=\"341\" title=\"sunburst-2\"><\/p>\n<p>Ch\u1ecdn\u00a0<strong>Insert -&gt; Insert Chart -&gt;\u00a0Treemap\u00a0Chart<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28092\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/treemap-chart-2.png\" width=\"646\" height=\"607\" title=\"treemap-chart-2\"><\/p>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c 1 bi\u1ec3u \u0111\u1ed3 treemap. \u0110i\u1ec3m kh\u00e1c bi\u1ec7t so v\u1edbi Sunburst chart \u1edf \u0111\u00e2y \u0111\u00f3 l\u00e0 treemap kh\u00f4ng th\u1ec3 hi\u1ec7n t\u1ea5t c\u1ea3 c\u00e1c c\u1ea5p b\u1eadc d\u1eef li\u1ec7u m\u00e0 ch\u1ec9 c\u00f3 th\u1ec3 bi\u1ec3u hi\u1ec7n gi\u00e1 tr\u1ecb c\u1ee7a c\u1ea5p d\u1eef li\u1ec7u cu\u1ed1i c\u00f9ng tr\u00ean b\u1ea3ng t\u1ed5ng th\u1ec3.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-767.gif\" title=\"ex101_92019-nho-767\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28093\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/treemap-chart-3.png\" width=\"481\" height=\"289\" title=\"treemap-chart-3\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tuy_chinh_bieu_do_Treemap\"><\/span>T\u00f9y ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 Treemap<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Doi_cach_hien_thi_nhan_Label\"><\/span>\u0110\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb nh\u00e3n (Label)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 ph\u00e2n c\u00e1ch c\u00e1c th\u1ee9 b\u1eadc d\u1eef li\u1ec7u, ta c\u00f3 th\u1ec3 thay \u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb nh\u00e3n nh\u01b0 sau:<\/p>\n<ol>\n<li>Click chu\u1ed9t v\u00e0o v\u00f9ng d\u1eef li\u1ec7u<\/li>\n<li>T\u1ea1i th\u1ebb\u00a0<strong>Format,\u00a0<\/strong>m\u1ee5c\u00a0<strong>Current Selection<\/strong>, ch\u1ecdn\u00a0<strong>Format Selection<\/strong>.<\/li>\n<li>Ta ti\u1ebfn h\u00e0nh format cho\u00a0<strong>Series<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28094\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/treemap-chart-4.png\" width=\"929\" height=\"479\" title=\"treemap-chart-4\"><\/strong><\/li>\n<li>Ch\u1ecdn\u00a0<strong>Banner<\/strong> \u0111\u1ec3 t\u00e1ch c\u1ea5p b\u1eadc d\u1eef li\u1ec7u. K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c nh\u01b0 sau:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28095\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/treemap-chart-5.png\" width=\"928\" height=\"497\" title=\"treemap-chart-5\"><\/li>\n<\/ol>\n<p>Ngo\u00e0i ra, c\u00e1c th\u00f4ng s\u1ed1 thay \u0111\u1ed5i kh\u00e1c t\u01b0\u01a1ng t\u1ef1 bi\u1ec3u \u0111\u1ed3 Sunburst.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1c bi\u1ec3u \u0111\u1ed3 kh\u00e1c b\u1eb1ng c\u00e1ch click v\u00e0o m\u1ed9t trong nh\u1eefng link b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/gioi-thieu-bieu-hinh-thac-nuoc-trong-excel.html\"><strong>Gi\u1edbi thi\u1ec7u bi\u1ec3u \u0111\u1ed3 h\u00ecnh th\u00e1c n\u01b0\u1edbc trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/doughnut-chart-excel.html\"><strong>Bi\u1ec3u \u0111\u1ed3 b\u00e1nh Doughnut trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/sunburst-chart-trong-excel.html\"><strong>Bi\u1ec3u \u0111\u1ed3 Sunburst trong Excel<\/strong><\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-767.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8384,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8383","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8383","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8383"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8383\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8384"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}