{"id":10331,"date":"2025-01-13T15:26:05","date_gmt":"2025-01-13T15:26:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/13\/huong-dan-cach-ve-bieu-do-hinh-tron-khi-du-lieu-chenh-lech-lon\/"},"modified":"2025-01-13T15:26:05","modified_gmt":"2025-01-13T15:26:05","slug":"huong-dan-cach-ve-bieu-do-hinh-tron-khi-du-lieu-chenh-lech-lon","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/13\/huong-dan-cach-ve-bieu-do-hinh-tron-khi-du-lieu-chenh-lech-lon\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n khi d\u1eef li\u1ec7u ch\u00eanh l\u1ec7ch l\u1edbn"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Vi\u1ec7c bi\u1ec3u di\u1ec5n c\u00e1c d\u1eef li\u1ec7u c\u00f3 s\u1ef1 ch\u00eanh l\u1ec7ch l\u1edbn tr\u00ean m\u1ed9t bi\u1ec3u \u0111\u1ed3 th\u01b0\u1eddng khi\u1ebfn ch\u00fang ta g\u1eb7p kh\u00f3.\u00a0Ph\u1ea3i b\u1ed1 c\u1ee5c th\u1ebf n\u00e0o cho h\u1ee3p l\u00fd? C\u00f3 c\u00e1c d\u1ea1ng bi\u1ec3u \u0111\u1ed3 n\u00e0o? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u v\u1ec1 ch\u1ee7 \u0111\u1ec1 n\u00e0y nh\u00e9.<\/em><\/p>\n<p>X\u00e9t v\u00ed d\u1ee5 sau:<\/p>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u th\u1ec3 hi\u1ec7n doanh s\u1ed1 c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20281\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/data-ve-bieu-do-chenh-lech-lon.png\" width=\"240\" height=\"346\" title=\"data-ve-bieu-do-chenh-lech-lon\"><\/p>\n<p><strong>Y\u00eau c\u1ea7u<\/strong>: V\u1ebd bi\u1ec3u \u0111\u1ed3 th\u1ec3 hi\u1ec7n t\u1ef7 l\u1ec7 doanh s\u1ed1 c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean trong t\u1ed5ng s\u1ed1 to\u00e0n c\u00f4ng ty.<\/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-6785308c27b1f\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-tron-khi-du-lieu-chenh-lech-lon.html#Dac_diem_du_lieu\" title=\"\u0110\u1eb7c \u0111i\u1ec3m d\u1eef li\u1ec7u\">\u0110\u1eb7c \u0111i\u1ec3m d\u1eef li\u1ec7u<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-tron-khi-du-lieu-chenh-lech-lon.html#1_Loc_bo_cac_gia_tri_trung_trong_cot_Nhan_vien\" title=\"1. L\u1ecdc b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng trong c\u1ed9t Nh\u00e2n vi\u00ean\">1. L\u1ecdc b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng trong c\u1ed9t Nh\u00e2n vi\u00ean<\/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\/huong-dan-cach-ve-bieu-do-hinh-tron-khi-du-lieu-chenh-lech-lon.html#2_Tinh_ket_qua_doanh_so_theo_tung_nhan_vien\" title=\"2. T\u00ednh k\u1ebft qu\u1ea3 doanh s\u1ed1 theo t\u1eebng nh\u00e2n vi\u00ean\">2. T\u00ednh k\u1ebft qu\u1ea3 doanh s\u1ed1 theo t\u1eebng nh\u00e2n vi\u00ean<\/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\/huong-dan-cach-ve-bieu-do-hinh-tron-khi-du-lieu-chenh-lech-lon.html#3_Sap_xep_du_lieu_theo_thu_tu\" title=\"3. S\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1\">3. S\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-tron-khi-du-lieu-chenh-lech-lon.html#Lua_chon_bieu_do_va_ve_bieu_do\" title=\"L\u1ef1a ch\u1ecdn bi\u1ec3u \u0111\u1ed3 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3\">L\u1ef1a ch\u1ecdn bi\u1ec3u \u0111\u1ed3 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-tron-khi-du-lieu-chenh-lech-lon.html#Bieu_do_hinh_tron\" title=\"Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\">Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-tron-khi-du-lieu-chenh-lech-lon.html#Tuy_chinh_noi_dung_bieu_do\" title=\"T\u00f9y ch\u1ec9nh n\u1ed9i dung bi\u1ec3u \u0111\u1ed3\">T\u00f9y ch\u1ec9nh n\u1ed9i dung bi\u1ec3u \u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-tron-khi-du-lieu-chenh-lech-lon.html#Thiet_lap_cach_bo_cuc_hinh_dang_bieu_do\" title=\"Thi\u1ebft l\u1eadp c\u00e1ch b\u1ed1 c\u1ee5c, h\u00ecnh d\u00e1ng bi\u1ec3u \u0111\u1ed3\">Thi\u1ebft l\u1eadp c\u00e1ch b\u1ed1 c\u1ee5c, h\u00ecnh d\u00e1ng bi\u1ec3u \u0111\u1ed3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dac_diem_du_lieu\"><\/span>\u0110\u1eb7c \u0111i\u1ec3m d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi t\u00ecm hi\u1ec3u v\u1ec1 bi\u1ec3u \u0111\u1ed3, ch\u00fang ta c\u1ea7n ph\u1ea3i quan t\u00e2m t\u1edbi vi\u1ec7c d\u1eef li\u1ec7u c\u00f3 \u0111\u1eb7c \u0111i\u1ec3m g\u00ec. D\u1eef li\u1ec7u \u0111\u00f3 \u0111\u00e3 \u1edf d\u1ea1ng t\u1ed5ng h\u1ee3p ch\u01b0a hay v\u1eabn l\u00e0 d\u1eef li\u1ec7u th\u00f4. Trong v\u00ed d\u1ee5 tr\u00ean ch\u00fang ta th\u1ea5y:\u00a0D\u1eef li\u1ec7u c\u00e1c nh\u00e2n vi\u00ean ch\u01b0a ph\u1ea3i l\u00e0 duy nh\u1ea5t. C\u00f3 tr\u01b0\u1eddng h\u1ee3p l\u1eb7p l\u1ea1i t\u00ean nh\u00e2n vi\u00ean \u0111\u00e3 c\u00f3 nh\u01b0ng v\u1edbi doanh s\u1ed1 kh\u00e1c.<\/p>\n<p>=&gt; Nh\u01b0 v\u1eady \u0111\u00e2y l\u00e0 d\u1eef li\u1ec7u th\u00f4. Mu\u1ed1n v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ea7n ph\u1ea3i x\u1eed l\u00fd d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng t\u1ed5ng h\u1ee3p tr\u01b0\u1edbc.<\/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-157.gif\" title=\"ex101_92019-nho-157\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1ch sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Loc_bo_cac_gia_tri_trung_trong_cot_Nhan_vien\"><\/span>1. L\u1ecdc b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng trong c\u1ed9t Nh\u00e2n vi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/p>\n<ul>\n<li>Copy c\u1ed9t Nh\u00e2n vi\u00ean sang c\u1ed9t D (l\u00e0 1 c\u1ed9t tr\u1ed1ng)<\/li>\n<li>T\u1ea1i c\u1ed9t D ch\u1ecdn ch\u1ee9c n\u0103ng <strong>Remove Duplicates<\/strong> trong th\u1ebb <strong>Data<\/strong><\/li>\n<li>Sau khi th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng <strong>Remove Duplicates<\/strong> th\u00ec k\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20283\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/loc-du-lieu-trung-voi-data-remove-duplicates.png\" width=\"1091\" height=\"552\" title=\"loc-du-lieu-trung-voi-data-remove-duplicates\"><\/p>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ky-thuat-loai-bo-gia-tri-trung-lap-trong-danh-sach-excel.html\">H\u01b0\u1edbng d\u1eabn k\u1ef9 thu\u1eadt lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong danh s\u00e1ch Excel<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Tinh_ket_qua_doanh_so_theo_tung_nhan_vien\"><\/span>2. T\u00ednh k\u1ebft qu\u1ea3 doanh s\u1ed1 theo t\u1eebng nh\u00e2n vi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u01b0\u1eddng h\u1ee3p n\u00e0y t\u00ednh theo \u0111i\u1ec1u ki\u1ec7n t\u00ean nh\u00e2n vi\u00ean, do \u0111\u00f3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-tinh-tong-excel.html\">h\u00e0m SUMIF<\/a> \u0111\u1ec3 t\u00ednh:<\/p>\n<p>C\u1ea5u tr\u00fac h\u00e0m =SUMIF(range,criteria,sum_range)<\/p>\n<ul>\n<li>range: c\u1ed9t Nh\u00e2n vi\u00ean (c\u1ed9t A) l\u00e0 n\u01a1i ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n T\u00ean nh\u00e2n vi\u00ean<\/li>\n<li>criteria: \u0111i\u1ec1u ki\u1ec7n t\u00ean nh\u00e2n vi\u00ean t\u1ea1i c\u1ed9t D.<\/li>\n<li>sum_range: v\u00f9ng t\u00ednh t\u1ed5ng l\u00e0 c\u1ed9t Doanh s\u1ed1 (c\u1ed9t B)<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20284\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-du-lieu-bang-sumif-truoc-khi-ve-bieu-do.png\" width=\"838\" height=\"345\" title=\"tong-hop-du-lieu-bang-sumif-truoc-khi-ve-bieu-do\"><\/p>\n<p>Trong b\u1ea3ng k\u1ebft qu\u1ea3 ta th\u1ea5y:<\/p>\n<ul>\n<li>D\u1eef li\u1ec7u c\u00f3 s\u1ef1 ch\u00eanh l\u1ec7ch l\u1edbn khi s\u1ed1 th\u1ea5p nh\u1ea5t l\u00e0 10, s\u1ed1 l\u1edbn nh\u1ea5t l\u00e0 260 (g\u1ea5p 26 l\u1ea7n)<\/li>\n<li>D\u1eef li\u1ec7u ch\u01b0a \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"3_Sap_xep_du_lieu_theo_thu_tu\"><\/span>3. S\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 thu\u1eadn l\u1ee3i h\u01a1n trong vi\u1ec7c v\u1ebd bi\u1ec3u \u0111\u1ed3, ch\u00fang ta c\u1ea7n s\u1eafp x\u1ebfp l\u1ea1i d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp l\u00e0 t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf.<\/p>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/p>\n<ul>\n<li>Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u t\u1ed5ng h\u1ee3p (c\u00f3 bao g\u1ed3m d\u00f2ng ti\u00eau \u0111\u1ec1)<\/li>\n<li>Trong th\u1ebb Data ch\u1ecdn Sort<\/li>\n<li>Trong b\u1ea3ng Sort ch\u1ecdn c\u1ed9t c\u1ea7n s\u1eafp x\u1ebfp l\u00e0 c\u1ed9t Doanh s\u1ed1. Th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp l\u00e0 t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf (Largest to Smallest)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20287\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/data-sap-xep-theo-thu-tu-truoc-khi-ve-bieu-do.png\" width=\"946\" height=\"336\" title=\"data-sap-xep-theo-thu-tu-truoc-khi-ve-bieu-do\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 x\u1eed l\u00fd xong d\u1eef li\u1ec7u \u0111\u1ec3 s\u1eb5n s\u00e0ng cho vi\u1ec7c v\u1ebd bi\u1ec3u \u0111\u1ed3.<\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/sap-xep-du-lieu-theo-nhieu-dieu-kien-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lua_chon_bieu_do_va_ve_bieu_do\"><\/span>L\u1ef1a ch\u1ecdn bi\u1ec3u \u0111\u1ed3 v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Bieu_do_hinh_tron\"><\/span>Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi y\u00eau c\u1ea7u <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>theo t\u1ef7 l\u1ec7, ch\u00fang ta ngh\u0129 ngay t\u1edbi lo\u1ea1i bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n.<\/p>\n<p>D\u1eef li\u1ec7u c\u00f3 s\u1ef1 ch\u00eanh l\u1ec7ch l\u1edbn n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng ch\u1ee9c n\u0103ng v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u00f3 g\u1ed9p nh\u00f3m c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng chi\u1ebfm t\u1ef7 tr\u1ecdng \u00edt.\u00a0C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 n\u00e0y nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n v\u1ebd bi\u1ec3u \u0111\u1ed3 (b\u1ea3ng t\u1ed5ng h\u1ee3p)<\/li>\n<li>Trong th\u1ebb <strong>Insert<\/strong> ch\u1ecdn Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n d\u1ea1ng <strong>Pie of Pie<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20289\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/lua-chon-bieu-do-hinh-tron.png\" width=\"1315\" height=\"595\" title=\"lua-chon-bieu-do-hinh-tron\"><\/p>\n<p>\u0110\u00e2y l\u00e0 d\u1ea1ng bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n, trong \u0111\u00f3 c\u00f3 th\u1ec3 g\u1ed9p nh\u00f3m c\u00e1c ph\u1ea7n d\u1eef li\u1ec7u nh\u1ecf ra 1 bi\u1ec3u \u0111\u1ed3 ri\u00eang \u0111\u1ec3 so s\u00e1nh t\u1ef7 l\u1ec7 gi\u1eefa c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng trong nh\u00f3m nh\u1ecf \u0111\u00f3.<\/p>\n<p>\u0110\u00e2y l\u00e0 d\u1ea1ng bi\u1ec3u \u0111\u1ed3 r\u1ea5t th\u00edch h\u1ee3p khi th\u1ec3 hi\u1ec7n nhi\u1ec1u \u0111\u1ed1i t\u01b0\u1ee3ng, trong \u0111\u00f3 gi\u1eefa c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 s\u1ef1 ch\u00eanh l\u1ec7ch l\u1edbn.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tuy_chinh_noi_dung_bieu_do\"><\/span>T\u00f9y ch\u1ec9nh n\u1ed9i dung bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 hi\u1ec7n s\u1ed1 li\u1ec7u theo t\u1eebng ph\u1ea7n trong bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n, ch\u1ecdn th\u1ebb Chart Tools \/ Design, ch\u1ecdn ti\u1ebfp Add Chart Element\/Data Labels\/Outside End (s\u1ed1 li\u1ec7u n\u1eb1m b\u00ean ngo\u00e0i c\u00e1c ph\u1ea7n c\u1ee7a bi\u1ec3u \u0111\u1ed3)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20291\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bieu-do-the-hien-gia-tri-outside.png\" width=\"1137\" height=\"636\" title=\"bieu-do-the-hien-gia-tri-outside\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_cach_bo_cuc_hinh_dang_bieu_do\"><\/span>Thi\u1ebft l\u1eadp c\u00e1ch b\u1ed1 c\u1ee5c, h\u00ecnh d\u00e1ng bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong 1 trong 2 h\u00ecnh tr\u00f2n, ch\u1ecdn Format Data Series. Trong c\u1eeda s\u1ed5 n\u00e0y ch\u00fang ta c\u00f3:<\/p>\n<ul>\n<li>\u0110\u1ec3 t\u0103ng gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng trong bi\u1ec3u \u0111\u1ed3 nh\u1ecf (other) th\u00ec ch\u00fang ta thay \u0111\u1ed5i t\u1ea1i m\u1ee5c <strong>Values in second plot<\/strong><\/li>\n<li>\u0110\u1ec3 \u0111i\u1ec1u ch\u1ec9nh k\u00edch c\u1ee1 c\u1ee7a bi\u1ec3u \u0111\u1ed3 nh\u1ecf, ch\u00fang ta thay \u0111\u1ed5i t\u1ea1i m\u1ee5c <strong>Second Plot Size\u00a0<\/strong>(t\u1ef7 l\u1ec7 % so v\u1edbi bi\u1ec3u \u0111\u1ed3 l\u1edbn)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20293\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/thiet-lap-hinh-dang-bieu-do.png\" width=\"1022\" height=\"489\" title=\"thiet-lap-hinh-dang-bieu-do\"><\/p>\n<ul>\n<li>Thay \u0111\u1ed5i m\u00e0u s\u1eafc bi\u1ec3u di\u1ec5n c\u00e1c ph\u1ea7n c\u1ee7a bi\u1ec3u \u0111\u1ed3 trong m\u1ee5c\u00a0<strong>Chart Tools\/Design\/Change Colors<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20294\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bieu-do-thay-doi-mau-sac.png\" width=\"988\" height=\"625\" title=\"bieu-do-thay-doi-mau-sac\"><\/p>\n<p>K\u1ebft qu\u1ea3 ch\u00fang ta c\u00f3 bi\u1ec3u \u0111\u1ed3 ho\u00e0n ch\u1ec9nh nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20295\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-bieu-do-hinh-tron.png\" width=\"1529\" height=\"484\" title=\"ket-qua-bieu-do-hinh-tron\"><\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c tr\u00ean n\u1eb1m trong kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2Lf0YYJ\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia c\u1ee7a H\u1ecdc Excel Online<\/a>. Trong kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd v\u1eeba h\u1ecdc \u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 Excel nh\u01b0 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3, v\u1eeba bi\u1ebft c\u00e1ch k\u1ebft h\u1ee3p c\u00e1c ki\u1ebfn th\u1ee9c tr\u00ean \u0111\u1ec3 \u00e1p d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. H\u00e3y tham gia ngay kh\u00f3a h\u1ecdc \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c nhi\u1ec1u \u01b0u \u0111\u00e3i t\u1eeb h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. 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\/2025\/01\/ex101_92019-nho-157.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10332,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10331","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\/10331","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=10331"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10331\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10332"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}