{"id":11013,"date":"2025-01-15T01:05:20","date_gmt":"2025-01-15T01:05:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/gioi-thieu-ve-bieu-do-hinh-tron-theo-nhom-trong-excel\/"},"modified":"2025-01-15T01:05:20","modified_gmt":"2025-01-15T01:05:20","slug":"gioi-thieu-ve-bieu-do-hinh-tron-theo-nhom-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/gioi-thieu-ve-bieu-do-hinh-tron-theo-nhom-trong-excel\/","title":{"rendered":"Gi\u1edbi thi\u1ec7u v\u1ec1 bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n theo nh\u00f3m trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00f4m nay <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 h\u00ecnh tr\u00f2n theo nh\u00f3m.\u00a0\u0110\u00e2y l\u00e0 m\u1ed9t bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh\u00a0s\u1eb5n trong Excel. Th\u00f4ng th\u01b0\u1eddng bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00f2n minh h\u1ecda m\u1ed1i\u00a0quan h\u1ec7 d\u1ea1ng\u00a0c\u01a1 c\u1ea5u gi\u1eefa th\u00e0nh ph\u1ea7n v\u1edbi t\u1eadp th\u1ec3, trong\u00a0\u0111\u00f3 t\u1ed5ng t\u1ea5t c\u1ea3 c\u00e1c mi\u1ebfng gh\u00e9p c\u1ee7a h\u00ecnh tr\u00f2n c\u1ed9ng l\u1ea1i ph\u1ea3i\u00a0\u0111\u1ea1t\u00a0\u0111\u1ee7 100%.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9195\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pie-of-pie-chart.png\" width=\"600\" height=\"338\" title=\"pie-of-pie-chart\"><\/p>\n<p>Bi\u1ec3u\u00a0\u0111\u1ed3 n\u00e0y ho\u1ea1t\u00a0\u0111\u1ed9ng hi\u1ec7u qu\u1ea3 nh\u1ea5t khi d\u1eef li\u1ec7u kh\u00f4ng b\u1ecb ph\u00e2n m\u1ea3nh\u00a0qu\u00e1 nhi\u1ec1u (ch\u1ec9 t\u1eeb 2-5 nh\u00f3m s\u1ed1 li\u1ec7u). Tuy v\u1eady, bi\u1ec3u\u00a0\u0111\u1ed3 h\u00ecnh tr\u00f2n d\u1ea1ng nh\u00f3m c\u00f3 th\u1ec3 gi\u00fap m\u1edf r\u1ed9ng s\u1ed1 l\u01b0\u1ee3ng nh\u00f3m nhi\u1ec1u h\u01a1n m\u00e0 kh\u00f4ng l\u00e0m bi\u1ec3u\u00a0\u0111\u1ed3 g\u1ed1c tr\u1edf n\u00ean qu\u00e1 ph\u1ee9c t\u1ea1p. Khi thi\u1ebft l\u1eadp bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00f2n d\u1ea1ng nh\u00f3m, Excel s\u1ebd chuy\u1ec3n \u201cn\u201d mi\u1ebfng gh\u00e9p nh\u1ecf nh\u1ea5t c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3 g\u1ed1c sang m\u1ed9t bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00f2n kh\u00e1c v\u00e0 sau\u00a0\u0111\u00f3 c\u0103n ch\u1ec9nh l\u1ea1i sao cho ph\u00f9 h\u1ee3p v\u1edbi d\u1eef li\u1ec7u hi\u1ec7n c\u00f3.<\/p>\n<p>L\u01b0u\u00a0\u00fd kh\u00f4ng n\u00ean s\u1eed d\u1ee5ng bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00f2n d\u1ea1ng nh\u00f3m n\u1ebfu nh\u01b0 c\u00f3 qu\u00e1 nhi\u1ec1u nh\u00f3m s\u1ed1 li\u1ec7u ho\u1eb7c t\u1ed5ng s\u1ed1 ph\u1ea7n tr\u0103m c\u1ee7a\u00a0c\u00e1c mi\u1ebfng gh\u00e9p kh\u00f4ng\u00a0\u0111\u1ea1t\u00a0\u0111\u1ee7 100%. B\u1eb1ng m\u1eaft th\u01b0\u1eddng ng\u01b0\u1eddi d\u00f9ng kh\u00f3 c\u00f3 th\u1ec3 nh\u1eadn ra s\u1ef1 kh\u00e1c bi\u1ec7t v\u1ec1 k\u00edch th\u01b0\u1edbc gi\u1eefa c\u00e1c mi\u1ebfng gh\u00e9p c\u1ee7a h\u00ecnh tr\u00f2n v\u1edbi nhau, v\u00e0\u00a0\u0111\u1ed1i v\u1edbi bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00f2n d\u1ea1ng nh\u00f3m th\u00ec th\u1eadm ch\u00ed\u00a0\u0111i\u1ec1u n\u00e0y c\u00f2n tr\u1edf n\u00ean b\u1ea5t kh\u1ea3 thi h\u01a1n.<\/p>\n<p><strong>\u0110i\u1ec3m c\u1ed9ng:<\/strong><\/p>\n<ul>\n<li>L\u00e0 gi\u1ea3i ph\u00e1p\u00a0\u0111\u01a1n gi\u1ea3n h\u01a1n khi ph\u1ea3i x\u1eed l\u00fd nhi\u1ec1u nh\u00f3m s\u1ed1 li\u1ec7u kh\u00e1c nhau trong m\u1ed9t bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00f2n<\/li>\n<li>Bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00f2n tr\u1edf n\u00ean d\u1ec5 ph\u00e2n t\u00edch h\u01a1n khi s\u1ed1 l\u01b0\u1ee3ng nh\u00f3m\u00a0\u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n<\/li>\n<li>Excel c\u00f3 th\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng t\u00ednh to\u00e1n\u00a0v\u00e0 minh h\u1ecda c\u01a1 c\u1ea5u c\u1ee7a t\u1eebng lo\u1ea1i s\u1ed1 li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/li>\n<\/ul>\n<p><strong>\u0110i\u1ec3m tr\u1eeb:<\/strong><\/p>\n<ul>\n<li>Kh\u00f3 so s\u00e1nh k\u00edch th\u01b0\u1edbc c\u1ee7a t\u1eebng mi\u1ebfng gh\u00e9p trong h\u00ecnh<\/li>\n<li>H\u00ecnh s\u1ebd tr\u1edf n\u00ean\u00a0\u0111\u1eb7c l\u1ea1i v\u00e0 co c\u1ee5m h\u01a1n n\u1ebfu nh\u01b0 l\u01b0\u1ee3ng s\u1ed1 li\u1ec7u ng\u00e0y m\u1ed9t nhi\u1ec1u<\/li>\n<li>Ch\u1ec9 d\u00f9ng v\u1edbi m\u1ee5c \u0111\u00edch so s\u00e1nh c\u01a1 c\u1ea5u c\u1ee7a c\u00e1c th\u00e0nh ph\u1ea7n trong to\u00e0n b\u1ed9 d\u1eef li\u1ec7u chung m\u00e0 th\u00f4i<\/li>\n<li>Kh\u00f4ng th\u1ec3 hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c di\u1ec5n bi\u1ebfn thay\u00a0\u0111\u1ed5i c\u1ee7a s\u1ed1 li\u1ec7u theo th\u1eddi gian<\/li>\n<\/ul>\n<p><strong>L\u1eddi khuy\u00ean<\/strong><\/p>\n<ul>\n<li>H\u1ea1n ch\u1ebf \u00a0s\u1ed1 l\u01b0\u1ee3ng nh\u00f3m s\u1ed1 li\u1ec7u\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong bi\u1ec3u\u00a0\u0111\u1ed3<\/li>\n<li>Tr\u00e1nh c\u00e1c bi\u1ebfn s\u1ed1 d\u1ea1ng 3D<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5 minh h\u1ecda: <\/strong>Kh\u1ea3o s\u00e1t v\u1ec1 h\u01b0\u01a1ng v\u1ecb kem\u00a0\u0111\u01b0\u1ee3c\u00a0\u01b0a chu\u1ed9ng nh\u1ea5t<\/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\/2025\/01\/ex101_92019-nho-251.gif\" title=\"ex101_92019-nho-251\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9198\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/survey-results-favorite-ice-cream-flavor-1.png\" width=\"600\" height=\"337\" title=\"survey-results-favorite-ice-cream-flavor-1\"><\/p>\n<p>Bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00f2n l\u00e0 m\u1ed9t trong nh\u1eefng d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3 d\u1ec5 s\u1eed d\u1ee5ng nh\u1ea5t trong Excel, th\u01b0\u1eddng bi\u1ec3u th\u1ecb m\u1ed1i quan h\u1ec7\u00a0c\u1ee7a t\u1eebng th\u00e0nh ph\u1ea7n trong to\u00e0n th\u1ec3 v\u1edbi m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng v\u1eeba ph\u1ea3i c\u00e1c nh\u00f3m d\u1eef li\u1ec7u. Tuy ch\u1ecbu nhi\u1ec1u nh\u1eadn x\u00e9t ti\u00eau c\u1ef1c t\u1eeb c\u00e1c chuy\u00ean gia v\u1ec1 minh h\u1ecda s\u1ed1 li\u1ec7u, bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00f2n v\u1eabn t\u1ecf ra v\u00f4 c\u00f9ng h\u1eefu hi\u1ec7u v\u00e0 g\u1ecdn nh\u1eb9\u00a0\u0111\u1ed1i v\u1edbi c\u00e1c nh\u00f3m d\u1eef li\u1ec7u h\u1ea1n ch\u1ebf (ch\u1ec9 t\u1eeb 2-5 lo\u1ea1i) v\u00e0 c\u01a1 c\u1ea5u\u00a0c\u1ee7a t\u1eebng nh\u00f3m chi\u1ebfm m\u1ed9t ph\u1ea7n\u00a0kh\u00e1 l\u1edbn. V\u00ed d\u1ee5 d\u01b0\u1edbi\u00a0\u0111\u00e2y minh h\u1ecda k\u1ebft qu\u1ea3 kh\u1ea3o s\u00e1t khi \u0111\u01b0\u1ee3c h\u1ecfi \u201c\u0110\u00e2u l\u00e0 h\u01b0\u01a1ng v\u1ecb kem y\u00eau th\u00edch nh\u1ea5t c\u1ee7a b\u1ea1n?\u201d<\/p>\n<p>B\u1ea3ng d\u1eef li\u1ec7u c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9197\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/survey-results-favorite-ice-cream-flavor-data-1.png\" width=\"600\" height=\"373\" title=\"survey-results-favorite-ice-cream-flavor-data-1\"><\/p>\n<p>C\u00f3 th\u1ec3 nh\u1eadn th\u1ea5y r\u1eb1ng trong b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean kh\u00f4ng c\u00f3 s\u1ed1 li\u1ec7u\u00a0t\u00ednh to\u00e1n c\u1ee5 th\u1ec3 c\u01a1 c\u1ea5u c\u1ee7a t\u1eebng h\u01b0\u01a1ng v\u1ecb trong t\u1ed5ng th\u1ec3 t\u1ea5t c\u1ea3 c\u00e1c c\u00e2u tr\u1ea3 l\u1eddi. Vi\u1ec7c t\u00ednh to\u00e1n ph\u1ea7n tr\u0103m n\u00e0y s\u1ebd\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00f2n th\u1ef1c hi\u1ec7n m\u1ed9t c\u00e1ch t\u1ef1\u00a0\u0111\u1ed9ng.<\/p>\n<p>C\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016.html\"><strong>v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/strong><\/a> d\u1ea1ng h\u00ecnh tr\u00f2n<\/p>\n<ul>\n<li>Khoanh v\u00f9ng d\u1eef li\u1ec7u v\u00e0 tr\u00ean th\u00e0nh Ribbon ch\u1ecdn l\u1ec7nh Insert -&gt; Pie chart<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9199\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/survey-results-favorite-ice-cream-flavor-ribbon-insert-pie-1.png\" width=\"600\" height=\"132\" title=\"survey-results-favorite-ice-cream-flavor-ribbon-insert-pie-1\"><\/p>\n<ul>\n<li>Ch\u1ecdn bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u1ea7u ti\u00ean trong m\u1ee5c bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00f2n d\u1ea1ng\u00a02 chi\u1ec1u<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9200 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/survey-results-favorite-ice-cream-flavor-ribbon-select-2d-pie-1.png\" width=\"172\" height=\"264\" title=\"survey-results-favorite-ice-cream-flavor-ribbon-select-2d-pie-1\"><\/p>\n<ul>\n<li>Bi\u1ec3u\u00a0\u0111\u1ed3 s\u1ebd xu\u1ea5t hi\u1ec7n d\u01b0\u1edbi d\u1ea1ng nh\u01b0 sau:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9201\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/survey-results-favorite-ice-cream-flavor-chart-after-insert-1.png\" width=\"600\" height=\"359\" title=\"survey-results-favorite-ice-cream-flavor-chart-after-insert-1\"><\/p>\n<ul>\n<li>X\u00f3a\u00a0\u0111i ph\u1ea7n ch\u00fa th\u00edch<\/li>\n<li>Th\u00eam t\u00ean nh\u00e3n cho d\u1eef li\u1ec7u<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9202\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/survey-results-favorite-ice-cream-flavor-add-data-labels-1.png\" width=\"600\" height=\"276\" title=\"survey-results-favorite-ice-cream-flavor-add-data-labels-1\"><\/p>\n<ul>\n<li>Ch\u1ecdn t\u00ean nh\u00e3n d\u1eef li\u1ec7u, thi\u1ebft l\u1eadp\u00a0\u0111\u1ec3 ph\u1ea7n t\u00ean minh h\u1ecda c\u0169ng nh\u01b0 hi\u1ec7n s\u1ed1 ph\u1ea7n tr\u0103m c\u1ee5 th\u1ec3 cho t\u1eebng nh\u00f3m,\u00a0\u0111\u1ed3ng th\u1eddi c\u00e0i\u00a0\u0111\u1eb7t \u0111\u01b0\u1eddng\u00a0ph\u00e2n t\u00e1ch mi\u1ebfng gh\u00e9p th\u00e0nh m\u1ed9t\u00a0\u0111\u01b0\u1eddng m\u1edbi (new line)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9203 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/survey-results-favorite-ice-cream-flavor-format-data-labels-1.png\" width=\"291\" height=\"594\" title=\"survey-results-favorite-ice-cream-flavor-format-data-labels-1\"><\/p>\n<ul>\n<li>Thi\u1ebft l\u1eadp\u00a0m\u00e0u s\u1eafc c\u1ee7a ch\u1eef vi\u1ebft l\u00e0 m\u00e0u tr\u1eafng (n\u1ebfu th\u00edch)<\/li>\n<\/ul>\n<ul>\n<li>Cu\u1ed1i c\u00f9ng ta c\u00f3 bi\u1ec3u\u00a0\u0111\u1ed3 ho\u00e0n ch\u1ec9nh nh\u01b0 sau:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9204\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/survey-results-favorite-ice-cream-flavor-chart-final-1.png\" width=\"600\" height=\"359\" title=\"survey-results-favorite-ice-cream-flavor-chart-final-1\"><\/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\/2025\/01\/ex101_92019-nho-251.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11014,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11013","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\/11013","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=11013"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11013\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11014"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}