{"id":4732,"date":"2024-12-08T07:31:46","date_gmt":"2024-12-08T07:31:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/ung-dung-ham-countifs-trong-bao-cao-theo-ty-le-va-ve-bieu-do-hinh-tron\/"},"modified":"2024-12-08T07:31:46","modified_gmt":"2024-12-08T07:31:46","slug":"ung-dung-ham-countifs-trong-bao-cao-theo-ty-le-va-ve-bieu-do-hinh-tron","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/ung-dung-ham-countifs-trong-bao-cao-theo-ty-le-va-ve-bieu-do-hinh-tron\/","title":{"rendered":"\u1ee8ng d\u1ee5ng h\u00e0m Countifs trong b\u00e1o c\u00e1o theo t\u1ef7 l\u1ec7 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n l\u00e0 d\u1ea1ng bi\u1ec3u \u0111\u1ed3 \u0111\u1eb7c tr\u01b0ng trong vi\u1ec7c bi\u1ec3u di\u1ec5n b\u00e1o c\u00e1o theo t\u1ef7 l\u1ec7, t\u1ef7 tr\u1ecdng c\u1ee7a m\u1ed7i \u0111\u1ed1i t\u01b0\u1ee3ng trong t\u1ed5ng s\u1ed1. Y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o theo t\u1ef7 l\u1ec7 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n \u0111\u1ec3 bi\u1ec3u di\u1ec5n l\u00e0 y\u00eau c\u1ea7u r\u1ea5t th\u01b0\u1eddng g\u1eb7p khi l\u00e0m vi\u1ec7c tr\u00ean Excel. Nh\u01b0ng b\u1ea1n c\u00f3 bi\u1ebft r\u1eb1ng m\u1ea5u ch\u1ed1t nh\u1ea5t \u0111\u1ec3 c\u00f3 th\u1ec3 \u0111\u01b0a ra k\u1ebft qu\u1ea3 cho b\u00e1o c\u00e1o \u0111\u00f3 ch\u00ednh l\u00e0 vi\u1ec7c s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-countifs-dem-theo-nhieu-dieu-kien.html\">h\u00e0m Countifs<\/a> \u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m Countifs trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19220\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-countifs-pie-chart.png\" width=\"850\" height=\"488\" title=\"data-countifs-pie-chart\"><\/p>\n<p>Tr\u00ean \u0111\u00e2y ch\u00ednh l\u00e0 c\u00e1c b\u01b0\u1edbc \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1eeb 1 b\u1ea3ng d\u1eef li\u1ec7u l\u1eadp ra b\u00e1o c\u00e1o d\u1ea1ng \u0111\u1ebfm. T\u1eeb b\u00e1o c\u00e1o d\u1ea1ng \u0111\u1ebfm n\u00e0y l\u1eadp th\u00e0nh b\u00e1o d\u1ea1ng t\u1ef7 l\u1ec7 %, sau \u0111\u00f3 v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n bi\u1ec3u di\u1ec5n k\u1ebft qu\u1ea3 cho t\u1eebng l\u1edbp. Ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m n\u00e0y nh\u00e9:<\/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-67554b6200321\" 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\/ung-dung-ham-countifs-trong-bao-cao-theo-ty-le-va-ve-bieu-hinh-tron.html#1_Phan_tich_yeu_cau_de_bai\" title=\"1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u \u0111\u1ec1 b\u00e0i\">1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u \u0111\u1ec1 b\u00e0i<\/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\/ung-dung-ham-countifs-trong-bao-cao-theo-ty-le-va-ve-bieu-hinh-tron.html#2_Su_dung_ham_Countifs_de_lap_bao_cao_dang_dem_theo_nhieu_dieu_kien\" title=\"2. S\u1eed d\u1ee5ng h\u00e0m Countifs \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o d\u1ea1ng \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\">2. S\u1eed d\u1ee5ng h\u00e0m Countifs \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o d\u1ea1ng \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/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\/ung-dung-ham-countifs-trong-bao-cao-theo-ty-le-va-ve-bieu-hinh-tron.html#3_Cach_chuyen_bao_cao_dang_dem_ve_dang_ty_le\" title=\"3. C\u00e1ch chuy\u1ec3n b\u00e1o c\u00e1o d\u1ea1ng \u0111\u1ebfm v\u1ec1 d\u1ea1ng t\u1ef7 l\u1ec7 %\">3. C\u00e1ch chuy\u1ec3n b\u00e1o c\u00e1o d\u1ea1ng \u0111\u1ebfm v\u1ec1 d\u1ea1ng t\u1ef7 l\u1ec7 %<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-ham-countifs-trong-bao-cao-theo-ty-le-va-ve-bieu-hinh-tron.html#4_Cach_ve_bieu_do_ty_le_tren_Excel\" title=\"4. C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3\u00a0t\u1ef7 l\u1ec7 tr\u00ean Excel\">4. C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3\u00a0t\u1ef7 l\u1ec7 tr\u00ean Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Phan_tich_yeu_cau_de_bai\"><\/span>1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u \u0111\u1ec1 b\u00e0i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u01b0\u1edbc h\u1ebft c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i \u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2M5dqHj\">http:\/\/bit.ly\/2M5dqHj<\/a><\/p>\n<p>Trong file m\u1eabu ch\u00fang ta c\u00f3 d\u1eef li\u1ec7u ban \u0111\u1ea7u l\u00e0 b\u1ea3ng t\u1eeb A1:C31, g\u1ed3m 3 c\u1ed9t H\u1ecdc sinh \u2013 L\u1edbp \u2013 X\u1ebfp lo\u1ea1i, t\u01b0\u01a1ng \u1ee9ng v\u1edbi 30 h\u1ecdc vi\u00ean \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp ng\u1eabu nghi\u00ean theo t\u1eebng l\u1edbp.<\/p>\n<p>Y\u00eau c\u1ea7u c\u1ee7a b\u00e0i t\u1eadp n\u00e0y l\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3 t\u1ef7 l\u1ec7 x\u1ebfp lo\u1ea1i cho t\u1eebng l\u1edbp. Y\u00eau c\u1ea7u n\u00e0y c\u00f3 th\u1ec3 ph\u00e2n t\u00edch nh\u01b0 sau:<\/p>\n<ul>\n<li>M\u1ee5c \u0111\u00edch cu\u1ed1i c\u00f9ng l\u00e0 ra 2 bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n t\u01b0\u01a1ng \u1ee9ng cho m\u1ed7i l\u1edbp. Trong m\u1ed7i bi\u1ec3u \u0111\u1ed3 th\u1ec3 hi\u1ec7n t\u1ef7 l\u1ec7 gi\u1eefa c\u00e1c \u0111i\u1ec3m x\u1ebfp lo\u1ea1i. Bi\u1ec3u \u0111\u1ed3 c\u00f3 th\u1ec3 v\u1ebd b\u1eb1ng Insert\/Chart\/Pie chart.<\/li>\n<li>T\u1ef7 l\u1ec7 gi\u1eefa c\u00e1c \u0111i\u1ec3m x\u1ebfp lo\u1ea1i t\u00ednh nh\u01b0 th\u1ebf n\u00e0o? C\u1ea7n t\u00ednh ra \u0111\u01b0\u1ee3c m\u1ed7i l\u1edbp c\u00f3 bao nhi\u00eau h\u1ecdc sinh, trong \u0111\u00f3 bao nhi\u00eau h\u1ecdc\u00a0sinh x\u1ebfp lo\u1ea1i A, bao nhi\u00eau h\u1ecdc\u00a0sinh x\u1ebfp lo\u1ea1i B, lo\u1ea1i C, lo\u1ea1i D. T\u1ef7 l\u1ec7 s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh theo s\u1ed1 h\u1ecdc\u00a0sinh m\u1ed7i lo\u1ea1i chia cho t\u1ed5ng s\u1ed1 h\u1ecdc sinh c\u1ee7a l\u1edbp \u0111\u00f3.<\/li>\n<li>\u0110\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c t\u1ed5ng s\u1ed1 h\u1ecdc sinh, s\u1ed1 h\u1ecdc sinh \u0111\u01b0\u1ee3c x\u1ebfp lo\u1ea1i theo t\u1eebng m\u1ee9c \u0111i\u1ec3m th\u00ec c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m COUNTIFS, b\u1edfi \u1edf \u0111\u00e2y c\u00f3 2 \u0111i\u1ec1u ki\u1ec7n: <strong>L\u1edbp<\/strong> v\u00e0 <strong>X\u1ebfp lo\u1ea1i<\/strong><\/li>\n<\/ul>\n<p>Do \u0111\u00f3 khi th\u1ef1c hi\u1ec7n ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n theo th\u1ee9 t\u1ef1 t\u1eeb d\u01b0\u1edbi l\u00ean c\u1ee7a logic tr\u00ean.<\/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-385.gif\" title=\"ex101_92019-nho-385\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"2_Su_dung_ham_Countifs_de_lap_bao_cao_dang_dem_theo_nhieu_dieu_kien\"><\/span>2. S\u1eed d\u1ee5ng h\u00e0m Countifs \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o d\u1ea1ng \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta x\u00e1c \u0111\u1ecbnh c\u00e1c th\u00e0nh ph\u1ea7n trong h\u00e0m COUNTIFS \u0111\u1eb7t t\u1ea1i \u00f4 F2 nh\u01b0 sau:<\/p>\n<ul>\n<li>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n th\u1ee9 1 (criteria_range1): t\u01b0\u01a1ng \u1ee9ng v\u1edbi L\u1edbp, l\u00e0 v\u00f9ng B2:B31<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n th\u1ee9 1 (criteria1): \u0111i\u1ec1u ki\u1ec7n n\u00e0y n\u1eb1m trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n th\u1ee9 1, l\u00e0 l\u1edbp 12A1 t\u1ea1i \u00f4 E2<\/li>\n<li>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n th\u1ee9 2\u00a0(criteria_range2): t\u01b0\u01a1ng \u1ee9ng v\u1edbi X\u1ebfp lo\u1ea1i, l\u00e0 v\u00f9ng C2:C31<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n th\u1ee9 2 (criteria2): \u0111i\u1ec1u ki\u1ec7n n\u00e0y n\u1eb1m trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n th\u1ee9 2, l\u00e0 lo\u1ea1i A\u00a0t\u1ea1i \u00f4\u00a0F1<\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19222\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countifs-2-dieu-kien-chua-co-dinh-vung.png\" width=\"581\" height=\"80\" title=\"countifs-2-dieu-kien-chua-co-dinh-vung\"><\/p>\n<p>Tuy nhi\u00ean c\u00f4ng th\u1ee9c tr\u00ean kh\u00f4ng th\u1ec3 \u00e1p d\u1ee5ng ngay sang c\u00e1c \u00f4 kh\u00e1c (G2, H2\u2026F3,G3\u2026) b\u1edfi c\u00e1c v\u00f9ng tham chi\u1ebfu trong c\u00f4ng th\u1ee9c ch\u01b0a \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh. Khi sao ch\u00e9p s\u1ebd b\u1ecb thay \u0111\u1ed5i t\u1ecda \u0111\u1ed9 tham chi\u1ebfu d\u1eabn t\u1edbi k\u1ebft qu\u1ea3 b\u1ecb sai.<\/p>\n<p>C\u00e1ch c\u1ed1 \u0111\u1ecbnh nh\u01b0 sau:<\/p>\n<ul>\n<li>C\u00e1c v\u00f9ng Range l\u00e0 tham chi\u1ebfu b\u00ean ngo\u00e0i b\u00e1o c\u00e1o, do \u0111\u00f3 s\u1ebd c\u1ed1 \u0111\u1ecbnh ho\u00e0n to\u00e0n (c\u00f3 d\u1ea5u $ \u1edf tr\u01b0\u1edbc t\u00ean c\u1ed9t, t\u00ean d\u00f2ng =&gt; T\u01b0\u01a1ng \u1ee9ng v\u1edbi vi\u1ec7c \u0111\u1eb7t chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed B2:B31 v\u00e0 b\u1ea5m ph\u00edm F4 m\u1ed9t l\u1ea7n \u0111\u1ec3 chuy\u1ec3n sang $B$2:$B$31. T\u01b0\u01a1ng t\u1ef1 v\u1edbi C2:C31<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 1 l\u00e0 E2. \u0110i\u1ec1u ki\u1ec7n \u1edf c\u1ed9t E c\u00f3 \u0111\u1eb7c \u0111i\u1ec3m l\u00e0 t\u1ed5 ch\u1ee9c tr\u00ean 1 c\u1ed9t, nhi\u1ec1u d\u00f2ng. Do \u0111\u00f3 khi sao ch\u00e9p c\u00f4ng th\u1ee9c c\u1ea7n c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ec3 kh\u00f4ng thay \u0111\u1ed5i c\u1ed9t E, c\u00f2n c\u00e1c d\u00f2ng c\u00f3 th\u1ec3 thay \u0111\u1ed5i theo d\u00f2ng ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng \u1ee9ng n\u00ean kh\u00f4ng c\u1ed1 \u0111\u1ecbnh d\u00f2ng (t\u1ea1i v\u1ecb tr\u00ed E2 trong c\u00f4ng th\u1ee9c s\u1ebd b\u1ea5m ph\u00edm F4\u00a0ba l\u1ea7n \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u1ea1ng $E2)<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 2 l\u00e0 F1. \u0110i\u1ec1u ki\u1ec7n \u1edf d\u00f2ng 1 c\u00f3 \u0111\u1eb7c \u0111i\u1ec3m l\u00e0 t\u1ed5 ch\u1ee9c tr\u00ean 1 d\u00f2ng, nhi\u1ec1u c\u1ed9t. Do \u0111\u00f3 c\u1ea7n c\u1ed1 \u0111\u1ecbnh d\u00f2ng 1 n\u00e0y m\u00e0 kh\u00f4ng c\u1ed1 \u0111\u1ecbnh c\u1ed9t F (t\u1ea1i v\u1ecb tr\u00ed F1 trong c\u00f4ng th\u1ee9c s\u1ebd b\u1ea5m ph\u00edm F4\u00a0hai l\u1ea7n \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u1ea1ng F$1)<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 \u0111\u00fang s\u1ebd l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19223\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countifs-2-dieu-kien-co-co-dinh-vung.png\" width=\"665\" height=\"110\" title=\"countifs-2-dieu-kien-co-co-dinh-vung\"><\/p>\n<p>B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd sao ch\u00e9p c\u00f4ng th\u1ee9c n\u00e0y sang t\u1edbi c\u1ed9t I, sao ch\u00e9p xu\u1ed1ng d\u00f2ng 3 v\u00e0 t\u00ednh t\u1ed5ng s\u1ed1 trong c\u1ed9t J.<\/p>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19225\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countifs-2-dieu-kien-ket-qua.png\" width=\"388\" height=\"76\" title=\"countifs-2-dieu-kien-ket-qua\"><\/p>\n<p>\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Cach_chuyen_bao_cao_dang_dem_ve_dang_ty_le\"><\/span>3. C\u00e1ch chuy\u1ec3n b\u00e1o c\u00e1o d\u1ea1ng \u0111\u1ebfm v\u1ec1 d\u1ea1ng t\u1ef7 l\u1ec7 %<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 nh\u01b0 \u0111\u00e3 ph\u00e2n t\u00edch \u1edf tr\u00ean l\u00e0:\u00a0T\u1ef7 l\u1ec7 s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh theo s\u1ed1 h\u1ecdc\u00a0sinh\u00a0m\u1ed7i lo\u1ea1i chia cho t\u1ed5ng s\u1ed1 h\u1ecdc sinh c\u1ee7a l\u1edbp \u0111\u00f3<\/p>\n<p>Do d\u1eef li\u1ec7u \u1edf d\u1ea1ng % n\u00ean c\u1ea7n \u0111\u1ecbnh d\u1ea1ng Format Cells l\u00e0 d\u1ea1ng Percentage, c\u00f3 th\u1ec3 d\u00f9ng 2 s\u1ed1 sau d\u1ea5u ph\u1ea9y<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19227\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/convert-report-count-to-percent.png\" width=\"950\" height=\"255\" title=\"convert-report-count-to-percent\"><\/p>\n<p>L\u01b0u \u00fd:<\/p>\n<ul>\n<li>\u00d4 J2 l\u00e0 \u00f4 ch\u1ee9a d\u1eef li\u1ec7u l\u00e0 t\u1ed5ng s\u1ed1 h\u1ecdc sinh l\u1edbp 12A1. Do \u0111\u00f3 c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh \u00f4 n\u00e0y trong ph\u00e9p t\u00ednh F2\/J2 \u0111\u1ec3 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh t\u1ef7 l\u1ec7 % sang c\u00e1c \u00f4 kh\u00e1c.<\/li>\n<li>Khi t\u00ednh cho l\u1edbp 12A2 th\u00ec ph\u1ea3i thay \u0111\u1ed5i J2 th\u00e0nh J3.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c s\u1ebd l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19229\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/convert-report-count-to-percent-ket-qua.png\" width=\"484\" height=\"207\" title=\"convert-report-count-to-percent-ket-qua\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Cach_ve_bieu_do_ty_le_tren_Excel\"><\/span>4. C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3\u00a0t\u1ef7 l\u1ec7 tr\u00ean Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f9ng \u00f4n l\u1ea1i m\u1ed9t ch\u00fat <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016.html\"><strong>c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/strong><\/a>. C\u1ee5 th\u1ec3 l\u00e0 d\u1ea1ng bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n. Trong th\u1ebb Insert ch\u1ecdn Chart. Sau \u0111\u00f3 ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 l\u00e0 h\u00ecnh tr\u00f2n (pie chart) . \u0110\u00e2y l\u00e0 d\u1ea1ng bi\u1ec3u \u0111\u1ed3 \u0111\u1eb7c tr\u01b0ng \u0111\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3 t\u1ef7 l\u1ec7.<\/p>\n<p>Khi v\u1ebd bi\u1ec3u \u0111\u1ed3 th\u00ec s\u1ebd xu\u1ea5t hi\u1ec7n\u00a0th\u1ebb\u00a0Chart tools tr\u00ean thanh c\u00f4ng c\u1ee5. Ch\u1ecdn Select Data<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19232\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chart-tools-select-data.png\" width=\"551\" height=\"190\" title=\"chart-tools-select-data\"><\/p>\n<p>L\u1ef1a ch\u1ecdn Data t\u01b0\u01a1ng \u1ee9ng cho t\u1eebng bi\u1ec3u \u0111\u1ed3. \u1ede \u0111\u00e2y ch\u00fang ta c\u1ea7n v\u1ebd 2 bi\u1ec3u \u0111\u1ed3. Sau \u0111\u00e2y l\u00e0 h\u00ecnh h\u01b0\u1edbng d\u1eabn c\u00e1ch ch\u1ecdn d\u1eef li\u1ec7u \u0111\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3 cho l\u1edbp 12A2:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19230\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pie-chart-from-report-percentage.png\" width=\"1204\" height=\"407\" title=\"pie-chart-from-report-percentage\"><\/p>\n<p>Nh\u01b0 v\u1eady th\u00f4ng qua b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-countifs-dem-theo-nhieu-dieu-kien.html\">h\u00e0m COUNTIFS<\/a> trong vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o \u0111\u1ea1ng \u0111\u1ebfm, ph\u1ee5c v\u1ee5 cho vi\u1ec7c v\u1ebd <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html\">bi\u1ec3u \u0111\u1ed3 ph\u00e2n t\u00edch t\u1ef7 l\u1ec7<\/a>.<\/p>\n<p>Tham kh\u1ea3o:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html\">T\u00f9y ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 Excel: th\u00eam ti\u00eau \u0111\u1ec1, tr\u1ee5c, ch\u00fa th\u00edch, nh\u00e3n d\u1eef li\u1ec7u v\u00e0 nhi\u1ec1u th\u1ee9 kh\u00e1c<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2K7s43w\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/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-385.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4733,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4732","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4732","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=4732"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4732\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4733"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}