{"id":11174,"date":"2025-01-15T01:57:42","date_gmt":"2025-01-15T01:57:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tao-bieu-do-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet\/"},"modified":"2025-01-15T01:57:42","modified_gmt":"2025-01-15T01:57:42","slug":"tao-bieu-do-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tao-bieu-do-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet\/","title":{"rendered":"T\u1ea0O BI\u1ec2U \u0110\u1ed2 C\u1ed8T C\u00d3 HAI GAM M\u00c0U N\u00d3NG V\u00c0 L\u1ea0NH RI\u00caNG BI\u1ec6T"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/hocexcel.online\/\" target=\"_blank\">H\u1ecdc Excel Online<\/a> s\u1ebd <a href=\"http:\/\/blog.ezworkapp.com\/tao-bieu-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet.html\">h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u00f3 hai gam m\u00e0u n\u00f3ng v\u00e0 l\u1ea1nh ri\u00eang bi\u1ec7t<\/a>.<\/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-6787161596833\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tao-bieu-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet.html#Tao_bieu_do_cot_co_hai_gam_mau_nong_va_lanh_rieng_biet\" title=\"T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u00f3 hai gam m\u00e0u n\u00f3ng v\u00e0 l\u1ea1nh ri\u00eang bi\u1ec7t\">T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u00f3 hai gam m\u00e0u n\u00f3ng v\u00e0 l\u1ea1nh ri\u00eang bi\u1ec7t<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tao-bieu-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet.html#Tao_bieu_do_cot_%E2%80%9Cmot_loai%E2%80%9D_nhieu_mau\" title=\"T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u201cm\u1ed9t lo\u1ea1i\u201d nhi\u1ec1u m\u00e0u\">T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u201cm\u1ed9t lo\u1ea1i\u201d nhi\u1ec1u m\u00e0u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tao-bieu-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet.html#Tao_du_lieu_cho_bieu_do\" title=\"T\u1ea1o d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3\">T\u1ea1o d\u1eef li\u1ec7u cho 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-4\" href=\"https:\/\/blog.hocexcel.online\/tao-bieu-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet.html#Tao_bieu_do_cot\" title=\"T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t\">T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t<\/a><\/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\/tao-bieu-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet.html#Khien_hai_loai_bieu_do_trong_nhu_mot\" title=\"Khi\u1ebfn hai lo\u1ea1i bi\u1ec3u \u0111\u1ed3 tr\u00f4ng nh\u01b0 m\u1ed9t\">Khi\u1ebfn hai lo\u1ea1i bi\u1ec3u \u0111\u1ed3 tr\u00f4ng nh\u01b0 m\u1ed9t<\/a><\/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\/tao-bieu-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet.html#Vai_thao_tac_chinh_sua_bieu_do\" title=\"V\u00e0i thao t\u00e1c ch\u1ec9nh s\u1eeda bi\u1ec3u \u0111\u1ed3\">V\u00e0i thao t\u00e1c ch\u1ec9nh s\u1eeda 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\/tao-bieu-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet.html#Dat_ten_du_lieu\" title=\"\u0110\u1eb7t t\u00ean d\u1eef li\u1ec7u\">\u0110\u1eb7t t\u00ean d\u1eef li\u1ec7u<\/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\/tao-bieu-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet.html#Ket_noi_ten_du_lieu_voi_mot_cong_thuc\" title=\"K\u1ebft n\u1ed1i t\u00ean d\u1eef li\u1ec7u v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c\">K\u1ebft n\u1ed1i t\u00ean d\u1eef li\u1ec7u v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/tao-bieu-cot-co-hai-gam-mau-nong-va-lanh-rieng-biet.html#Thanh_pham\" title=\"Th\u00e0nh ph\u1ea9m!\">Th\u00e0nh ph\u1ea9m!<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_bieu_do_cot_co_hai_gam_mau_nong_va_lanh_rieng_biet\"><\/span>T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u00f3 hai gam m\u00e0u n\u00f3ng v\u00e0 l\u1ea1nh ri\u00eang bi\u1ec7t<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9487 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-300x157-1.png\" width=\"300\" height=\"157\" title=\"1-300x157-1\"><\/p>\n<p style=\"text-align: justify\">M\u1ee5c \u0111\u00edch c\u1ee7a ch\u00fang t\u00f4i khi l\u00e0m nh\u00e0 ph\u00e2n t\u00edch \u0111\u00f3 l\u00e0 k\u1ec3 chuy\u1ec7n b\u1eb1ng d\u1eef li\u1ec7u v\u00e0 vi\u1ec7c d\u1eef li\u1ec7u c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c ti\u1ebfp thu t\u1ed1t th\u00f4ng qua h\u00ecnh \u1ea3nh h\u01a1n l\u00e0 th\u00f4ng qua v\u0103n b\u1ea3n l\u00e0 m\u1ed9t s\u1ef1 th\u1eadt hi\u1ec3n nhi\u00ean. \u0110\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao r\u1ea5t quan tr\u1ecdng khi ch\u00fang t\u00f4i c\u00e2n nh\u1eafc k\u1ef9 c\u00e0ng c\u00e1ch thuy\u1ebft tr\u00ecnh d\u1eef li\u1ec7u cho nh\u1eefng nh\u00e0 l\u00e3nh \u0111\u1ea1o m\u00e0 ch\u00fang t\u00f4i \u1ee7ng h\u1ed9.<\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c m\u00e0u s\u1eafc kh\u00e1c nhau trong bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt s\u1ef1 th\u1eadt v\u1ec1 d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta l\u00e0 m\u1ed9t c\u00e1ch hay \u0111\u1ec3 k\u1ec3 m\u1ed9t c\u00e2u chuy\u1ec7n. M\u1eaft ng\u01b0\u1eddi nghe c\u00f3 th\u1ec3 ngay l\u1eadp t\u1ee9c chia d\u1eef li\u1ec7u v\u00e0 c\u00f3 th\u1ec3 t\u1eadp trung v\u00e0o k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n mu\u1ed1n h\u1ecd th\u1ea5y tr\u01b0\u1edbc ti\u00ean. T\u1ea5t c\u1ea3 \u0111i\u1ec1u n\u00e0y kh\u00f4ng th\u1ec3 ho\u00e0n th\u00e0nh c\u00f3 th\u1ec3 n\u00f3i l\u00e0 ch\u1ec9 v\u1edbi m\u1ed9t m\u00e0u duy nh\u1ea5t \u0111\u01b0\u1ee3c!<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_bieu_do_cot_%E2%80%9Cmot_loai%E2%80%9D_nhieu_mau\"><\/span>T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u201cm\u1ed9t lo\u1ea1i\u201d nhi\u1ec1u m\u00e0u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e3y xem x\u00e9t hai bi\u1ec3u \u0111\u1ed3 c\u1ed9t d\u01b0\u1edbi \u0111\u00e2y. Ngay l\u1eadp t\u1ee9c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng m\u1ed9t v\u00e0i c\u1ed9t kh\u00f4ng gi\u1ed1ng nh\u1eefng c\u1ed9t kh\u00e1c v\u00e0 th\u1eadt l\u00e0 t\u1ed1t, b\u1edfi v\u00ec ng\u01b0\u1eddi nghe s\u1ebd ngay l\u1eadp t\u1ee9c b\u1ecb thu h\u00fat b\u1edfi nh\u1eefng c\u1ed9t tr\u00f4ng \u0111\u1eb7c bi\u1ec7t (c\u1ee5 th\u1ec3 l\u00e0 c\u1ed9t m\u00e0u x\u00e1m v\u00e0 c\u1ed9t g\u1ea1ch ch\u00e9o trong v\u00ed d\u1ee5).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9488 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/2-300x93-1.png\" width=\"300\" height=\"93\" title=\"2-300x93-1\"><\/p>\n<p style=\"text-align: justify\">Th\u1eadt kh\u00f4ng may, th\u1eadt kh\u00f4ng d\u1ec5 \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t tr\u00f4ng gi\u1ed1ng nh\u01b0 v\u00ed d\u1ee5 tr\u00ean. V\u00e2ng, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i m\u00e0u s\u1eafc m\u1ed9t c\u1ed9t m\u1ed9t l\u1ea7n m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng, nh\u01b0ng khi b\u1ea1n th\u1ef1c hi\u1ec7n m\u1ecdi th\u1ee9 m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng th\u00ec s\u1ebd r\u1ea5t m\u1ea5t th\u1eddi gian v\u00e0 r\u1ea5t d\u1ec5 ph\u1ea1m l\u1ed7i. V\u1eady l\u00e0m th\u1ebf n\u00e0o ch\u00fang ta c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a nhi\u1ec7m v\u1ee5 n\u00e0y, cho ph\u00e9p bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u1ee7a b\u1ea1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a n\u00f3 d\u1ef1a tr\u00ean d\u1eef li\u1ec7u th\u00e1ng hi\u1ec7n t\u1ea1i?<\/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-266.gif\" title=\"ex101_92019-nho-266\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>C\u00e2u tr\u1ea3 l\u1eddi ng\u1eafn:<\/strong> B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng hai lo\u1ea1i bi\u1ec3u \u0111\u1ed3 v\u00e0 khi\u1ebfn ch\u00fang tr\u00f4ng nh\u01b0 m\u1ed9t!<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_du_lieu_cho_bieu_do\"><\/span>T\u1ea1o d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9489 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/3-300x149-1.png\" width=\"300\" height=\"149\" title=\"3-300x149-1\"><\/p>\n<p style=\"text-align: justify\">Thay v\u00ec ch\u1ec9 s\u1eed d\u1ee5ng m\u1ed9t d\u00f2ng d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u1ee7a b\u1ea1n, th\u00ec b\u1ea1n c\u1ea7n t\u1ea1o 4 h\u00e0ng. Hai h\u00e0ng \u0111\u1ea7u ti\u00ean s\u1ebd nh\u00f3m d\u1eef li\u1ec7u v\u00e0 hai h\u00e0ng cu\u1ed1i s\u1ebd l\u01b0u gi\u00e1 tr\u1ecb Data Label c\u1ee7a b\u1ea1n. \u0110\u1ec3 t\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u bi\u1ec3u \u0111\u1ed3 \u201cm\u1edbi\u201d, b\u1ea1n s\u1ebd c\u1ea7n s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nhau cho nh\u1eefng c\u00e1i d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9491 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/11-300x85-1.png\" width=\"300\" height=\"85\" title=\"11-300x85-1\"><\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec3m m\u1ea5u ch\u1ed1t trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n, \u0111\u00f3 l\u00e0 b\u1ea1n s\u1ebd ch\u1ec9 mu\u1ed1n m\u1ed9t d\u1eef li\u1ec7u duy nh\u1ea5t cho m\u1ed9t h\u00e0ng trong hai ph\u1ea7n. \u0110\u1ed1i v\u1edbi hai h\u00e0ng d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean, b\u1ea1n s\u1ebd mu\u1ed1n m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed7i c\u1ed9t l\u01b0u \u0111i\u1ec3m d\u1eef li\u1ec7u th\u1eadt s\u1ef1, trong khi gi\u00e1 tr\u1ecb kh\u00e1c s\u1ebd cho gi\u00e1 tr\u1ecb l\u1ed7i #NA. B\u1eb1ng c\u00e1ch \u0111\u00f3, trong bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n s\u1ebd ch\u1ec9 hi\u1ec3n th\u1ecb m\u1ed9t c\u1ed9t gi\u1eefa hai c\u1ed9t c\u00f9ng nh\u00f3m.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd c\u1ea7n s\u1eed d\u1ee5ng c\u00f9ng m\u1ed9t \u00fd t\u01b0\u1edfng cho t\u00ean d\u1eef li\u1ec7u, v\u1edbi m\u1ed9t c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb \u0111i\u1ec3m d\u1eef li\u1ec7u v\u00e0 c\u1ed9t kh\u00e1c c\u00f3 gi\u00e1 tr\u1ecb \u201c\u201d (r\u1ed7ng).<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_bieu_do_cot\"><\/span>T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t, b\u1ea1n c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t. Ch\u1ec9 c\u1ea7n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 c\u00f3 ch\u1ee9a hai h\u00e0ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, h\u00e3y \u0111i \u0111\u1ebfn tab INSERT r\u1ed3i ch\u1ecdn bi\u1ec3u \u0111\u1ed3 c\u1ed9t d\u1ea1ng 2-D Column (kh\u00f4ng ph\u1ea3i c\u1ed9t ch\u1ed3ng).<\/p>\n<p style=\"text-align: justify\">B\u00ean d\u01b0\u1edbi l\u00e0 c\u00e1c b\u01b0\u1edbc \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n c\u1ee5 th\u1ec3 (nh\u1ea5p v\u00e0o \u0111\u1ec3 ph\u00f3ng to):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9490 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/5-300x151-1.png\" width=\"300\" height=\"151\" title=\"5-300x151-1\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Khien_hai_loai_bieu_do_trong_nhu_mot\"><\/span>Khi\u1ebfn hai lo\u1ea1i bi\u1ec3u \u0111\u1ed3 tr\u00f4ng nh\u01b0 m\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o hi\u1ec7u \u1ee9ng ch\u1ec9 c\u00f3 m\u1ed9t lo\u1ea1i bi\u1ec3u \u0111\u1ed3 trong \u0111\u1ed3 th\u1ecb c\u1ee7a b\u1ea1n, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ed3ng hai lo\u1ea1i bi\u1ec3u \u0111\u1ed3 \u0111\u1ebfn <strong>100%<\/strong>. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o m\u1ed9t trong hai lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ed9t r\u1ed3i ch\u1ecdn\u00a0<strong id=\"yui_3_17_2_1_1504709466706_891\">Format Data Series.\u00a0<\/strong>R\u1ed3i ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng\u00a0<strong id=\"yui_3_17_2_1_1504709466706_895\">Series Options\u00a0<\/strong>r\u1ed3i t\u00ecm n\u01a1i b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i c\u00e0i \u0111\u1eb7t\u00a0<strong>Series Overlap\u00a0<\/strong>(hi\u1ec3n th\u1ecb b\u00ean d\u01b0\u1edbi).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9492 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/6-276x300-1.png\" width=\"276\" height=\"300\" title=\"6-276x300-1\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vai_thao_tac_chinh_sua_bieu_do\"><\/span>V\u00e0i thao t\u00e1c ch\u1ec9nh s\u1eeda bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ph\u1ea7n n\u00e0y ch\u1ec9 l\u00e0 m\u1ee5c y\u00eau th\u00edch ri\u00eang c\u1ee7a t\u00f4i, nh\u01b0ng t\u00f4i s\u1ebd cung c\u1ea5p v\u00e0i b\u01b0\u1edbc v\u1ec1 c\u00e1ch t\u00f4i mu\u1ed1n ch\u1ec9nh s\u1eeda bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 khi\u1ebfn n\u00f3 d\u1ec5 nh\u00ecn h\u01a1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9493 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/7-300x166-1.png\" width=\"300\" height=\"166\" title=\"7-300x166-1\"><\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 nh\u1eefng \u0111i\u1ec1u t\u00f4i \u0111\u00e3 l\u00e0m:<\/p>\n<ol style=\"text-align: justify\">\n<li>\u0110\u1eb7t t\u00ean cho bi\u1ec3u \u0111\u1ed3 v\u00e0 ph\u00f3ng to k\u00edch th\u01b0\u1edbc ph\u00f4ng ch\u1eef h\u01a1n \u0111\u1ec3 n\u00f3 tr\u00f4ng l\u1edbn h\u01a1n so v\u1edbi c\u00e1c ch\u1eef c\u00f2n l\u1ea1i trong bi\u1ec3u \u0111\u1ed3<\/li>\n<li>X\u00f3a <strong>Y-Axis Labels.<\/strong> Ch\u00fang ta s\u1ebd th\u00eam Data Labels sau \u0111\u00f3, n\u00ean vi\u1ec7c c\u00f3 c\u1ea3 hai Label ch\u1eb3ng gi\u00fap \u00edch g\u00ec (n\u00f3 h\u01a1i d\u01b0 th\u1eeba!)<\/li>\n<li>\u0110\u1ec3 ti\u1ebft ki\u1ec7m kh\u00f4ng gian, t\u00f4i mu\u1ed1n ch\u00fa th\u00edch c\u1ee7a bi\u1ec3u \u0111\u1ed3 n\u1eb1m trong khu v\u1ef1c xung quanh bi\u1ec3u \u0111\u1ed3 (th\u01b0\u1eddng n\u1eb1m g\u1ea7n g\u00f3c tr\u00ean c\u00f9ng b\u00ean ph\u1ea3i hay hay g\u00f3c b\u00ean tr\u00e1i)<\/li>\n<li>Di chuy\u1ec3n <strong>X-Axis Labels<\/strong> b\u00ean d\u01b0\u1edbi d\u1eef li\u1ec7u (<strong id=\"yui_3_17_2_1_1504789456568_838\">Format Axis<\/strong>\u00a0&gt;\u00a0<strong>Axis Options<\/strong>\u00a0&gt;\u00a0<strong>Label Position<\/strong>\u00a0&gt;\u00a0<strong>Low)<\/strong><\/li>\n<li>X\u00f3a \u00f4 l\u01b0\u1edbi v\u00e0 x\u00f3a khung bao quanh bi\u1ec3u \u0111\u1ed3<\/li>\n<\/ol>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dat_ten_du_lieu\"><\/span>\u0110\u1eb7t t\u00ean d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 ph\u1ea7n t\u00f4i c\u1ef1c k\u1ef3 gh\u00e9t, nh\u01b0ng t\u00f4i c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c nh\u1edd t\u1ef1 n\u00f3i v\u1edbi b\u1ea3n th\u00e2n m\u00ecnh, \u201cChris, b\u1ea1n ch\u1ec9 c\u1ea7n ph\u1ea3i l\u00e0m m\u1ed9t l\u1ea7n th\u00f4i, b\u1ea1n ch\u1ec9 c\u1ea7n ph\u1ea3i l\u00e0m m\u1ed9t l\u1ea7n th\u00f4i.\u201d<\/p>\n<p style=\"text-align: justify\">B\u1eaft \u0111\u1ea7u n\u00e0o! Tr\u01b0\u1edbc ti\u00ean, b\u1ea1n c\u1ea7n th\u00eam Data Labels v\u00e0o hai lo\u1ea1i bi\u1ec3u \u0111\u1ed3. B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y b\u1eb1ng c\u00e1ch nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o bi\u1ec3u \u0111\u1ed3 trong m\u1ed7i lo\u1ea1i r\u1ed3i ch\u1ecdn <strong>Add Data Labels.<\/strong><\/p>\n<p style=\"text-align: justify\">M\u1ed9t khi b\u1ea1n \u0111\u00e3 \u0111\u1eb7t t\u00ean d\u1eef li\u1ec7u cho c\u1ea3 hai lo\u1ea1i bi\u1ec3u \u0111\u1ed3, bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n n\u00ean nh\u00ecn gi\u1ed1ng nh\u01b0 bi\u1ec3u \u0111\u1ed3 c\u1ed9t d\u01b0\u1edbi \u0111\u00e2y. B\u1ea1n s\u1ebd nh\u1eadn th\u1ea5y b\u1ea1n c\u00f3 t\u1ea5t c\u1ea3 l\u1ed7i #N\/A xu\u1ea5t hi\u1ec7n tr\u00ean t\u00ean c\u1ee7a d\u1eef li\u1ec7u. \u0110\u00e2y l\u00e0 l\u00fd do v\u00ec sao ch\u00fang ta t\u1ea1o hai h\u00e0ng t\u00ean trong ph\u1ea7n Data Chart, \u0111\u1ec3 kh\u00f4ng ph\u1ea3i m\u1eafc c\u00e1c l\u1ed7i n\u00e0y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9494 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/8-300x143-1.png\" width=\"300\" height=\"143\" title=\"8-300x143-1\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_noi_ten_du_lieu_voi_mot_cong_thuc\"><\/span>K\u1ebft n\u1ed1i t\u00ean d\u1eef li\u1ec7u v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 k\u1ebft n\u1ed1i t\u00ean d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb \u00f4, ch\u00fang ta c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn m\u1ed9t <strong>Data Label<\/strong> (b\u1eb1ng c\u00e1ch nh\u1ea5p \u0111\u00fap chu\u1ed9t v\u00e0o t\u00ean mong mu\u1ed1n)<\/li>\n<li>Nh\u1ea5p v\u00e0o <strong>Formula Bar<\/strong><\/li>\n<li>Ch\u1ecdn <strong>Cell<\/strong> m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u r\u1ed3i nh\u1ea5p ph\u00edm <strong>Enter<\/strong> tr\u00ean b\u00e0n ph\u00edm<\/li>\n<\/ol>\n<p style=\"text-align: justify\">B\u1ea1n c\u1ea7n l\u1eb7p l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c b\u01b0\u1edbc n\u00e0y cho t\u1ea5t c\u1ea3 t\u00ean d\u1eef li\u1ec7u cho \u0111\u1ebfn khi n\u00f3 \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i v\u1edbi \u0111i\u1ec3m d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9495 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/9-300x144-1.png\" width=\"300\" height=\"144\" title=\"9-300x144-1\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thanh_pham\"><\/span>Th\u00e0nh ph\u1ea9m!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110o\u00e1n th\u1eed xem? B\u1ea1n c\u00f3 m\u1ed9t bi\u1ec3u \u0111\u1ed3 gi\u00fap k\u1ec3 m\u1ed9t c\u00e2u chuy\u1ec7n hi\u1ec7u qu\u1ea3 h\u01a1n r\u1ea5t nhi\u1ec1u!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9496 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/10-300x143-1.png\" width=\"300\" height=\"143\" title=\"10-300x143-1\"><\/p>\n<p style=\"text-align: justify\">Xin c\u1ea3m \u01a1n v\u00e0 h\u1eb9n g\u1eb7p l\u1ea1i!<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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-266.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11175,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11174","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\/11174","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=11174"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11174\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11175"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}