{"id":8412,"date":"2024-12-22T14:29:39","date_gmt":"2024-12-22T14:29:39","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tao-bieu-do-sunburst-sunburst-chart-trong-excel\/"},"modified":"2024-12-22T14:29:39","modified_gmt":"2024-12-22T14:29:39","slug":"tao-bieu-do-sunburst-sunburst-chart-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tao-bieu-do-sunburst-sunburst-chart-trong-excel\/","title":{"rendered":"T\u1ea1o bi\u1ec3u \u0111\u1ed3 Sunburst (Sunburst Chart) trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Bi\u1ec3u \u0111\u1ed3 sunburst (sunburst chart) l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 ph\u00f9 h\u1ee3p khi ta c\u1ea7n bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u ph\u00e2n theo c\u1ea5p \u0111\u1ed9. C\u1ee5 th\u1ec3 v\u1ec1 bi\u1ec3u \u0111\u1ed3 sunburst v\u00e0 c\u00e1ch t\u1ea1o, h\u00e3y xem b\u00e0i vi\u1ebft 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-67682252d50ab\" 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\/sunburst-chart-trong-excel.html#Bieu_do_sunburst_Sunburst_Chart\" title=\"Bi\u1ec3u \u0111\u1ed3 sunburst (Sunburst Chart)\">Bi\u1ec3u \u0111\u1ed3 sunburst (Sunburst 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\/sunburst-chart-trong-excel.html#Tao_bieu_do_sunburst\" title=\"T\u1ea1o bi\u1ec3u \u0111\u1ed3 sunburst\">T\u1ea1o bi\u1ec3u \u0111\u1ed3 sunburst<\/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\/sunburst-chart-trong-excel.html#Tuy_chinh_Sunburst_Chart\" title=\"T\u00f9y ch\u1ec9nh Sunburst Chart\">T\u00f9y ch\u1ec9nh Sunburst Chart<\/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\/sunburst-chart-trong-excel.html#Bieu_dien_du_lieu\" title=\"Bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u\">Bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/sunburst-chart-trong-excel.html#Them_cac_thuoc_tinh_phu\" title=\"Th\u00eam c\u00e1c thu\u1ed9c t\u00ednh ph\u1ee5\">Th\u00eam c\u00e1c thu\u1ed9c t\u00ednh ph\u1ee5<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/sunburst-chart-trong-excel.html#Chart_Title\" title=\"Chart Title\">Chart Title<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/sunburst-chart-trong-excel.html#Label\" title=\"Label\">Label<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/sunburst-chart-trong-excel.html#Legend\" title=\"Legend\">Legend<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Bieu_do_sunburst_Sunburst_Chart\"><\/span>Bi\u1ec3u \u0111\u1ed3 sunburst (Sunburst Chart)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Bi\u1ec3u \u0111\u1ed3 sunburst bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u theo th\u1ee9 b\u1eadc. M\u1ed7i th\u1ee9 b\u1eadc s\u1ebd \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n b\u1eb1ng m\u1ed9t v\u00f2ng tr\u00f2n. C\u00e1c v\u00f2ng tr\u00f2n ph\u00e2n c\u1ea5p \u0111\u1ed3ng t\u00e2m, v\u1edbi v\u00f2ng c\u00e0ng r\u1ed9ng, th\u1ee9 b\u1eadc c\u00e0ng gi\u1ea3m.<\/p>\n<p>M\u1ed9t bi\u1ec3u \u0111\u1ed3 sunburst kh\u00f4ng c\u00f3 th\u1ee9 b\u1eadc s\u1ebd kh\u00e1 t\u01b0\u01a1ng \u0111\u1ed3ng v\u1edbi bi\u1ec3u \u0111\u1ed3 doughnut, tuy nhi\u00ean khi x\u1eed l\u00fd nhi\u1ec1u c\u1ea5p \u0111\u1ed9, bi\u1ec3u \u0111\u1ed3 sunburst s\u1ebd cho th\u1ea5y s\u1ef1 li\u00ean k\u1ebft gi\u1eefa c\u00e1c v\u00f2ng tr\u00f2n v\u1edbi nhau. Bi\u1ec3u \u0111\u1ed3 n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 th\u1ec3 hi\u1ec7n c\u00e1ch m\u00e0 m\u1ed9t th\u00e0nh ph\u1ea7n l\u1edbn ph\u00e2n th\u00e0nh c\u00e1c th\u00e0nh ph\u1ea7n nh\u1ecf h\u01a1n, ng\u01b0\u1ee3c l\u1ea1i v\u1edbi m\u1ed9t ki\u1ec3u bi\u1ec3u \u0111\u1ed3 th\u1ee9 b\u1eadc kh\u00e1c l\u00e0 treemap \u2013 \u0111\u1ed1i chi\u1ebfu c\u00e1c d\u1eef li\u1ec7u t\u01b0\u01a1ng \u0111\u1ed3ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tao_bieu_do_sunburst\"><\/span>T\u1ea1o bi\u1ec3u \u0111\u1ed3 sunburst<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u1ecdn d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3. Ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d\u1eef li\u1ec7u m\u1eabu nh\u01b0 sau:<\/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-1.png\" width=\"410\" height=\"341\" title=\"sunburst-2-1\"><\/p>\n<p>Ch\u1ecdn\u00a0<strong>Insert -&gt; Insert Chart -&gt; Sunburst Chart<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28002\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sunburst-3.png\" width=\"626\" height=\"127\" title=\"sunburst-3\"><\/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-770.gif\" title=\"ex101_92019-nho-770\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28003\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sunburst-4.png\" width=\"647\" height=\"609\" title=\"sunburst-4\"><\/p>\n<p>Sunburst chart \u0111\u01b0\u1ee3c t\u1ea1o ra s\u1ebd c\u00f3 h\u00ecnh d\u1ea1ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28004\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sunburst-5.png\" width=\"633\" height=\"461\" title=\"sunburst-5\"><\/p>\n<h3><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"Tuy_chinh_Sunburst_Chart\"><\/span>T\u00f9y ch\u1ec9nh Sunburst Chart<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Bieu_dien_du_lieu\"><\/span>Bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>B\u1eb1ng c\u00e1ch click v\u00e0o t\u1eebng v\u00f9ng d\u1eef li\u1ec7u, ta c\u00f3 th\u1ec3 l\u00e0m n\u1ed5i b\u1eadt v\u00f9ng d\u1eef li\u1ec7u \u0111\u00f3 l\u00ean. Ch\u1eb3ng h\u1ea1n \u0111\u1ec3 ch\u1ec9 ra d\u1eef li\u1ec7u c\u1ee7a \u201cQu\u1eadn 1\u201d, ta ch\u1ec9 c\u1ea7n click v\u00e0o v\u00f9ng d\u1eef li\u1ec7u.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28005\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sunburst-6.png\" width=\"590\" height=\"456\" title=\"sunburst-6\"><\/p>\n<p>\u00a0<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Them_cac_thuoc_tinh_phu\"><\/span>Th\u00eam c\u00e1c thu\u1ed9c t\u00ednh ph\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<h5><span class=\"ez-toc-section\" id=\"Chart_Title\"><\/span>Chart Title<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>M\u1ed7i bi\u1ec3u \u0111\u1ed3 c\u1ea7n c\u00f3 m\u1ed9t c\u00e1i t\u00ean. Sunburst c\u0169ng v\u1eady, v\u00e0 ta c\u00f3 th\u1ec3 th\u00eam t\u00ean cho bi\u1ec3u \u0111\u1ed3 b\u1eb1ng c\u00e1ch trong m\u1ee5c\u00a0<strong>Chart Design\u00a0<\/strong>ch\u1ecdn\u00a0<strong>Add Chart Element &gt; Chart Title<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28006\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sunburst-7.png\" width=\"931\" height=\"315\" title=\"sunburst-7\"><\/p>\n<p>Click \u0111\u00fap v\u00e0 s\u1eeda t\u00ean chart \u0111\u1ec3 bi\u1ec3u th\u1ecb n\u1ed9i dung bi\u1ec3u \u0111\u1ed3.<\/p>\n<h5><span class=\"ez-toc-section\" id=\"Label\"><\/span>Label<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>Nh\u00e3n (label) l\u00e0 c\u00e1ch Excel hi\u1ec3n th\u1ecb n\u1ed9i dung h\u01b0\u1edbng t\u1edbi c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb. T\u01b0\u01a1ng t\u1ef1 v\u1edbi Chart Title, ta ch\u1ecdn\u00a0<strong>Data Labels<\/strong> v\u00e0 thi\u1ebft l\u1eadp v\u1ecb tr\u00ed nh\u00e3n.<\/p>\n<h5><span class=\"ez-toc-section\" id=\"Legend\"><\/span>Legend<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>Ch\u00fa gi\u1ea3i (legend) s\u1ebd th\u1ec3 hi\u1ec7n nh\u1eefng th\u00f4ng tin li\u00ean quan t\u1edbi d\u1eef li\u1ec7u. V\u1edbi bi\u1ec3u \u0111\u1ed3 Sunburst, Legend th\u1ec3 hi\u1ec7n n\u1ed9i dung t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ea5p b\u1eadc cao nh\u1ea5t.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28007\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sunburst-8.png\" width=\"772\" height=\"468\" title=\"sunburst-8\"><\/p>\n<p>\u00a0<\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 v\u1ec1 bi\u1ec3u \u0111\u1ed3 trong Excel:<\/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 v\u00e0 \u1ee9ng d\u1ee5ng<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-tao-bieu-do-treemap-treemap-chart-trong-excel.html\"><strong>Bi\u1ec3u \u0111\u1ed3 c\u00e2y (Treemap) trong Excel<\/strong><\/a><\/p>\n<p>\u00a0<\/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-770.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8413,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8412","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\/8412","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=8412"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8412\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8413"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}