{"id":9930,"date":"2025-01-05T08:59:12","date_gmt":"2025-01-05T08:59:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/05\/huong-dan-cach-dieu-khien-bieu-do-tu-dong-thay-doi-theo-nut-tuy-chon-tren-excel\/"},"modified":"2025-01-05T08:59:12","modified_gmt":"2025-01-05T08:59:12","slug":"huong-dan-cach-dieu-khien-bieu-do-tu-dong-thay-doi-theo-nut-tuy-chon-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/05\/huong-dan-cach-dieu-khien-bieu-do-tu-dong-thay-doi-theo-nut-tuy-chon-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111i\u1ec1u khi\u1ec3n bi\u1ec3u \u0111\u1ed3 t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i theo n\u00fat t\u00f9y ch\u1ecdn tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi th\u1ef1c hi\u1ec7n b\u00e1o c\u00e1o tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3, ngo\u00e0i vi\u1ec7c th\u1ec3 hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c n\u1ed9i dung c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u l\u00ean th\u00e0nh bi\u1ec3u\u00a0\u0111\u1ed3, ch\u00fang ta c\u00f2n ph\u1ea3i bi\u1ebft c\u00e1ch t\u00f9y bi\u1ebfn bi\u1ec3u\u00a0\u0111\u1ed3 cho ph\u00f9 h\u1ee3p v\u1edbi vi\u1ec7c thuy\u1ebft tr\u00ecnh, tr\u00ecnh b\u00e0y\u00a0\u00fd ngh\u0129a c\u00e1c k\u1ebft qu\u1ea3 tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3. M\u1ed9t trong nh\u1eefng\u00a0\u1ee9ng d\u1ee5ng cho vi\u1ec7c n\u00e0y l\u00e0 vi\u1ec7c k\u1ebft h\u1ee3p n\u00fat t\u00f9y ch\u1ecdn n\u1ed9i dung s\u1ebd bi\u1ec3u di\u1ec5n tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3. M\u1ed7i khi ch\u1ecdn m\u1ed9t n\u1ed9i dung c\u1ee5 th\u1ec3 th\u00ec bi\u1ec3u\u00a0\u0111\u1ed3 s\u1ebd thay\u00a0\u0111\u1ed5i t\u01b0\u01a1ng\u00a0\u1ee9ng theo n\u1ed9i dung\u00a0\u0111\u00f3.<\/p>\n<p>K\u1ebft qu\u1ea3 s\u1ebd\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c trong b\u00e0i vi\u1ebft n\u00e0y nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22576\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/option-cho-bieu-do.gif\" width=\"1156\" height=\"376\" title=\"option-cho-bieu-do\"><\/p>\n<p>\u0110\u1ec3 gi\u00fap c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c m\u1ee5c ti\u00eau n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> c\u00f3 chu\u1ea9n b\u1ecb s\u1eb5n file m\u1eabu\u00a0\u0111\u1ec3 c\u00e1c b\u1ea1n th\u1ef1c h\u00e0nh theo n\u1ed9i dung b\u00e0i vi\u1ebft. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9: <a href=\"http:\/\/bit.ly\/2ItU1j0\">http:\/\/bit.ly\/2ItU1j0<\/a><\/p>\n<p>T\u1eeb b\u1ea3ng d\u1eef li\u1ec7u trong file m\u1eabu, ch\u00fang ta s\u1ebd v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 v\u00e0 thi\u1ebft l\u1eadp t\u00f9y ch\u1ecdn n\u1ed9i dung bi\u1ec3u di\u1ec5n cho bi\u1ec3u\u00a0\u0111\u1ed3.<\/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-677a49df3bc58\" 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-dieu-khien-bieu-do-tu-dong-thay-doi-theo-nut-tuy-chon-tren-excel.html#Cach_ve_bieu_do_cot_long_ghep_the_hien_ke_hoach_%E2%80%93_thuc_hien\" title=\"C\u00e1ch v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 c\u1ed9t l\u1ed3ng gh\u00e9p th\u1ec3 hi\u1ec7n k\u1ebf ho\u1ea1ch \u2013 th\u1ef1c hi\u1ec7n\">C\u00e1ch v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 c\u1ed9t l\u1ed3ng gh\u00e9p th\u1ec3 hi\u1ec7n k\u1ebf ho\u1ea1ch \u2013 th\u1ef1c hi\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dieu-khien-bieu-do-tu-dong-thay-doi-theo-nut-tuy-chon-tren-excel.html#Tuy_bien_bieu_do_voi_Option_Button\" title=\"T\u00f9y bi\u1ebfn bi\u1ec3u\u00a0\u0111\u1ed3 v\u1edbi Option Button\">T\u00f9y bi\u1ebfn bi\u1ec3u\u00a0\u0111\u1ed3 v\u1edbi Option Button<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dieu-khien-bieu-do-tu-dong-thay-doi-theo-nut-tuy-chon-tren-excel.html#Cach_tao_nut_Option\" title=\"C\u00e1ch t\u1ea1o n\u00fat Option\">C\u00e1ch t\u1ea1o n\u00fat Option<\/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-dieu-khien-bieu-do-tu-dong-thay-doi-theo-nut-tuy-chon-tren-excel.html#Gan_ket_qua_chon_Option_Button\" title=\"G\u00e1n k\u1ebft qu\u1ea3 ch\u1ecdn Option Button\">G\u00e1n k\u1ebft qu\u1ea3 ch\u1ecdn Option Button<\/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-dieu-khien-bieu-do-tu-dong-thay-doi-theo-nut-tuy-chon-tren-excel.html#Tuy_bien_ket_qua_bao_cao_theo_lua_chon_cua_Option_button\" title=\"T\u00f9y bi\u1ebfn k\u1ebft qu\u1ea3 b\u00e1o c\u00e1o theo l\u1ef1a ch\u1ecdn c\u1ee7a Option button\">T\u00f9y bi\u1ebfn k\u1ebft qu\u1ea3 b\u00e1o c\u00e1o theo l\u1ef1a ch\u1ecdn c\u1ee7a Option button<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dieu-khien-bieu-do-tu-dong-thay-doi-theo-nut-tuy-chon-tren-excel.html#Thay_doi_du_lieu_cua_bieu_do\" title=\"Thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3\">Thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_ve_bieu_do_cot_long_ghep_the_hien_ke_hoach_%E2%80%93_thuc_hien\"><\/span>C\u00e1ch v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 c\u1ed9t l\u1ed3ng gh\u00e9p th\u1ec3 hi\u1ec7n k\u1ebf ho\u1ea1ch \u2013 th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n \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><\/p>\n<ul>\n<li>T\u1eeb b\u1ea3ng d\u1eef li\u1ec7u trong Sheet Data,\u00a0x\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 th\u1ef1c hi\u1ec7n trong b\u1ea3ng b\u00e1o c\u00e1o\u00a0 (sheet ThucHien) b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIF<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">Trong\u00a0\u0111\u00f3:<\/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-109.gif\" title=\"ex101_92019-nho-109\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"padding-left: 60px\"><strong>Range<\/strong>: c\u1ed9t T\u00ean s\u1ea3n ph\u1ea9m trong b\u1ea3ng Data<\/p>\n<p style=\"padding-left: 60px\"><strong>Criteria<\/strong>: t\u00ean c\u1ee7a t\u1eebng s\u1ea3n ph\u1ea9m trong b\u1ea3ng b\u00e1o c\u00e1o<\/p>\n<p style=\"padding-left: 60px\"><strong>Sum_range<\/strong>: c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng trong b\u1ea3ng Data<\/p>\n<ul>\n<li>T\u1eeb b\u1ea3ng b\u00e1o c\u00e1o, th\u1ef1c hi\u1ec7n v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 th\u1ec3 hi\u1ec7n 2 c\u1ed9t K\u1ebf ho\u1ea1ch v\u00e0 th\u1ef1c t\u1ebf l\u1ed3ng nhau.<\/li>\n<\/ul>\n<p>Chi ti\u1ebft n\u1ed9i dung n\u00e0y c\u00e1c b\u1ea1n\u00a0\u0111\u1ecdc t\u1ea1i b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-ke-hoach-thuc-te-dang-cot-long-nhau-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 k\u1ebf ho\u1ea1ch th\u1ef1c t\u1ebf d\u1ea1ng c\u1ed9t l\u1ed3ng nhau tr\u00ean Excel<\/a><\/p>\n<p style=\"padding-left: 30px\">Tham kh\u1ea3o th\u00eam:<\/p>\n<p style=\"padding-left: 60px\"><a href=\"http:\/\/blog.ezworkapp.com\/ve-bieu-thuc-te-vs-ke-hoach.html\">C\u00e1ch v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 th\u1ef1c t\u1ebf so v\u1edbi k\u1ebf ho\u1ea1ch d\u1ea1ng thanh n\u1eb1m ngang (Bar)<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tuy_bien_bieu_do_voi_Option_Button\"><\/span>T\u00f9y bi\u1ebfn bi\u1ec3u\u00a0\u0111\u1ed3 v\u1edbi Option Button<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tao_nut_Option\"><\/span>C\u00e1ch t\u1ea1o n\u00fat Option<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u00fat Option (ch\u1ecdn m\u1ed9t trong s\u1ed1 nhi\u1ec1u l\u1ef1a ch\u1ecdn) l\u00e0 m\u1ed9t n\u00fat kh\u00f4ng c\u00f3 s\u1eb5n tr\u00ean thanh c\u00f4ng c\u1ee5 m\u1eb7c\u00a0\u0111\u1ecbnh c\u1ee7a\u00a0Excel.\u00a0\u0110\u1ec3 t\u1ea1o ra n\u00fat n\u00e0y c\u00f3 2 c\u00e1ch:<\/p>\n<ul>\n<li>C\u00e1ch 1: M\u1edf th\u1ebb Developer (n\u1ebfu ch\u01b0a c\u00f3 s\u1eb5n th\u1ebb n\u00e0y th\u00ec t\u00f9y bi\u1ebfn thanh c\u00f4ng c\u1ee5 \u0111\u1ec3 m\u1edf th\u1ebb n\u00e0y ra), sau\u00a0\u0111\u00f3 th\u00eam trong m\u1ee5c\u00a0Insert \/ Option Button (c\u00f3 th\u1ec3 ch\u1ecdn Form Control ho\u1eb7c ActiveX\u00a0\u0111\u1ec1u\u00a0\u0111\u01b0\u1ee3c)<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">Tham kh\u1ea3o: <a href=\"http:\/\/blog.ezworkapp.com\/cach-hien-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel.html\">C\u00e1ch m\u1edf th\u1ebb Developer<\/a><\/p>\n<ul>\n<li>C\u00e1ch 2: T\u00f9y bi\u1ebfn thanh c\u00f4ng c\u1ee5 v\u00e0 th\u00eam tr\u1ef1c ti\u1ebfp Option Button t\u1eeb All Command<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">Tham kh\u1ea3o: <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-them-cac-cong-cu-khong-co-san-tren-thanh-cong-cu-cua-excel.html\">C\u00e1ch\u00a0th\u00eam\u00a0c\u00e1c c\u00f4ng c\u1ee5 kh\u00f4ng c\u00f3 s\u1eb5n tr\u00ean thanh c\u00f4ng c\u1ee5 c\u1ee7a\u00a0Excel<\/a><\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y ch\u00fang ta s\u1ebd t\u1ea1o ra 3 Option Button. Sau khi t\u1ea1o ra c\u00e1c Option th\u00ec ch\u00fang ta s\u1ebd\u00a0\u0111\u1ed5i t\u00ean theo c\u00e1c n\u1ed9i dung:<\/p>\n<ul>\n<li>\u0110\u1ea1t k\u1ebf ho\u1ea1ch<\/li>\n<li>Kh\u00f4ng\u00a0\u0111\u1ea1t<\/li>\n<li>T\u1ea5t c\u1ea3<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Gan_ket_qua_chon_Option_Button\"><\/span>G\u00e1n k\u1ebft qu\u1ea3 ch\u1ecdn Option Button<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi ch\u1ecdn 1 trong 3 option button, ch\u00fang ta mu\u1ed1n th\u1ec3 hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00fang ta\u00a0\u0111\u00e3 ch\u1ecdn Option Button n\u00e0o. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u1ea7n ph\u1ea3i g\u00e1n k\u1ebft qu\u1ea3 ch\u1ecdn Option Button v\u00e0o 1 v\u1ecb tr\u00ed n\u00e0o\u00a0\u0111\u00f3 trong Sheet.<\/p>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, ch\u00fang ta s\u1ebd b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o 1 Option button b\u1ea5t k\u1ef3, sau\u00a0\u0111\u00f3 ch\u1ecdn Format Control<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22584\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/format-control-option-button.png\" width=\"384\" height=\"292\" title=\"format-control-option-button\"><\/p>\n<p>Trong m\u1ee5c <strong>Format Control<\/strong> ch\u1ecdn th\u1ebb <strong>Control<\/strong>, m\u1ee5c Cell link ch\u1ecdn li\u00ean k\u1ebft t\u1edbi 1\u00a0\u00f4 b\u1ea5t k\u1ef3\u00a0trong Sheet (L\u01b0u\u00a0\u00fd n\u1ebfu\u00a0\u1edf Sheet kh\u00e1c c\u1ea7n c\u00f3 t\u00ean Sheet\u00a0\u1edf ph\u00eda tr\u01b0\u1edbc t\u1ecda\u00a0\u0111\u1ed9 c\u1ee7a\u00a0\u00f4)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22586\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/option-button-cell-link.png\" width=\"635\" height=\"541\" title=\"option-button-cell-link\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tuy_bien_ket_qua_bao_cao_theo_lua_chon_cua_Option_button\"><\/span>T\u00f9y bi\u1ebfn k\u1ebft qu\u1ea3 b\u00e1o c\u00e1o theo l\u1ef1a ch\u1ecdn c\u1ee7a Option button<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 gi\u00fap t\u00f9y bi\u1ebfn d\u1eef li\u1ec7u c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3, ch\u00fang ta c\u1ea7n ph\u1ea3i t\u00f9y bi\u1ebfn k\u1ebft qu\u1ea3 b\u1ea3ng b\u00e1o c\u00e1o \u2013 l\u00e0 d\u1eef li\u1ec7u\u00a0\u0111\u1ec3 t\u1ea1o n\u00ean bi\u1ec3u\u00a0\u0111\u1ed3. Do\u00a0\u0111\u00f3 ch\u00fang ta s\u1ebd t\u1ea1o ra m\u1ed9t s\u1ed1\u00a0c\u1ed9t ph\u1ee5\u00a0\u0111\u1ec3 t\u00f9y bi\u1ebfn n\u1ed9i dung n\u00e0y nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22587\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bang-phu-chuyen-doi-du-lieu-theo-option.png\" width=\"1165\" height=\"379\" title=\"bang-phu-chuyen-doi-du-lieu-theo-option\"><\/p>\n<ul>\n<li>C\u1ed9t E: bi\u1ec3u di\u1ec5n c\u00e1c s\u1ea3n ph\u1ea9m<strong>\u00a0\u0111\u1ea1t k\u1ebf ho\u1ea1ch<\/strong> theo c\u1ed9t A<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">C\u00f4ng th\u1ee9c t\u1ea1i E2 =IF(C2&gt;=B2,$A2,\u201d\u201d)<\/p>\n<ul>\n<li>C\u1ed9t F: Bi\u1ec3u di\u1ec5n c\u00e1c s\u1ea3n ph\u1ea9m\u00a0<strong>kh\u00f4ng\u00a0\u0111\u1ea1t k\u1ebf ho\u1ea1ch<\/strong>\u00a0theo c\u1ed9t A<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">C\u00f4ng th\u1ee9c t\u1ea1i F2 =IF(C2&lt;B2,$A2,\u201d\u201d)<\/p>\n<ul>\n<li>C\u1ed9t G: t\u1ed5ng k\u1ebft l\u1ea1i c\u00e1c\u00a0s\u1ea3n ph\u1ea9m\u00a0khi ch\u1ecdn 1 trong 3 option<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">C\u00f4ng th\u1ee9c t\u1ea1i G2 =IF($A$13=1,E2,IF($A$13=2,F2,A2))<\/p>\n<ul>\n<li>C\u1ed9t H v\u00e0 c\u1ed9t I: l\u1ea5y k\u1ebft qu\u1ea3 t\u01b0\u01a1ng\u00a0\u1ee9ng theo c\u00e1c c\u1ed9t k\u1ebf ho\u1ea1ch v\u00e0 th\u1ef1c hi\u1ec7n, d\u1ef1a theo gi\u00e1 tr\u1ecb t\u01b0\u01a1ng\u00a0\u1ee9ng c\u00f3\u00a0\u1edf c\u1ed9t G<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">C\u00f4ng th\u1ee9c t\u1ea1i H2:\u00a0=IF($G2=\u201d\u201d,\u201d\u201d,C2)<\/p>\n<p style=\"padding-left: 60px\">C\u00f4ng th\u1ee9c t\u1ea1i I2: =IF($G2=\u201d\u201d,\u201d\u201d,B2)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_du_lieu_cua_bieu_do\"><\/span>Thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi\u00a0\u0111\u00e3 t\u1ea1o ra\u00a0\u0111\u01b0\u1ee3c b\u1ea3ng d\u1eef li\u1ec7u m\u1edbi m\u00e0 trong\u00a0\u0111\u00f3\u00a0n\u1ed9i dung k\u1ebft qu\u1ea3 trong b\u1ea3ng ph\u1ee5 thu\u1ed9c theo k\u1ebft qu\u1ea3 ch\u1ecdn c\u1ee7a Option Button, ch\u00fang ta s\u1ebd d\u00f9ng ch\u00ednh k\u1ebft qu\u1ea3 m\u1edbi n\u00e0y thay th\u1ebf cho d\u1eef li\u1ec7u c\u0169\u00a0\u0111\u00e3 n\u1ea1p v\u00e0o <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-ke-hoach-thuc-te-dang-cot-long-nhau-tren-excel.html\">bi\u1ec3u\u00a0\u0111\u1ed3 tr\u01b0\u1edbc\u00a0\u0111\u00f3.<\/a><\/p>\n<p>(Xem l\u1ea1i b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-ke-hoach-thuc-te-dang-cot-long-nhau-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 k\u1ebf ho\u1ea1ch th\u1ef1c t\u1ebf d\u1ea1ng c\u1ed9t l\u1ed3ng nhau tr\u00ean Excel<\/a>)<\/p>\n<p>B\u1ea5m ch\u1ecdn v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong bi\u1ec3u\u00a0\u0111\u1ed3, sau\u00a0\u0111\u00f3 ch\u1ecdn m\u1ee5c <strong>Select Data<\/strong> trong th\u1ebb <strong>Chart Tools\/ Design<\/strong>, trong\u00a0\u0111\u00f3:<\/p>\n<p><strong>Legend Entries (Series)<\/strong>:<\/p>\n<ul>\n<li>B\u1ea5m ch\u1ecdn m\u1ee5c<strong> K\u1ebf ho\u1ea1ch<\/strong> -&gt; B\u1ea5m ch\u1ecdn<strong> Edit<\/strong> =&gt; Thay b\u1eb1ng v\u00f9ng d\u1eef li\u1ec7u <strong>c\u1ed9t I<\/strong><\/li>\n<li>B\u1ea5m ch\u1ecdn m\u1ee5c\u00a0<strong>Th\u1ef1c hi\u1ec7n<\/strong>\u00a0-&gt; B\u1ea5m ch\u1ecdn <strong>Edit<\/strong> =&gt; Thay b\u1eb1ng v\u00f9ng d\u1eef li\u1ec7u <strong>c\u1ed9t H<\/strong><\/li>\n<\/ul>\n<p><strong>Horizontal (Category)\u00a0Axis Labels:<\/strong><\/p>\n<ul>\n<li>B\u1ea5m <strong>Edit<\/strong> v\u00e0 ch\u1ecdn trong <strong>c\u1ed9t G<\/strong> ph\u1ea7n t\u00ean c\u00e1c <strong>S\u1ea3n ph\u1ea9m<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22634\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/change-data-tu-bieu-do.png\" width=\"589\" height=\"558\" title=\"change-data-tu-bieu-do\"><\/p>\n<p>Khi thay\u00a0\u0111\u1ed5i xong, bi\u1ec3u\u00a0\u0111\u1ed3 s\u1ebd th\u1ec3 hi\u1ec7n\u00a0\u0111\u00fang theo c\u00e1c n\u1ed9i dung c\u00f3 trong b\u1ea3ng d\u1eef li\u1ec7u m\u1edbi. B\u00e2y gi\u1edd ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y\u00a0khi thay\u00a0\u0111\u1ed5i l\u1ef1a ch\u1ecdn\u00a0\u1edf Option Button th\u00ec k\u1ebft qu\u1ea3 b\u1ea3ng b\u00e1o c\u00e1o thay\u00a0\u0111\u1ed5i =&gt; Bi\u1ec3u\u00a0\u0111\u1ed3 thay\u00a0\u0111\u1ed5i theo. Bi\u1ec3u\u00a0\u0111\u1ed3 c\u1ee7a ch\u00fang ta b\u00e2y gi\u1edd r\u1ea5t linh\u00a0\u0111\u1ed9ng ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau\u00a0\u0111\u1ec3 n\u00e2ng cao k\u1ef9 n\u0103ng v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-hinh-tron-thuc-hien-ke-hoach-tren-excel.html\">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<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-quan-ly-du-an-trong-excel-chi-tiet-nhat.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 qu\u1ea3n l\u00fd d\u1eef \u00e1n trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/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-109.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9931,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9930","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\/9930","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=9930"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9930\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9931"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}