{"id":6383,"date":"2024-12-21T15:14:16","date_gmt":"2024-12-21T15:14:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tao-bieu-do-cot-trong-excel\/"},"modified":"2024-12-21T15:14:16","modified_gmt":"2024-12-21T15:14:16","slug":"cach-tao-bieu-do-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tao-bieu-do-cot-trong-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel"},"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=\"http:\/\/blog.ezworkapp.com\">Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel v\u00e0 d\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i t\u0103ng l\u00ean hay gi\u1ea3m xu\u1ed1ng, c\u0169ng nh\u01b0 t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t v\u1edbi c\u00e1c d\u1eef li\u1ec7u \u00e2m, c\u00e1ch thay \u0111\u1ed5i \u0111\u1ed9 r\u1ed9ng v\u00e0 m\u00e0u s\u1eafc c\u1ee7a c\u1ed9t\u2026<\/p>\n<p style=\"text-align: justify\">C\u00f9ng v\u1edbi bi\u1ec3u \u0111\u1ed3 tr\u00f2n, bi\u1ec3u \u0111\u1ed3 c\u1ed9t l\u00e0 m\u1ed9t trong nh\u1eefng lo\u1ea1i bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1ee3c d\u00f9ng nhi\u1ec1u nh\u1ea5t. Ch\u00fang \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u, c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb b\u1ea5t c\u1ee9 s\u1ed1 li\u1ec7u n\u00e0o b\u1ea1n mu\u1ed1n so s\u00e1nh nh\u01b0 s\u1ed1, ph\u1ea7n tr\u0103m, nhi\u1ec7t \u0111\u1ed9, t\u1ea7n s\u1ed1,\u2026 Nh\u00ecn chung, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111\u1ec3 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang l\u1ebb trong m\u1ed9t lo\u1ea1t c\u00e1c lo\u1ea1i s\u1ed1 lo\u1ea1i kh\u00e1c nhau. M\u1ed9t lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111i\u1ec3n h\u00ecnh l\u00e0 bi\u1ec3u \u0111\u1ed3 Gantt th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh qu\u1ea3n l\u00fd d\u1ef1 \u00e1n.<\/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-6766db478e507\" 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\/cach-tao-bieu-cot-trong-excel.html#Ly_thuyet_co_ban_ve_bieu_do_cot_trong_Excel\" title=\"L\u00fd thuy\u1ebft c\u01a1 b\u1ea3n v\u1ec1 bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel\">L\u00fd thuy\u1ebft c\u01a1 b\u1ea3n v\u1ec1 bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/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\/cach-tao-bieu-cot-trong-excel.html#Cach_tao_bieu_do_cot_trong_Excel\" title=\"C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel\">C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Xem_toan_bo_nhung_loai_bieu_do_cot_trong_Excel\" title=\"Xem to\u00e0n b\u1ed9 nh\u1eefng lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel\">Xem to\u00e0n b\u1ed9 nh\u1eefng lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Chon_thiet_ke_cho_bieu_do_cot\" title=\"Ch\u1ecdn thi\u1ebft k\u1ebf cho bi\u1ec3u \u0111\u1ed3 c\u1ed9t\">Ch\u1ecdn thi\u1ebft k\u1ebf cho bi\u1ec3u \u0111\u1ed3 c\u1ed9t<\/a><\/li>\n<\/ul>\n<\/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\/cach-tao-bieu-cot-trong-excel.html#Cac_loai_bieu_do_cot_trong_Excel\" title=\"C\u00e1c lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel\">C\u00e1c lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Bieu_do_cot_ghep\" title=\"Bi\u1ec3u \u0111\u1ed3 c\u1ed9t gh\u00e9p\">Bi\u1ec3u \u0111\u1ed3 c\u1ed9t gh\u00e9p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Bieu_do_cot_chong_chia_phan\" title=\"Bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng chia ph\u1ea7n\">Bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng chia ph\u1ea7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Bieu_do_cot_chong_100\" title=\"Bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng 100%\">Bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng 100%<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Thiet_ke_hinh_tru_hinh_non_va_hinh_kim_tu_thap\" title=\"Thi\u1ebft k\u1ebf h\u00ecnh tr\u1ee5, h\u00ecnh n\u00f3n v\u00e0 h\u00ecnh kim t\u1ef1 th\u00e1p\">Thi\u1ebft k\u1ebf h\u00ecnh tr\u1ee5, h\u00ecnh n\u00f3n v\u00e0 h\u00ecnh kim t\u1ef1 th\u00e1p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Cach_tao_ra_nhung_bieu_do_cot_tru_cot_non_va_cot_kim_tu_thap_trong_Excel_2013_va_2016\" title=\"C\u00e1ch t\u1ea1o ra nh\u1eefng bi\u1ec3u \u0111\u1ed3 c\u1ed9t tr\u1ee5, c\u1ed9t n\u00f3n v\u00e0 c\u1ed9t kim t\u1ef1 th\u00e1p trong Excel 2013 v\u00e0 2016\">C\u00e1ch t\u1ea1o ra nh\u1eefng bi\u1ec3u \u0111\u1ed3 c\u1ed9t tr\u1ee5, c\u1ed9t n\u00f3n v\u00e0 c\u1ed9t kim t\u1ef1 th\u00e1p trong Excel 2013 v\u00e0 2016<\/a><\/li>\n<\/ul>\n<\/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-11\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Thiet_ke_bieu_do_cot_dac_biet_trong_Excel\" title=\"Thi\u1ebft k\u1ebf bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111\u1eb7c bi\u1ec7t trong Excel\">Thi\u1ebft k\u1ebf bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111\u1eb7c bi\u1ec7t trong Excel<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Thay_doi_do_rong_cua_cot_va_khoang_cach_giua_cac_cot\" title=\"Thay \u0111\u1ed5i \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t v\u00e0 kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c c\u1ed9t\">Thay \u0111\u1ed5i \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t v\u00e0 kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Tao_bieu_do_cot_voi_gia_tri_am\" title=\"T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t v\u1edbi gi\u00e1 tr\u1ecb \u00e2m\">T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t v\u1edbi gi\u00e1 tr\u1ecb \u00e2m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Thay_doi_vi_tri_truc_Y\" title=\"Thay \u0111\u1ed5i v\u1ecb tr\u00ed tr\u1ee5c Y\">Thay \u0111\u1ed5i v\u1ecb tr\u00ed tr\u1ee5c Y<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Thay_doi_mau_sac_cua_cac_cot_co_gia_tri_am\" title=\"Thay \u0111\u1ed5i m\u00e0u s\u1eafc c\u1ee7a c\u00e1c c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb \u00e2m\">Thay \u0111\u1ed5i m\u00e0u s\u1eafc c\u1ee7a c\u00e1c c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb \u00e2m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Sap_xep_du_lieu_trong_bieu_do_cot\" title=\"S\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 c\u1ed9t\">S\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Sap_xep_du_lieu_tang_dangiam_dan_trong_bieu_do_cot_Excel_ma_khong_thay_doi_thu_tu_du_lieu_trong_bang_tinh\" title=\"S\u1eafp x\u1ebfp d\u1eef li\u1ec7u t\u0103ng d\u1ea7n\/gi\u1ea3m d\u1ea7n trong bi\u1ec3u \u0111\u1ed3 c\u1ed9t Excel m\u00e0 kh\u00f4ng thay \u0111\u1ed5i th\u1ee9 t\u1ef1 d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh\">S\u1eafp x\u1ebfp d\u1eef li\u1ec7u t\u0103ng d\u1ea7n\/gi\u1ea3m d\u1ea7n trong bi\u1ec3u \u0111\u1ed3 c\u1ed9t Excel m\u00e0 kh\u00f4ng thay \u0111\u1ed5i th\u1ee9 t\u1ef1 d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Thay_doi_thu_tu_cua_truong_du_lieu_trong_bieu_do\" title=\"Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u1ee7a tr\u01b0\u1eddng d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3\">Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u1ee7a tr\u01b0\u1eddng d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Thay_doi_thu_tu_truong_du_lieu_bang_hop_thoai_Select_Data_Source\" title=\"Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 tr\u01b0\u1eddng d\u1eef li\u1ec7u b\u1eb1ng h\u1ed9p tho\u1ea1i Select Data Source\">Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 tr\u01b0\u1eddng d\u1eef li\u1ec7u b\u1eb1ng h\u1ed9p tho\u1ea1i Select Data Source<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-bieu-cot-trong-excel.html#Thay_doi_thu_tu_truong_du_lieu_bang_cong_thuc\" title=\"Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 tr\u01b0\u1eddng d\u1eef li\u1ec7u b\u1eb1ng c\u00f4ng th\u1ee9c\">Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 tr\u01b0\u1eddng d\u1eef li\u1ec7u b\u1eb1ng c\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ly_thuyet_co_ban_ve_bieu_do_cot_trong_Excel\"><\/span>L\u00fd thuy\u1ebft c\u01a1 b\u1ea3n v\u1ec1 bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 c\u1ed9t l\u00e0 d\u1ea1ng bi\u1ec3u \u0111\u1ed3 hi\u1ec3n th\u1ecb nhi\u1ec1u lo\u1ea1i s\u1ed1 li\u1ec7u kh\u00e1c nhau b\u1eb1ng c\u1ed9t h\u00ecnh ch\u1eef nh\u1eadt, \u0111\u1ed9 d\u00e0i c\u1ee7a thanh s\u1ebd bi\u1ec3u th\u1ecb gi\u00e1 tr\u1ecb l\u1edbn nh\u1ecf c\u1ee7a s\u1ed1 li\u1ec7u. C\u00f3 2 lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ed9t l\u00e0 bi\u1ec3u \u0111\u1ed3 c\u1ed9t ngang v\u00e0 bi\u1ec3n \u0111\u1ed3 c\u1ed9t d\u1ecdc.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c thu\u1eadt ng\u1eef s\u1eed d\u1ee5ng trong b\u00e0i, c\u00e1c b\u1ea1n h\u00e3y tham kh\u1ea3o bi\u1ec3u \u0111\u1ed3 2D m\u1eabu d\u01b0\u1edbi \u0111\u00e2y v\u1edbi 3 tr\u01b0\u1eddng d\u1eef li\u1ec7u (x\u00e1m, xanh l\u00e1 v\u00e0 xanh n\u01b0\u1edbc bi\u1ec3n), c\u00f9ng 4 h\u1ea1ng m\u1ee5c (t\u1eeb th\u00e1ng 1 \u0111\u1ebfn th\u00e1ng 4).<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6463 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bar-graph-excel.png\" width=\"484\" height=\"276\" title=\"bar-graph-excel\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tao_bieu_do_cot_trong_Excel\"><\/span>C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Vi\u1ec7c t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel th\u1ef1c t\u1ebf r\u1ea5t \u0111\u01a1n gi\u1ea3n. B\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb trong bi\u1ec3u \u0111\u1ed3, v\u00e0o tab <em>Insert &gt; Charts<\/em> tr\u00ean thanh c\u00f4ng c\u1ee5 v\u00e0 l\u1ef1a ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, ch\u00fang ta \u0111ang t\u1ea1o ra m\u1ed9t bi\u1ec3u \u0111\u1ed3 c\u1ed9t 2D:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-247.gif\" title=\"vba101_92019-nho-247\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-575.gif\" title=\"ex101_92019-nho-575\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6481 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/make-bar-graph-excel.png\" width=\"433\" height=\"402\" title=\"make-bar-graph-excel\"><\/p>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 c\u1ed9t 2D m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn v\u00e0 ch\u00e8n v\u00e0o trang t\u00ednh s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6476 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-bar-chart.png\" width=\"481\" height=\"289\" title=\"excel-bar-chart\"><\/p>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 c\u1ed9t tr\u00ean ch\u1ec9 hi\u1ec3n th\u1ecb 1 tr\u01b0\u1eddng d\u1eef li\u1ec7u v\u00ec b\u1ea1n ch\u1ec9 ch\u1ecdn 1 c\u1ed9t trong trang t\u00ednh l\u00e0m ngu\u1ed3n d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu ngu\u1ed3n d\u1eef li\u1ec7u b\u1ea1n ch\u1ecdn c\u00f3 nhi\u1ec1u h\u01a1n 2 c\u1ed9t, bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n s\u1ebd ch\u1ee9a nhi\u1ec1u tr\u01b0\u1eddng d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb v\u1edbi m\u00e0u s\u1eafc kh\u00e1c nhau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6479 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-bar-graph.png\" width=\"350\" height=\"367\" title=\"excel-bar-graph\"><\/p>\n<p><strong>Xem th\u00eam v\u00ed d\u1ee5 chi ti\u1ebft qua video: #10 <a href=\"http:\/\/blog.ezworkapp.com\/10-cach-ve-bieu-hinh-cot-trong-excel.html\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t trong Excel<\/a><\/strong><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Xem_toan_bo_nhung_loai_bieu_do_cot_trong_Excel\"><\/span>Xem to\u00e0n b\u1ed9 nh\u1eefng lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">\u0110\u1ec3 xem to\u00e0n b\u1ed9 nh\u1eefng lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111\u00e3 c\u00f3 trong Excel, b\u1ea1n click v\u00e0o \u0111\u01b0\u1eddng link <strong>More Column Charts\u2026<\/strong> v\u00e0 ch\u1ecdn m\u1ed9t trong nh\u1eefng lo\u1ea1i bi\u1ec3u \u0111\u1ed3 trong c\u1eeda s\u1ed5 Insert Chart:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6461 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bar-charts-excel.png\" width=\"640\" height=\"681\" title=\"bar-charts-excel\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chon_thiet_ke_cho_bieu_do_cot\"><\/span>Ch\u1ecdn thi\u1ebft k\u1ebf cho bi\u1ec3u \u0111\u1ed3 c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng v\u1eeba \u00fd v\u1edbi thi\u1ebft k\u1ebf m\u1eb7c \u0111\u1ecbnh c\u1ee7a bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong file Excel c\u1ee7a m\u00ecnh, b\u1ea1n h\u00e3y ch\u1ecdn bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 k\u00edch ho\u1ea1t tab<em> Chart Tools<\/em>, sau \u0111\u00f3 v\u00e0o ph\u1ea7n<em> Design<\/em> v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn nh\u1eefng layout kh\u00e1c nhau cho bi\u1ec3u \u0111\u1ed3 c\u1ed9t b\u1eb1ng c\u00e1ch click v\u00e0o ph\u1ea7n <em>Quick Layout<\/em> tr\u00ean thanh c\u00f4ng c\u1ee5.<\/li>\n<li>Ch\u1ecdn thi\u1ebft k\u1ebf ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u c\u1ee7a b\u1ea1n trong ph\u1ea7n <em>Chart Styles<\/em>.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6477 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-bar-chart-layouts-styles.png\" width=\"525\" height=\"120\" title=\"excel-bar-chart-layouts-styles\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">H\u01b0\u1edbng d\u1eabn\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2003\">t\u1ef1 h\u1ecdc Excel 2003<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_loai_bieu_do_cot_trong_Excel\"><\/span>C\u00e1c lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi b\u1ea1n t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t trong nh\u1eefng ki\u1ec3u bi\u1ec3u \u0111\u1ed3 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Bieu_do_cot_ghep\"><\/span>Bi\u1ec3u \u0111\u1ed3 c\u1ed9t gh\u00e9p<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6470 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/clustered-bar-charts-excel.png\" width=\"375\" height=\"200\" title=\"clustered-bar-charts-excel\"><\/p>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 c\u1ed9t gh\u00e9p 2D ho\u1eb7c 3D trong Excel d\u00f9ng \u0111\u1ec3 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb trong 1 h\u1ea1ng m\u1ee5c d\u1eef li\u1ec7u. V\u1edbi ki\u1ec3u bi\u1ec3u \u0111\u1ed3 n\u00e0y, h\u1ea1ng m\u1ee5c d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t \u1edf tr\u1ee5c Y, v\u00e0 gi\u00e1 tr\u1ecb s\u1ebd \u0111\u01b0\u1ee3c chi\u1ebfu theo c\u1ed9t X. \u1ede d\u1ea1ng 3D, bi\u1ec3u \u0111\u1ed3 n\u00e0y s\u1ebd ch\u1ec9 hi\u1ec3n th\u1ecb c\u1ed9t \u1edf d\u1ea1ng 3D ch\u1ee9 k hi\u1ec3n th\u1ecb 2 tr\u1ee5c XY \u1edf d\u1ea1ng 3D.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Bieu_do_cot_chong_chia_phan\"><\/span>Bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng chia ph\u1ea7n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6486 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/stacked-bar-charts-excel.png\" width=\"375\" height=\"200\" title=\"stacked-bar-charts-excel\"><\/p>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 n\u00e0y s\u1ebd gi\u00fap hi\u1ec3n th\u1ecb m\u1ed7i \u0111\u1ed1i t\u01b0\u1ee3ng d\u1eef li\u1ec7u chi\u1ebfm bao nhi\u00eau ph\u1ea7n so v\u1edbi t\u1ed5ng s\u1ed1. C\u0169ng gi\u1ed1ng nh\u01b0 bi\u1ec3u \u0111\u1ed3 d\u1ea1ng c\u1ed9t gh\u00e9p, bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed1ng chia ph\u1ea7n c\u0169ng c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb 2D ho\u1eb7c 3D.<\/p>\n<p><strong>Xem th\u00eam Video h\u01b0\u1edbng d\u1eabn <a href=\"http:\/\/blog.ezworkapp.com\/37-%E2%97%8F-cach-ve-bieu-hinh-cot-trong-excel.html\">V\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb \u00e2m v\u00e0 d\u01b0\u01a1ng<\/a><\/strong><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Bieu_do_cot_chong_100\"><\/span>Bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng 100%<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6459 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/100percent-stacked-bar-charts.png\" width=\"375\" height=\"200\" title=\"100percent-stacked-bar-charts\"><\/p>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 n\u00e0y c\u0169ng l\u00e0 bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng, nh\u01b0ng th\u1ec3 hi\u1ec7n m\u1ed7i \u0111\u1ed1i t\u01b0\u1ee3ng d\u1eef li\u1ec7u chi\u1ebfm bao nhi\u00eau ph\u1ea7n tr\u0103m tr\u00ean tr\u00ean t\u1ed5ng s\u1ed1 100% h\u1ea1ng m\u1ee5c d\u1eef li\u1ec7u.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thiet_ke_hinh_tru_hinh_non_va_hinh_kim_tu_thap\"><\/span>Thi\u1ebft k\u1ebf h\u00ecnh tr\u1ee5, h\u00ecnh n\u00f3n v\u00e0 h\u00ecnh kim t\u1ef1 th\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Gi\u1ed1ng nh\u01b0 bi\u1ec3u \u0111\u1ed3 v\u1edbi c\u1ed9t h\u00ecnh ch\u1eef nh\u1eadt th\u00f4ng th\u01b0\u1eddng, c\u00e1c bi\u1ec3u \u0111\u1ed3 c\u1ed9t h\u00ecnh tr\u1ee5, h\u00ecnh n\u00f3n v\u00e0 h\u00ecnh kim t\u1ef1 th\u00e1p c\u0169ng c\u00f3 s\u1ebd c\u00f3 3 d\u1ea1ng kh\u00e1c bi\u1ec7t n\u00eau tr\u00ean, ch\u1ec9 kh\u00e1c nhau \u1edf h\u00ecnh d\u00e1ng c\u1ee7a c\u1ed9t.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6472 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cylinder-cone-pyramid-charts.png\" width=\"629\" height=\"137\" title=\"cylinder-cone-pyramid-charts\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi phi\u00ean b\u1ea3n Excel 2010 tr\u1edf v\u1ec1 tr\u01b0\u1edbc, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn thi\u1ebft k\u1ebf c\u1ed9t t\u00f9y th\u00edch b\u1eb1ng c\u00e1ch ch\u1ecdn trong tab <em>Insert &gt; Charts.<\/em><\/p>\n<p style=\"text-align: justify\">Khi t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel 2013 v\u00e0 Excel 2016, b\u1ea1n s\u1ebd kh\u00f4ng th\u1ea5y c\u00e1c thi\u1ebft k\u1ebf c\u1ed9t tr\u1ee5, c\u1ed9t n\u00f3n v\u00e0 c\u1ed9t kim t\u1ef1 th\u00e1p trong ph\u1ea7n Charts tr\u00ean thanh c\u00f4ng c\u1ee5 n\u1eefa. L\u00fd do m\u00e0 Microsoft \u0111\u01b0a ra cho vi\u1ec7c \u201ckhai tr\u1eeb\u201d nh\u1eefng thi\u1ebft k\u1ebf c\u1ed9t n\u00e0y l\u00e0 v\u00ec \u0111\u00e3 c\u00f3 qu\u00e1 nhi\u1ec1u l\u1ef1a ch\u1ecdn bi\u1ec3u \u0111\u1ed3 cho ng\u01b0\u1eddi d\u00f9ng \u1edf nh\u1eefng phi\u00ean b\u1ea3n Excel tr\u01b0\u1edbc \u0111\u00f3, khi\u1ebfn cho ng\u01b0\u1eddi d\u00f9ng kh\u00f3 l\u1ef1a ch\u1ecdn \u0111\u01b0\u1ee3c lo\u1ea1i bi\u1ec3u \u0111\u1ed3 ch\u00ednh x\u00e1c nh\u1ea5t. Tuy nhi\u00ean, v\u1eabn c\u00f3 c\u00e1ch \u0111\u1ec3 b\u1ea1n t\u1ea1o ra nh\u1eefng bi\u1ec3u \u0111\u1ed3 c\u1ed9t tr\u1ee5, c\u1ed9t n\u00f3n v\u00e0 c\u1ed9t kim t\u1ef1 th\u00e1p, nh\u01b0ng ch\u00fang s\u1ebd c\u1ea7n b\u1ea1n thao t\u00e1c th\u00eam m\u1ed9t v\u00e0i b\u01b0\u1edbc.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tao_ra_nhung_bieu_do_cot_tru_cot_non_va_cot_kim_tu_thap_trong_Excel_2013_va_2016\"><\/span>C\u00e1ch t\u1ea1o ra nh\u1eefng bi\u1ec3u \u0111\u1ed3 c\u1ed9t tr\u1ee5, c\u1ed9t n\u00f3n v\u00e0 c\u1ed9t kim t\u1ef1 th\u00e1p trong Excel 2013 v\u00e0 2016<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o ra nh\u1eefng bi\u1ec3u \u0111\u1ed3 c\u1ed9t n\u00e0y trong phi\u00ean b\u1ea3n 2013 v\u00e0 2016, b\u1ea1n h\u00e3y t\u1ea1o ra m\u1ed9t trong 3 d\u1ea1ng bi\u1ec3u \u0111\u1ed3 k\u1ec3 tr\u00ean (c\u1ed9t gh\u00e9p, c\u1ed9t ch\u1ed3ng chia ph\u1ea7n v\u00e0 c\u1ed9t ch\u1ed3ng 100%) \u1edf d\u1ea1ng 3D, sau \u0111\u00f3 thay \u0111\u1ed5i h\u00ecnh d\u00e1ng c\u1ed9t nh\u01b0 sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Click ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t tr\u00ean bi\u1ec3u \u0111\u1ed3, nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn <strong>Format Data Series\u2026<\/strong> \u0110\u01a1n gi\u1ea3n h\u01a1n, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n chu\u1ed9t \u0111\u00f4i v\u00e0o c\u1ed9t tr\u00ean bi\u1ec3u \u0111\u1ed3.<\/li>\n<li>\u1ede b\u1ea3ng <em>Format Data Series<\/em>, trong ph\u1ea7n<em> Series Options<\/em>, b\u1ea1n h\u00e3y ch\u1ecdn Column Shape m\u00e0 m\u00ecnh mu\u1ed1n.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6471 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/creating-pyramid-chart.png\" width=\"565\" height=\"452\" title=\"creating-pyramid-chart\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> N\u1ebfu c\u00f3 nhi\u1ec1u tr\u01b0\u1eddng d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n, b\u1ea1n s\u1ebd c\u1ea7n l\u00e0m l\u1ea1i c\u00e1c b\u01b0\u1edbc n\u00e0y \u0111\u1ed1i v\u1edbi t\u1eebng tr\u01b0\u1eddng d\u1eef li\u1ec7u.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">h\u1ecdc Excel c\u01a1 b\u1ea3n 2010<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thiet_ke_bieu_do_cot_dac_biet_trong_Excel\"><\/span>Thi\u1ebft k\u1ebf bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111\u1eb7c bi\u1ec7t trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u0169ng nh\u01b0 nhi\u1ec1u lo\u1ea1i bi\u1ec3u \u0111\u1ed3 kh\u00e1c trong Excel, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t bi\u1ec3u \u0111\u1ed3 mang d\u1ea5u \u1ea5n ri\u00eang b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i c\u00e1c tr\u1ee5c, c\u00e1c nh\u00e3n s\u1ed1 li\u1ec7u, t\u00ean c\u1ee7a bi\u1ec3u \u0111\u1ed3.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thay_doi_do_rong_cua_cot_va_khoang_cach_giua_cac_cot\"><\/span>Thay \u0111\u1ed5i \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t v\u00e0 kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Khi b\u1ea1n t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 c\u1ed9t, c\u1ea5u tr\u00fac m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel s\u1ebd hi\u1ec3n th\u1ecb nhi\u1ec1u kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c c\u1ed9t. \u0110\u1ec3 thay \u0111\u1ed5i \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t v\u00e0 khi\u1ebfn ch\u00fang g\u1ea7n l\u1ea1i v\u1edbi nhau h\u01a1n, b\u1ea1n h\u00e3y l\u00e0m theo nh\u1eefng b\u01b0\u1edbc sau \u0111\u00e2y nh\u00e9. C\u00e1ch n\u00e0y ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 khi\u1ebfn c\u00e1c c\u1ed9t tr\u1edf n\u00ean nh\u1ecf h\u01a1n v\u00e0 t\u0103ng kho\u1ea3ng c\u00e1ch gi\u1eefa ch\u00fang. Trong bi\u1ec3u \u0111\u1ed3 2D, c\u00e1c c\u1ed9t c\u00f2n c\u00f3 th\u1ec3 ch\u1ed3ng l\u1ea5n l\u00ean nhau.<\/p>\n<p style=\"text-align: justify\">1. Trong bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u1ee7a b\u1ea1n, click chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t c\u1ee9 tr\u01b0\u1eddng th\u00f4ng tin n\u00e0o (ch\u00ednh l\u00e0 c\u00e1c c\u1ed9t) v\u00e0 ch\u1ecdn <em>Format Data Series.<\/em><br \/>\n2. Trong <em>Format Data Series<\/em>, \u1edf ph\u1ea7n <em>Series Options<\/em>, h\u00e3y l\u00e0m 1 trong 2 \u01b0\u1edbc sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ed1i v\u1edbi bi\u1ec3u \u0111\u1ed3 2D v\u00e0 3D, \u0111\u1ec3 thay \u0111\u1ed5i \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t v\u00e0 kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c h\u1ea1ng m\u1ee5c d\u1eef li\u1ec7u, b\u1ea1n h\u00e3y k\u00e9o thanh Gap Width ho\u1eb7c \u0111i\u1ec1n c\u00e1c con s\u1ed1 t\u1eeb 0 \u0111\u1ebfn 500. M\u1ee9c c\u00e0ng th\u1ea5p, kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c c\u1ed9t v\u00e0 \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t c\u00e0ng nh\u1ecf.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6487 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-gap-width-1.png\" width=\"636\" height=\"279\" title=\"change-gap-width-1\"><\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ed1i v\u1edbi bi\u1ec3u \u0111\u1ed3 2D, \u0111\u1ec3 thay \u0111\u1ed5i kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u trong m\u1ed9t h\u1ea1ng m\u1ee5c d\u1eef li\u1ec7u, b\u1ea1n h\u00e3y k\u00e9o thanh Series Overlap ho\u1eb7c \u0111i\u1ec1n c\u00e1c con s\u1ed1 t\u1eeb -100 \u0111\u1ebfn 100. Gi\u00e1 tr\u1ecb c\u00e0ng cao, c\u00e1c c\u1ed9t s\u1ebd c\u00e0ng ch\u1ed3ng l\u1ea5n l\u00ean nhau. Khi b\u1ea1n \u0111i\u1ec1n s\u1ed1 \u00e2m, kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb nh\u01b0 sau:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6464 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-bars-overlap.png\" width=\"608\" height=\"261\" title=\"change-bars-overlap\"><\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ed1i v\u1edbi bi\u1ec3u \u0111\u1ed3 3D, \u0111\u1ec3 thay \u0111\u1ed5i kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u, b\u1ea1n h\u00e3y k\u00e9o thanh Gap Depth sang tr\u00e1i ho\u1eb7c ph\u1ea3i ho\u1eb7c \u0111i\u1ec1n s\u1ed1 t\u1eeb 0 \u0111\u1ebfn 500. Gi\u00e1 tr\u1ecb c\u00e0ng cao, kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c thanh c\u00e0ng l\u1edbn. Th\u1ef1c t\u1ebf, thay \u0111\u1ed5i gi\u00e1 tr\u1ecb Gap Depth s\u1ebd r\u1ea5t r\u00f5 r\u00e0ng trong h\u1ea7u h\u1ebft c\u00e1c bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u1ee7a Excel, nh\u01b0ng ta s\u1ebd nh\u1eadn ra s\u1ef1 thay \u0111\u1ed5i \u0111\u00e1ng k\u1ec3 nh\u1ea5t \u1edf d\u1ea1ng bi\u1ec3u \u0111\u1ed3 3D:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6488 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-gap-depth-1.png\" width=\"620\" height=\"242\" title=\"change-gap-depth-1\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_bieu_do_cot_voi_gia_tri_am\"><\/span>T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t v\u1edbi gi\u00e1 tr\u1ecb \u00e2m<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Khi b\u1ea1n t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel, c\u00e1c s\u1ed1 li\u1ec7u kh\u00f4ng c\u1ea7n thi\u1ebft ph\u1ea3i l\u1edbn h\u01a1n 0. Nh\u00ecn chung, Excel ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb s\u1ed1 \u00e2m trong m\u1ed9t bi\u1ec3u \u0111\u1ed3 c\u1ed9t th\u00f4ng th\u01b0\u1eddng nh\u01b0ng \u0111\u1ecbnh d\u1ea1ng c\u0169ng nh\u01b0 thi\u1ebft k\u1ebf c\u00f3 th\u1ec3 s\u1ebd kh\u00f4ng v\u1eeba m\u1eaft b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6460 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bar-chart-negative-values.png\" width=\"335\" height=\"229\" title=\"bar-chart-negative-values\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 bi\u1ec3u \u0111\u1ed3 \u1edf tr\u00ean tr\u00f4ng \u0111\u1eb9p h\u01a1n v\u00e0 th\u1ec3 hi\u1ec7n h\u00ecnh \u1ea3nh t\u1ed1t h\u01a1n, b\u1ea1n s\u1ebd ph\u1ea3i di chuy\u1ec3n tr\u1ee5c Y sang b\u00ean tr\u00e1i \u0111\u1ec3 t\u00ean c\u1ee7a tr\u01b0\u1eddng d\u1eef li\u1ec7u kh\u00f4ng \u0111\u00e8 l\u00ean c\u00e1c c\u1ed9t, v\u00e0 sau \u0111\u00f3 thay \u0111\u1ed5i m\u00e0u s\u1eafc cho c\u00e1c c\u1ed9t hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb \u00e2m.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thay_doi_vi_tri_truc_Y\"><\/span>Thay \u0111\u1ed5i v\u1ecb tr\u00ed tr\u1ee5c Y<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f3 th\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a tr\u1ee5c Y, b\u1ea1n hay click chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t c\u1ee9 t\u00ean h\u1ea1ng m\u1ee5c d\u1eef li\u1ec7u n\u00e0o, ch\u1ecdn <strong>Format Axis..<\/strong>. ho\u1eb7c ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 click chu\u1ed9t \u0111\u00f4i v\u1edbi t\u00ean h\u1ea1ng m\u1ee5c. B\u1ea3ng Format Axis s\u1ebd xu\u1ea5t hi\u1ec7n b\u00ean ph\u1ea3i c\u1ee7a trang t\u00ednh.<\/p>\n<p style=\"text-align: justify\">T\u1ea1i b\u1ea3ng n\u00e0y, b\u1ea1n h\u00e3y \u0111\u1ec3 \u00fd trong tab Axis Options c\u00f3 <em>Labels &gt; Label Position &gt; <\/em>Ch\u1ecdn<em> Low<\/em>.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6482 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/modify-axis-labels.png\" width=\"610\" height=\"340\" title=\"modify-axis-labels\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thay_doi_mau_sac_cua_cac_cot_co_gia_tri_am\"><\/span>Thay \u0111\u1ed5i m\u00e0u s\u1eafc c\u1ee7a c\u00e1c c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb \u00e2m<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n nh\u1eefng c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb \u00e2m \u0111\u01b0\u1ee3c n\u1ed5i b\u1eadt trong bi\u1ec3u \u0111\u1ed3 c\u1ee7a m\u00ecnh, b\u1ea1n n\u00ean c\u00e2n nh\u1eafc vi\u1ec7c thay \u0111\u1ed5i m\u00e0u s\u1eafc c\u1ee7a nh\u1eefng c\u1ed9t n\u00e0y.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n ch\u1ec9 c\u00f3 1 tr\u01b0\u1eddng d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ed5i m\u00e0u c\u1ee7a c\u00e1c c\u1ed9t \u00e2m th\u00e0nh \u0111\u1ecf. N\u1ebfu c\u00f3 nhi\u1ec1u h\u01a1n m\u1ed9t tr\u01b0\u1eddng d\u1eef li\u1ec7u, b\u1ea1n s\u1ebd c\u1ea7n thay \u0111\u1ed5i m\u00e0u s\u1eafc c\u1ee7a c\u00e1c c\u1ed9t \u00e2m kh\u00e1c nhau theo t\u1eebng tr\u01b0\u1eddng d\u1eef li\u1ec7u. V\u00ed d\u1ee5, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 gi\u1eef m\u00e0u s\u1eafc t\u1ef1 nhi\u00ean c\u1ee7a c\u00e1c c\u1ed9t d\u01b0\u01a1ng, v\u00e0 d\u00f9ng m\u00e0u s\u1eafc nh\u1ea1t h\u01a1n cho c\u00e1c c\u1ed9t \u00e2m.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 thay \u0111\u1ed5i m\u00e0u s\u1eafc c\u1ee7a c\u00e1c c\u1ed9t \u00e2m, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<br \/>\n1. Click chu\u1ed9t ph\u1ea3i v\u00e0o c\u1ed9t b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i m\u00e0u s\u1eafc v\u00e0 ch\u1ecdn <em>Format Data Series\u2026<\/em><br \/>\n2. \u1ede c\u1ed9t <em>Format Data Series &gt; tab Fill &amp; Line &gt;<\/em> tick d\u1ea5u ch\u1ecdn \u1edf \u00f4<strong><em> Invert if Negative<\/em><\/strong>.<br \/>\n3. Ngay khi b\u1ea1n \u0111\u00e1nh d\u1ea5u tick cho \u00f4 n\u00e0y, b\u1ea1n s\u1ebd th\u1ea5y c\u00f3 hai l\u1ef1a ch\u1ecdn m\u00e0u s\u1eafc trong ph\u1ea7n Color, l\u1ef1a ch\u1ecdn \u0111\u1ea7u ti\u00ean l\u00e0 cho c\u1ed9t d\u01b0\u01a1ng v\u00e0 l\u1ef1a ch\u1ecdn th\u1ee9 hai l\u00e0 cho c\u1ed9t \u00e2m.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6489 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/invert-if-negative-1.png\" width=\"617\" height=\"413\" title=\"invert-if-negative-1\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o.<\/strong> N\u1ebfu l\u1ef1a ch\u1ecdn th\u1ee9 hai kh\u00f4ng xu\u1ea5t hi\u1ec7n, h\u00e3y click v\u00e0o d\u1ea5u m\u0169i t\u00ean \u1edf l\u1ef1a ch\u1ecdn m\u00e0u duy nh\u1ea5t hi\u1ec3n th\u1ecb, v\u00e0 ch\u1ecdn b\u1ea5t c\u1ee9 m\u00e0u n\u00e0o m\u00e0 b\u1ea1n mu\u1ed1n cho c\u1ed9t \u00e2m Khi b\u1ea1n l\u00e0m nh\u01b0 v\u1eady, l\u1ef1a ch\u1ecdn m\u00e0u s\u1eafc th\u1ee9 2 s\u1ebd xu\u1ea5t hi\u1ec7n:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6465 \" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-color-positive-values.png\" width=\"400\" height=\"421\" title=\"change-color-positive-values\"><\/p>\n<p style=\"text-align: justify\"><strong>\u0110\u1eebng v\u1ed9i b\u1ecf qua<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">C\u00e1c h\u00e0m th\u00f4ng d\u1ee5ng trong Excel<\/a><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Sap_xep_du_lieu_trong_bieu_do_cot\"><\/span>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Khi b\u1ea1n t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 c\u1ed9t, c\u00e1c h\u1ea1ng m\u1ee5c d\u1eef li\u1ec7u s\u1ebd b\u1ecb \u0111\u1ea3o ng\u01b0\u1ee3c th\u1ee9 t\u1ef1 xu\u1ea5t hi\u1ec7n trong b\u1ea3ng d\u1eef li\u1ec7u. Ngh\u0129a l\u00e0, n\u1ebfu b\u1ea1n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1 A-Z trong b\u1ea3ng d\u1eef li\u1ec7u, bi\u1ec3u \u0111\u1ed3 s\u1ebd hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u t\u1eeb Z-A. M\u1eb7c d\u00f9 ch\u1eb3ng ai hi\u1ec3u \u0111\u01b0\u1ee3c l\u00fd do c\u1ee7a Microsoft khi s\u1eafp x\u1ebfp nh\u01b0 v\u1eady, nh\u01b0ng ch\u00fang ta s\u1ebd c\u00f3 ph\u01b0\u01a1ng \u00e1n cho b\u00e0i to\u00e1n n\u00e0y.<\/p>\n<p style=\"text-align: justify\">C\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 \u0111\u1ea3o ng\u01b0\u1ee3c th\u1ee9 t\u1ef1 c\u1ee7a h\u1ea1ng m\u1ee5c d\u1eef li\u1ec7u khi b\u1ea1n s\u1eafp x\u1ebfp ch\u00fang trong b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\">H\u00e3y c\u00f9ng nh\u00ecn v\u00e0o m\u1ed9t v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 hi\u1ec3u h\u01a1n c\u00e1ch l\u00e0m n\u00e0y nh\u00e9. Trong trang t\u00ednh, ta c\u00f3 1 b\u1ea3ng d\u1eef li\u1ec7u 10 th\u00e0nh ph\u1ed1 \u0111\u00f4ng d\u00e2n nh\u1ea5t th\u1ebf gi\u1edbi x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n, t\u1eeb cao nh\u1ea5t \u0111\u1ebfn th\u1ea5p nh\u1ea5t. Trong bi\u1ec3u \u0111\u1ed3 c\u1ed9t, d\u1eef li\u1ec7u s\u1ebd xu\u1ea5t hi\u1ec7n theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n, t\u1eeb th\u1ea5p nh\u1ea5t \u0111\u1ebfn cao nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 ng\u01b0\u1ee3c l\u1ea1i, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong b\u1ea3ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n v\u00e0 bi\u1ec3u \u0111\u1ed3 s\u1ebd t\u1ef1 \u0111\u1ed9ng s\u1eafp x\u1ebfp d\u1eef li\u1ec7u gi\u1ea3m d\u1ea7n.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6462 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bar-chart-sort-descending.png\" width=\"630\" height=\"241\" title=\"bar-chart-sort-descending\"><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, v\u00ec m\u1ed9t s\u1ed1 l\u00fd do m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng mu\u1ed1n l\u00e0m s\u1eafp x\u1ebfp l\u1ea1i th\u1ee9 t\u1ef1 trong b\u1ea3ng d\u1eef li\u1ec7u, d\u1eabn \u0111\u1ebfn c\u00e1ch th\u1ee9 2 ngay d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Sap_xep_du_lieu_tang_dangiam_dan_trong_bieu_do_cot_Excel_ma_khong_thay_doi_thu_tu_du_lieu_trong_bang_tinh\"><\/span>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u t\u0103ng d\u1ea7n\/gi\u1ea3m d\u1ea7n trong bi\u1ec3u \u0111\u1ed3 c\u1ed9t Excel m\u00e0 kh\u00f4ng thay \u0111\u1ed5i th\u1ee9 t\u1ef1 d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">C\u00e1ch n\u00e0y kh\u00e1 \u0111\u01a1n gi\u1ea3n, ch\u1ec9 y\u00eau c\u1ea7u b\u1ea1n ph\u1ea3i l\u00e0m th\u00eam m\u1ed9t v\u00e0i b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<br \/>\n1. Tr\u00ean bi\u1ec3u \u0111\u1ed3, b\u1ea1n h\u00e3y click chu\u1ed9t ph\u1ea3i v\u00e0o tr\u1ee5c Y v\u00e0 ch\u1ecdn <em>Format Axis\u2026,<\/em> ho\u1eb7c ch\u1ec9 c\u1ea7n click chu\u1ed9t \u0111\u00f4i v\u00e0o tr\u1ee5c Y \u0111\u1ec3 b\u1ea3ng Format Axis xu\u1ea5t hi\u1ec7n.<br \/>\n2. Tr\u00ean b\u1ea3ng Format Axis, ph\u1ea7n Axis Options, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Trong ph\u1ea7n <strong>Horizontal axis crosses<\/strong>, tick ch\u1ecdn <strong>At maximum category.<\/strong><\/li>\n<li>Trong ph\u1ea7n <em>Axis position &gt; <\/em>tick ch\u1ecdn<em> Categories in reverse order<\/em>.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6485 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sort-bar-chart-descending-ascending.png\" width=\"636\" height=\"520\" title=\"sort-bar-chart-descending-ascending\"><\/p>\n<p style=\"text-align: justify\">V\u1eady l\u00e0 \u0111\u00e3 xong. Bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u1ee7a b\u1ea1n s\u1ebd ngay l\u1eadp t\u1ee9c \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo \u0111\u00fang th\u1ee9 t\u1ef1 d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n. Ngay khi b\u1ea1n thay \u0111\u1ed5i th\u1ee9 t\u1ef1 trong b\u1ea3ng d\u1eef li\u1ec7u, bi\u1ec3u \u0111\u1ed3 c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp l\u1ea1i m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thay_doi_thu_tu_cua_truong_du_lieu_trong_bieu_do\"><\/span>Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u1ee7a tr\u01b0\u1eddng d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n c\u00f3 nhi\u1ec1u tr\u01b0\u1eddng d\u1eef li\u1ec7u, ch\u00fang c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 ng\u01b0\u1ee3c l\u1ea1i so v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u. B\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n th\u00f4ng qua h\u00ecnh \u1ea3nh sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6474 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-series-order-1.png\" width=\"300\" height=\"342\" title=\"data-series-order-1\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 s\u1eafp x\u1ebfp tr\u01b0\u1eddng d\u1eef li\u1ec7u theo \u0111\u00fang th\u1ee9 t\u1ef1 trong trang t\u00ednh, b\u1ea1n s\u1ebd c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 tr\u00ean, ngh\u0129a l\u00e0 tick v\u00e0o \u00f4 At maximum category v\u00e0 Categories in reverse order trong Format Axis. C\u00e1ch n\u00e0y \u00e1p d\u1ee5ng cho c\u1ea3 tr\u01b0\u1eddng d\u1eef li\u1ec7u l\u1eabn h\u1ea1ng m\u1ee5c d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6469 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-order-data-series.png\" width=\"590\" height=\"459\" title=\"change-order-data-series\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp tr\u01b0\u1eddng d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1 kh\u00e1c v\u1edbi th\u1ee9 t\u1ef1 trong trang t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u1ed9p tho\u1ea1i Select Data Source ho\u1eb7c c\u00f4ng th\u1ee9c Data series \u0111\u1ec3 th\u1ef1c hi\u1ec7n.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thay_doi_thu_tu_truong_du_lieu_bang_hop_thoai_Select_Data_Source\"><\/span>Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 tr\u01b0\u1eddng d\u1eef li\u1ec7u b\u1eb1ng h\u1ed9p tho\u1ea1i Select Data Source<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">C\u00e1ch n\u00e0y cho ph\u00e9p b\u1ea1n thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ee7a t\u1eebng tr\u01b0\u1eddng d\u1eef li\u1ec7u ri\u00eang bi\u1ec7t v\u00e0 gi\u1eef l\u1ea1i th\u1ee9 t\u1ef1 trong trang t\u00ednh.<\/p>\n<p style=\"text-align: justify\">1. Ch\u1ecdn bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 tab Chart Tools xu\u1ea5t hi\u1ec7n. V\u00e0o tab <em>Design &gt; Data<\/em> v\u00e0 ch\u1ecdn <em>Select Data<\/em>.<\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 click v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Chart Filters ngay b\u00ean ph\u1ea3i c\u1ee7a bi\u1ec3u \u0111\u1ed3, sau \u0111\u00f3 click v\u00e0o Select Data \u1edf cu\u1ed1i.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6484 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-data.png\" width=\"585\" height=\"514\" title=\"select-data\"><\/p>\n<p style=\"text-align: justify\">2. Trong h\u1ed9p tho\u1ea1i Select Data Source, b\u1ea1n h\u00e3y ch\u1ecdn tr\u01b0\u1eddng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i th\u1ee9 t\u1ef1 v\u00e0 k\u00e9o n\u00f3 l\u00ean xu\u1ed1ng b\u1eb1ng c\u00e1ch d\u00f9ng d\u1ea5u m\u0169i t\u00ean t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6483 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/move-data-series.png\" width=\"598\" height=\"326\" title=\"move-data-series\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thay_doi_thu_tu_truong_du_lieu_bang_cong_thuc\"><\/span>Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 tr\u01b0\u1eddng d\u1eef li\u1ec7u b\u1eb1ng c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">V\u00ec m\u1ed7i tr\u01b0\u1eddng d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 Excel \u0111\u1ec1u \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1eb1ng m\u1ed9t c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i tr\u01b0\u1eddng d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i c\u00f4ng th\u1ee9c t\u01b0\u01a1ng \u1ee9ng. Trong b\u00e0i vi\u1ebft n\u00e0y, ta s\u1ebd ch\u1ec9 quan t\u00e2m \u0111\u1ebfn vi\u1ec7c x\u00e1c \u0111\u1ecbnh th\u1ee9 t\u1ef1 c\u1ee7a tr\u01b0\u1eddng d\u1eef li\u1ec7u thay v\u00ec c\u00e1ch thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c cho tr\u01b0\u1eddng d\u1eef li\u1ec7u \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, c\u1ed9t m\u00e0u x\u00e1m n\u1eb1m \u1edf v\u1ecb tr\u00ed th\u1ee9 3 trong bi\u1ec3u \u0111\u1ed3:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6473 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-series-formula-1.png\" width=\"482\" height=\"347\" title=\"data-series-formula-1\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 thay \u0111\u1ed5i v\u1ecb tr\u00ed, b\u1ea1n h\u00e3y click chu\u1ed9t ch\u1ecdn c\u1ed9t d\u1eef li\u1ec7u, sau \u0111\u00f3 thay \u0111\u1ed5i c\u00f4ng th\u1ee9c tr\u00ean thanh c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i con s\u1ed1 cu\u1ed1i c\u00f9ng. Nh\u01b0 trong v\u00ed d\u1ee5 n\u00e0y, con s\u1ed1 cu\u1ed1i c\u00f9ng trong c\u00f4ng th\u1ee9c l\u00e0 3 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ed5i th\u00e0nh 1.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6466 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-data-series-formula.png\" width=\"472\" height=\"338\" title=\"change-data-series-formula\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady, tr\u01b0\u1eddng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp l\u1ea1i trong bi\u1ec3u \u0111\u1ed3 m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng d\u1ebfn th\u1ee9 t\u1ef1 trong trang t\u00ednh.<\/p>\n<p style=\"text-align: justify\">Tr\u00ean \u0111\u00e2y l\u00e0 ph\u1ea7n h\u01b0\u1edbng d\u1eabn c\u00e1c thao t\u00e1c b\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n v\u1edbi m\u1ed9t bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel. C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 d\u00e0nh th\u1eddi gian \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y v\u00e0 h\u1eb9n g\u1eb7p l\u1ea1i trong nh\u1eefng b\u00e0i h\u01b0\u1edbng d\u1eabn ti\u1ebfp theo.<\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online<\/em><\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-247.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6384,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6383","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\/6383","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=6383"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6383\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6384"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}