{"id":10177,"date":"2025-01-09T22:13:43","date_gmt":"2025-01-09T22:13:43","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/09\/huong-dan-cach-ve-bieu-do-hinh-tron-thuc-hien-ke-hoach-tren-excel\/"},"modified":"2025-01-09T22:13:43","modified_gmt":"2025-01-09T22:13:43","slug":"huong-dan-cach-ve-bieu-do-hinh-tron-thuc-hien-ke-hoach-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/09\/huong-dan-cach-ve-bieu-do-hinh-tron-thuc-hien-ke-hoach-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n % th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd KPI, theo d\u00f5i ti\u1ebfn \u0111\u1ed9 c\u00f4ng vi\u1ec7c, ch\u00fang ta th\u01b0\u1eddng hay ph\u1ea3i s\u1eed d\u1ee5ng bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 theo d\u00f5i, \u0111\u00e1nh gi\u00e1. Vi\u1ec7c n\u00e0y gi\u00fap theo d\u00f5i m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 tr\u1ef1c quan h\u01a1n. Nh\u01b0ng c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 cho vi\u1ec7c n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? \u0110\u1ec3 c\u00f3 th\u1ec3 \u0111i \u0111\u1ebfn \u0111\u00edch cu\u1ed1i c\u00f9ng l\u00e0 ho\u00e0n th\u00e0nh \u0111\u01b0\u1ee3c bi\u1ec3u \u0111\u1ed3, ch\u00fang ta c\u1ea7n th\u1ef1c hi\u1ec7n theo 2 b\u01b0\u1edbc:<\/p>\n<ul>\n<li>B\u01b0\u1edbc 1 :\u00a0L\u1eadp b\u1ea3ng b\u00e1o c\u00e1o\u00a0% ti\u1ebfn \u0111\u1ed9 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c b\u1eb1ng PivotTable<\/li>\n<li>B\u01b0\u1edbc\u00a02: V\u1ebd bi\u1ec3u \u0111\u1ed3 th\u1ec3 hi\u1ec7n % ti\u1ebfn \u0111\u1ed9 th\u1ef1c hi\u1ec7n<\/li>\n<\/ul>\n<p>Trong b\u00e0i vi\u1ebft\u00a0tr\u01b0\u1edbc ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u xong b\u01b0\u1edbc 1. N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch l\u00e0m c\u00f3 th\u1ec3 xem l\u1ea1i b\u00e0i vi\u1ebft n\u00e0y t\u1ea1i \u0111\u1ecba ch\u1ec9:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bao-cao-tien-do-thuc-hien-cong-viec-bang-pivot-table-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o % ti\u1ebfn \u0111\u1ed9 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c b\u1eb1ng PivotTable tr\u00ean Excel<\/a><\/p>\n<p>M\u1ee5c ti\u00eau c\u1ee7a ch\u00fang ta l\u00e0 ra \u0111\u01b0\u1ee3c 1 b\u1ea3ng b\u00e1o c\u00e1o nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21163\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-phan-tram-thuc-hien-ke-hoach.png\" width=\"748\" height=\"187\" title=\"tinh-phan-tram-thuc-hien-ke-hoach\"><\/p>\n<p>Trong b\u1ea3ng n\u00e0y g\u1ed3m 2 ph\u1ea7n:<\/p>\n<ul>\n<li>A1:B7: B\u1ea3ng k\u1ebft qu\u1ea3 t\u1ea1o b\u1edfi PivotTable<\/li>\n<li>C3:F7: B\u1ea3ng k\u1ebft qu\u1ea3 t\u1ea1o b\u1edfi c\u00f4ng th\u1ee9c, h\u00e0m trong Excel<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 bi\u1ec3u \u0111\u1ed3 sau khi ho\u00e0n th\u00e0nh s\u1ebd c\u00f3 d\u1ea1ng sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21192\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-bieu-do-tron-tien-do-1.png\" width=\"935\" height=\"272\" title=\"ket-qua-bieu-do-tron-tien-do-1\"><\/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-140.gif\" title=\"ex101_92019-nho-140\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu tr\u00ean Excel \u0111\u1ec3 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng cho b\u00e0i vi\u1ebft n\u00e0y t\u1ea1i \u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2OzQxNH\">http:\/\/bit.ly\/2OzQxNH<\/a><\/p>\n<p>T\u1eeb b\u1ea3ng b\u00e1o c\u00e1o n\u00e0y ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh v\u1ebd bi\u00eau \u0111\u1ed3 nh\u01b0 sau:<\/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-67804a170c6e4\" 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-hinh-tron-thuc-hien-ke-hoach-tren-excel.html#Tao_bieu_do_hinh_tron_tu_bang_bao_cao\" title=\"T\u1ea1o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n t\u1eeb b\u1ea3ng\u00a0b\u00e1o c\u00e1o\">T\u1ea1o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n t\u1eeb b\u1ea3ng\u00a0b\u00e1o c\u00e1o<\/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-hinh-tron-thuc-hien-ke-hoach-tren-excel.html#Chon_loai_bieu_do\" title=\"Ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3\">Ch\u1ecdn lo\u1ea1i 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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-hinh-tron-thuc-hien-ke-hoach-tren-excel.html#Noi_dung_bieu_do\" title=\"N\u1ed9i dung bi\u1ec3u \u0111\u1ed3\">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-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-hinh-tron-thuc-hien-ke-hoach-tren-excel.html#Dinh_dang_bieu_do\" title=\"\u0110\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3\">\u0110\u1ecbnh d\u1ea1ng 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-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-hinh-tron-thuc-hien-ke-hoach-tren-excel.html#Buoc_3_Tang_giam_kich_co_cua_duong_bieu_dien\" title=\"B\u01b0\u1edbc 3: T\u0103ng gi\u1ea3m k\u00edch c\u1ee1 c\u1ee7a \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n\">B\u01b0\u1edbc 3: T\u0103ng gi\u1ea3m k\u00edch c\u1ee1 c\u1ee7a \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-hinh-tron-thuc-hien-ke-hoach-tren-excel.html#Trang_tri_hoan_thien_bieu_do\" title=\"Trang tr\u00ed ho\u00e0n thi\u1ec7n bi\u1ec3u \u0111\u1ed3\">Trang tr\u00ed ho\u00e0n thi\u1ec7n bi\u1ec3u \u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-hinh-tron-thuc-hien-ke-hoach-tren-excel.html#Ve_them_bieu_do_cho_cac_khu_vuc_khac\" title=\"V\u1ebd th\u00eam bi\u1ec3u \u0111\u1ed3 cho c\u00e1c khu v\u1ef1c kh\u00e1c\">V\u1ebd th\u00eam bi\u1ec3u \u0111\u1ed3 cho c\u00e1c khu v\u1ef1c kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-hinh-tron-thuc-hien-ke-hoach-tren-excel.html#Thiet_lap_Slicer_de_chon_nhan_vien\" title=\"Thi\u1ebft l\u1eadp Slicer \u0111\u1ec3 ch\u1ecdn nh\u00e2n vi\u00ean\">Thi\u1ebft l\u1eadp Slicer \u0111\u1ec3 ch\u1ecdn nh\u00e2n vi\u00ean<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tao_bieu_do_hinh_tron_tu_bang_bao_cao\"><\/span>T\u1ea1o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n t\u1eeb b\u1ea3ng\u00a0b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Chon_loai_bieu_do\"><\/span>Ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ea7u ti\u1ec1n \u0111\u1ec3 <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>, T\u1ea1i 1 v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 b\u00ean ngo\u00e0i b\u1ea3ng b\u00e1o c\u00e1o, b\u1ea5m ch\u1ecdn th\u1ebb <strong>Insert\/ Chart\/ Pie<\/strong> (bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n)\/<\/p>\n<p>Do bi\u1ec3u \u0111\u1ed3 n\u00e0y c\u00f3 th\u1ec3 c\u00f3 kho\u1ea3ng tr\u1ed1ng b\u00ean trong \u0111\u1ec3 th\u1ec3 hi\u1ec7n con s\u1ed1 % th\u1ef1c hi\u1ec7n, ch\u00fang ta s\u1ebd ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n l\u00e0 lo\u1ea1i <strong>Doughnut<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21193\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/insert-chart-pie-doughnut.png\" width=\"1199\" height=\"455\" title=\"insert-chart-pie-doughnut\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Noi_dung_bieu_do\"><\/span>N\u1ed9i dung bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ti\u1ebfp theo ch\u00fang ta s\u1ebd n\u1ea1p d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u \u0111\u1ed3\u00a0b\u1eb1ng c\u00e1ch b\u1ea5m v\u00e0o m\u1ee5c <strong>Select Data<\/strong> trong th\u1ebb <strong>Chart Tools\/ Design<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21194\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart-design-select-data.png\" width=\"1399\" height=\"191\" title=\"chart-design-select-data\"><\/p>\n<p>Trong c\u1eeda s\u1ed5 Select Data thi\u1ebft l\u1eadp nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: B\u1ea5m v\u00e0o m\u1ee5c Add \u0111\u1ec3 th\u00eam m\u1edbi 1 \u0111\u1ed1i t\u01b0\u1ee3ng<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21195\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart-selectdata-01-add-series.png\" width=\"712\" height=\"406\" title=\"chart-selectdata-01-add-series\"><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: \u0110\u1ec3 chia\u00a0h\u00ecnh tr\u00f2n\u00a0th\u00e0nh 20 ph\u1ea7n b\u1eb1ng nhau, ch\u00fang ta nh\u1eadp 20 gi\u00e1 tr\u1ecb s\u1ed1 1, m\u1ed7i s\u1ed1 c\u00e1ch nhau b\u1edfi 1 d\u1ea5u ph\u1ea9y nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi, sau \u0111\u00f3 b\u1ea5m OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21197\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart-selectdata-01-chia-phan-cho-bieu-do-thanh-20-phan.png\" width=\"763\" height=\"363\" title=\"chart-selectdata-01-chia-phan-cho-bieu-do-thanh-20-phan\"><\/p>\n<p>Trong b\u01b0\u1edbc n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng tham chi\u1ebfu t\u1edbi 20 \u00f4 ch\u1ee9a s\u1ed1 1 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21200\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart-selectdata-01-add-series-trick-20-so-1.png\" width=\"887\" height=\"556\" title=\"chart-selectdata-01-add-series-trick-20-so-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: Th\u00eam \u0111\u1ed1i t\u01b0\u1ee3ng % th\u1ef1c hi\u1ec7n v\u00e0 % ch\u01b0a th\u1ef1c hi\u1ec7n v\u00e0o bi\u1ec3u \u0111\u1ed3<\/p>\n<p>Ti\u1ebfp t\u1ee5c b\u1ea5m Add \u0111\u1ec3 th\u00eam \u0111\u1ed1i t\u01b0\u1ee3ng, trong n\u1ed9i dung n\u00e0y ch\u00fang ta l\u01b0u \u00fd v\u1ebd m\u1ed7i bi\u1ec3u \u0111\u1ed3 l\u00e0 1 khu v\u1ef1c, do \u0111\u00f3 ch\u1ecdn:<\/p>\n<ul>\n<li>Series name: l\u00e0 t\u00ean c\u1ee7a khu v\u1ef1c t\u01b0\u01a1ng \u1ee9ng t\u1eebng bi\u1ec3u \u0111\u1ed3<\/li>\n<li>Series Values: l\u00e0 k\u1ebft qu\u1ea3 % th\u1ef1c hi\u1ec7n v\u00e0 % ch\u01b0a th\u1ef1c hi\u1ec7n c\u1ee7a khu v\u1ef1c \u0111\u00f3<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21201\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart-selectdata-02-add-thuc-hien-chua-thuc-hien.png\" width=\"1140\" height=\"551\" title=\"chart-selectdata-02-add-thuc-hien-chua-thuc-hien\"><\/p>\n<p>Sau khi ho\u00e0n th\u00e0nh c\u00e1c n\u1ed9i dung tr\u00ean, ch\u00fang ta s\u1ebd\u00a0chuy\u1ec3n sang ph\u1ea7n \u0111\u1ecbnh d\u1ea1ng cho bi\u1ec3u \u0111\u1ed3<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_bieu_do\"><\/span>\u0110\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: T\u00f4 m\u00e0u c\u00e1c th\u00e0nh ph\u1ea7n trong bi\u1ec3u \u0111\u1ed3<\/p>\n<p>B\u1ea5m ch\u1ecdn\u00a0ph\u1ea7n b\u00ean trong\u00a0c\u1ee7a h\u00ecnh tr\u00f2n (ph\u1ea7n chia 20 ph\u1ea7n) v\u00e0 b\u1ea5m chu\u1ed9t ph\u1ea3i ch\u1ecdn Format Data Series (l\u01b0u \u00fd khi ch\u1ecdn \u0111\u00fang m\u1ee5c n\u00e0y th\u00ec s\u1ebd xu\u1ea5t hi\u1ec7n c\u00e1c v\u00f2ng tr\u00f2n nh\u1ecf bao quanh t\u1eebng m\u1ea3ng m\u00e0u trong bi\u1ec3u \u0111\u1ed3)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21202\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart-data01-format-data-series.png\" width=\"520\" height=\"455\" title=\"chart-data01-format-data-series\"><\/p>\n<p>Trong ph\u1ea7n Format Data Series ch\u1ecdn ph\u1ea7n t\u00f4 m\u00e0u, ch\u1ecdn 1 m\u00e0u c\u01a1 b\u1ea3n trong m\u1ee5c Color.<\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta ch\u1ecdn m\u00e0u xanh Blue, Accent 1<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21203\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart-data01-format-data-series-change-color.png\" width=\"718\" height=\"457\" title=\"chart-data01-format-data-series-change-color\"><\/p>\n<p>L\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi v\u00f2ng tr\u00f2n b\u00ean ngo\u00e0i, trong \u0111\u00f3 c\u00e1c m\u00e0u \u0111\u01b0\u1ee3c ch\u1ecdn nh\u01b0 sau:<\/p>\n<ul>\n<li>Ph\u1ea7n \u0111\u00e3 th\u1ef1c hi\u1ec7n: ch\u1ecdn No Fill<\/li>\n<li>Ph\u1ea7n ch\u01b0a th\u1ef1c hi\u1ec7n: ch\u1ecdn m\u00e0u tr\u1eafng, <strong>Transparency<\/strong> ch\u1ecdn kho\u1ea3ng <strong>20%<\/strong><\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: L\u1ed3ng gh\u00e9p 2 \u0111\u01b0\u1eddng tr\u00f2n v\u00e0o nhau<\/p>\n<p>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o 1 v\u00f2ng tr\u00f2n b\u1ea5t k\u1ef3, ch\u1ecdn <strong>Change Series Chart Type<\/strong><\/p>\n<p>Trong c\u1eeda s\u1ed5 Change Series Chart Type ch\u1ecdn 1 \u0111\u1ed1i t\u01b0\u1ee3ng b\u1ea5t k\u1ef3 v\u00e0 \u0111\u00e1nh d\u1ea5u t\u00edch ch\u1ecdn v\u00e0o m\u1ee5c Secondary Axis. V\u00ed d\u1ee5 ch\u00fang ta ch\u1ecdn H\u00e0 N\u1ed9i. Sau khi ch\u1ecdn th\u00ec ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21204\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart-change-series-chart-type-doughnut.png\" width=\"794\" height=\"751\" title=\"chart-change-series-chart-type-doughnut\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_3_Tang_giam_kich_co_cua_duong_bieu_dien\"><\/span>B\u01b0\u1edbc 3: T\u0103ng gi\u1ea3m k\u00edch c\u1ee1 c\u1ee7a \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc ph\u1ea7n v\u00f2ng tr\u00f2n tr\u1eafng trong t\u00e2m c\u1ee7a bi\u1ec3u \u0111\u1ed3<\/p>\n<p>B\u1ea5m ch\u1ecdn v\u00e0o \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n c\u1ee7a bi\u1ec3u \u0111\u1ed3, ch\u1ecdn Format Data Series =&gt; Ch\u1ecdn Series Option (ph\u1ea7n c\u00f3 k\u00fd hi\u1ec7u 3 c\u1ed9t).<\/p>\n<p>Trong m\u1ee5c n\u00e0y t\u00ecm t\u1edbi ph\u1ea7n Doughnut Hole Size v\u00e0 t\u0103ng\/ gi\u1ea3m k\u00edch c\u1ee1 c\u1ee7a ph\u1ea7n n\u00e0y theo \u00fd mu\u1ed1n.<\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta ch\u1ecdn 60%<\/p>\n<p>\u00c1p d\u1ee5ng cho c\u1ea3 2 \u0111\u01b0\u1eddng tr\u00f2n, ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21205\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart-data01-format-data-series-hold-size.png\" width=\"724\" height=\"363\" title=\"chart-data01-format-data-series-hold-size\"><\/p>\n<p>Trong bi\u1ec3u \u0111\u1ed3 n\u00e0y ch\u00fang ta kh\u00f4ng c\u1ea7n t\u1edbi c\u00e1c ghi ch\u00fa v\u00e0 ph\u1ea7n Chart Title, do \u0111\u00f3 c\u00f3 th\u1ec3 x\u00f3a \u0111i.<\/p>\n<p>Thi\u1ebft l\u1eadp k\u00edch th\u01b0\u1edbc bi\u1ec3u \u0111\u1ed3 kho\u1ea3ng 3\u2033 cho c\u1ea3 chi\u1ec1u cao v\u00e0 chi\u1ec1u r\u1ed9ng<\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 ho\u00e0n th\u00e0nh bi\u1ec3u \u0111\u1ed3 r\u1ed3i.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Trang_tri_hoan_thien_bieu_do\"><\/span>Trang tr\u00ed ho\u00e0n thi\u1ec7n bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u1ea1o \u0111\u01b0\u1ee3c con s\u1ed1 bi\u1ec3u di\u1ec5n % th\u1ef1c hi\u1ec7n b\u00ean trong bi\u1ec3u \u0111\u1ed3, ch\u00fang ta s\u1ebd ch\u00e8n th\u00eam 1 Textbox\u00a0r\u1ed3i v\u1ebd v\u00e0o trong l\u00f2ng bi\u1ec3u \u0111\u1ed3.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c l\u1ea5y k\u1ebft qu\u1ea3 v\u00e0o trong Textbox, b\u1ea5m F2 r\u1ed3i vi\u1ebft\u00a0d\u1ea5u b\u1eb1ng, ti\u1ebfp \u0111\u00f3 click chu\u1ed9t v\u00e0o \u00f4 E4\u00a0(l\u00e0 \u00f4 th\u1ec3 hi\u1ec7n gi\u00e1 tr\u1ecb % th\u1ef1c hi\u1ec7n c\u1ee7a H\u00e0 N\u1ed9i)<\/p>\n<p>Ti\u1ebfp \u0111\u00f3 \u0111\u1ecbnh d\u1ea1ng font ch\u1eef trong Textbox n\u00e0y:<\/p>\n<ul>\n<li>Font: Impact<\/li>\n<li>C\u1ee1 ch\u1eef: 24<\/li>\n<li>M\u00e0u ch\u1eef: Blue, Accent 1 (c\u00f9ng m\u00e0u v\u1edbi bi\u1ec3u \u0111\u1ed3)<\/li>\n<li>C\u0103n l\u1ec1: Gi\u1eefa<\/li>\n<li>Format Textbox: No Fill, No Line<\/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-21206\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart-doughnut01-hoan-thanh.png\" width=\"334\" height=\"297\" title=\"chart-doughnut01-hoan-thanh\"><\/p>\n<p>\u0110\u1ec3 th\u1ec3 hi\u1ec7n t\u00ean khu v\u1ef1c c\u1ee7a bi\u1ec3u \u0111\u1ed3 l\u00e0 H\u00e0 N\u1ed9i, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi 1 Textbox kh\u00e1c, sau \u0111\u00f3 \u0111\u1eb7t d\u01b0\u1edbi bi\u1ec3u \u0111\u1ed3<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ve_them_bieu_do_cho_cac_khu_vuc_khac\"><\/span>V\u1ebd th\u00eam bi\u1ec3u \u0111\u1ed3 cho c\u00e1c khu v\u1ef1c kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>L\u00e0m t\u01b0\u01a1ng t\u1ef1 b\u01b0\u1edbc 1 v\u00e0 2 cho c\u00e1c bi\u1ec3u \u0111\u1ed3 c\u1ee7a khu v\u1ef1c kh\u00e1c: H\u1ea3i Ph\u00f2ng, Tp HCM (2 bi\u1ec3u \u0111\u1ed3)<\/p>\n<p><strong>Ch\u00fa \u00fd:<\/strong><\/p>\n<ul>\n<li>M\u1ed7i bi\u1ec3u \u0111\u1ed3 bi\u1ec3u di\u1ec5n 1 m\u00e0u kh\u00e1c nhau<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">V\u00ed d\u1ee5 t\u00f4ng m\u00e0u l\u1ea7n l\u01b0\u1ee3t l\u00e0<\/p>\n<p style=\"padding-left: 90px\">H\u00e0 N\u1ed9i: Blue, Accent 1<\/p>\n<p style=\"padding-left: 90px\">H\u1ea3i Ph\u00f2ng: Red<\/p>\n<p style=\"padding-left: 90px\">Tp HCM: Green, Accent 6<\/p>\n<ul>\n<li>K\u00edch th\u01b0\u1edbc c\u00e1c bi\u1ec3u \u0111\u1ed3 b\u1eb1ng nhau<\/li>\n<li>Font ch\u1eef \u0111\u1ecbnh d\u1ea1ng cho c\u00e1c n\u1ed9i dung: S\u1ed1 b\u00ean trong bi\u1ec3u \u0111\u1ed3, t\u00ean khu v\u1ef1c \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp gi\u1ed1ng nhau \u0111\u1ec3 t\u0103ng hi\u1ec7u qu\u1ea3 th\u1ea9m m\u1ef9.<\/li>\n<\/ul>\n<p>Sau khi ho\u00e0n th\u00e0nh th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 g\u1ed9p nh\u00f3m 3 bi\u1ec3u \u0111\u1ed3 n\u00e0y \u0111\u1ec3 ti\u1ec7n cho vi\u1ec7c di chuy\u1ec3n t\u1edbi v\u1ecb tr\u00ed th\u00edch h\u1ee3p<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21207\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart-doughnut-hoan-thanh-3-bieu-do.png\" width=\"1085\" height=\"577\" title=\"chart-doughnut-hoan-thanh-3-bieu-do\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thiet_lap_Slicer_de_chon_nhan_vien\"><\/span>Thi\u1ebft l\u1eadp Slicer \u0111\u1ec3 ch\u1ecdn nh\u00e2n vi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u1eeb\u00a0Pivot Table, ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o ra 1 Slicer \u0111\u1ec3 l\u1ecdc theo danh s\u00e1ch nh\u00e2n vi\u00ean \u0111\u1ec3 l\u1ea5y k\u1ebft qu\u1ea3 th\u1ef1c hi\u1ec7n c\u1ee7a nh\u00e2n vi\u00ean \u0111\u00f3. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: B\u1ea5m v\u00e0o v\u1ecb tr\u00ed b\u1ea3ng Pivot Table, trong th\u1ebb <strong>PivotTable Tools\/ Analyze<\/strong> ch\u1ecdn <strong>Insert Slicer<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Ch\u1ecdn \u0111\u1ed1i t\u01b0\u1ee3ng cho Slicer l\u00e0 <strong>Nh\u00e2n vi\u00ean<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21223\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pivottable-insert-slicer-nhan-vien.png\" width=\"1055\" height=\"488\" title=\"pivottable-insert-slicer-nhan-vien\"><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: Sau khi t\u1ea1o \u0111\u01b0\u1ee3c Slicer th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng cho Slicer t\u00f9y theo \u00fd mu\u1ed1n.<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 ch\u1ecdn Slicer th\u1ec3 hi\u1ec7n theo 2 c\u1ed9t v\u00e0 c\u00f3 k\u00edch th\u01b0\u1edbc thu g\u1ecdn l\u1ea1i nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21224\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pivottable-format-slicer.png\" width=\"730\" height=\"366\" title=\"pivottable-format-slicer\"><\/p>\n<p>B\u00e2y gi\u1edd ch\u00fang ta ch\u1ec9 c\u1ea7n ch\u1ecdn 1 nh\u00e2n vi\u00ean b\u1ea5t k\u1ef3 trong Slicer b\u1eb1ng c\u00e1ch click chu\u1ed9t v\u00e0o t\u00ean nh\u00e2n vi\u00ean \u0111\u00f3, k\u1ebft qu\u1ea3 bi\u1ec3u \u0111\u1ed3 s\u1ebd thay \u0111\u1ed5i theo nh\u00e2n vi\u00ean \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 ho\u00e0n th\u00e0nh \u0111\u01b0\u1ee3c c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n th\u1ec3 hi\u1ec7n % th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch r\u1ed3i. Hy v\u1ecdng r\u1eb1ng qua b\u00e0i vi\u1ebft n\u00e0y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t h\u01a1n Excel v\u00e0o c\u00f4ng vi\u1ec7c, \u0111\u1eb7c bi\u1ec7t l\u00e0 b\u00e1o c\u00e1o qua bi\u1ec3u \u0111\u1ed3.<\/p>\n<p>B\u1ea1n c\u00f3 g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m c\u1ee7a Excel kh\u00f4ng?\u00a0Mu\u1ed1n hi\u1ec3u r\u00f5 v\u1ec1 c\u00e1c h\u00e0m trong Excel, s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2vFgrZs\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ecdc c\u00e1c ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1ch\u00a0vi\u1ebft\u00a0c\u00e1c h\u00e0m t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao, c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 trong Excel, s\u1eed d\u1ee5ng PivotTable, v\u1ebd bi\u1ec3u \u0111\u1ed3\u2026 r\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c h\u1eefu \u00edch v\u00e0 c\u1ea7n thi\u1ebft trong c\u00f4ng vi\u1ec7c h\u00e0ng n\u00e0y.<\/p>\n<p>M\u1ed9t \u0111i\u1ec1u h\u1ea5p d\u1eabn n\u1eefa l\u00e0 hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. 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-140.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10178,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10177","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\/10177","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=10177"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10177\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10178"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}