{"id":10130,"date":"2025-01-08T11:54:49","date_gmt":"2025-01-08T11:54:49","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/08\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel\/"},"modified":"2025-01-08T11:54:49","modified_gmt":"2025-01-08T11:54:49","slug":"huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/08\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb \u00e2m d\u01b0\u01a1ng kh\u00e1c m\u00e0u tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>V\u1ebd bi\u1ec3u \u0111\u1ed3 d\u1ea1ng h\u00ecnh c\u1ed9t l\u00e0 m\u1ed9t trong nh\u1eefng y\u00eau c\u1ea7u c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p trong th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c. Tuy nhi\u00ean c\u00f3 m\u1ed9t v\u1ea5n \u0111\u1ec1 l\u00e0 ch\u00fang ta s\u1ebd l\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 th\u1ec3 hi\u1ec7n tr\u00ean c\u00f9ng 1 bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t v\u1eeba c\u00f3 gi\u00e1 tr\u1ecb \u00e2m, v\u1eeba c\u00f3 gi\u00e1 tr\u1ecb d\u01b0\u01a1ng, v\u00e0 tr\u00ean bi\u1ec3u \u0111\u1ed3 \u0111\u00f3 gi\u00e1 tr\u1ecb \u00e2m th\u1ec3 hi\u1ec7n b\u1eb1ng 1 m\u00e0u, gi\u00e1 tr\u1ecb d\u01b0\u01a1ng th\u1ec3 hi\u1ec7n b\u1eb1ng m\u1ed9t m\u00e0u kh\u00e1c? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m nh\u00e9.<\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 ch\u00fang ta s\u1ebd \u0111\u1ea1t \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21370\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-bieu-do-cot-am-duong-khac-mau.png\" width=\"959\" height=\"323\" title=\"ket-qua-bieu-do-cot-am-duong-khac-mau\"><\/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-677e67891ced0\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html#Xac_dinh_du_lieu_va_dang_bieu_do\" title=\"X\u00e1c \u0111\u1ecbnh d\u1eef li\u1ec7u v\u00e0 d\u1ea1ng bi\u1ec3u \u0111\u1ed3\">X\u00e1c \u0111\u1ecbnh d\u1eef li\u1ec7u v\u00e0 d\u1ea1ng bi\u1ec3u \u0111\u1ed3<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html#Du_lieu_nhu_the_nao\" title=\"D\u1eef li\u1ec7u nh\u01b0 th\u1ebf n\u00e0o?\">D\u1eef li\u1ec7u nh\u01b0 th\u1ebf n\u00e0o?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html#Dang_bieu_do_nao\" title=\"D\u1ea1ng bi\u1ec3u \u0111\u1ed3 n\u00e0o?\">D\u1ea1ng bi\u1ec3u \u0111\u1ed3 n\u00e0o?<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html#Ve_nhu_the_nao\" title=\"V\u1ebd nh\u01b0 th\u1ebf n\u00e0o?\">V\u1ebd nh\u01b0 th\u1ebf n\u00e0o?<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html#Ve_bieu_do_cot_va_to_mau_phan_biet_phan_gia_tri_am_khac_mau\" title=\"V\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t v\u00e0 t\u00f4 m\u00e0u ph\u00e2n bi\u1ec7t ph\u1ea7n gi\u00e1 tr\u1ecb \u00e2m kh\u00e1c m\u00e0u\">V\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t v\u00e0 t\u00f4 m\u00e0u ph\u00e2n bi\u1ec7t ph\u1ea7n gi\u00e1 tr\u1ecb \u00e2m kh\u00e1c m\u00e0u<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html#Trang_tri_bieu_do_the_nao_cho_dep\" title=\"Trang tr\u00ed bi\u1ec3u \u0111\u1ed3 th\u1ebf n\u00e0o cho \u0111\u1eb9p?\">Trang tr\u00ed bi\u1ec3u \u0111\u1ed3 th\u1ebf n\u00e0o cho \u0111\u1eb9p?<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html#Chuan_hoa_lai_du_lieu_trong_bieu_do\" title=\"Chu\u1ea9n h\u00f3a l\u1ea1i d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3\">Chu\u1ea9n h\u00f3a l\u1ea1i d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html#Can_deu_do_lon_cua_truc_tung\" title=\"C\u0103n \u0111\u1ec1u \u0111\u1ed9 l\u1edbn c\u1ee7a tr\u1ee5c tung\">C\u0103n \u0111\u1ec1u \u0111\u1ed9 l\u1edbn c\u1ee7a tr\u1ee5c tung<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html#Bieu_dien_gia_tri_nam_tai_truc_hoanh_ben_ngoai_pham_vi_bieu_do\" title=\"Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb n\u0103m t\u1ea1i tr\u1ee5c ho\u00e0nh b\u00ean ngo\u00e0i ph\u1ea1m vi bi\u1ec3u \u0111\u1ed3\">Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb n\u0103m t\u1ea1i tr\u1ee5c ho\u00e0nh b\u00ean ngo\u00e0i ph\u1ea1m vi bi\u1ec3u \u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html#Bieu_dien_so_lieu_tren_tung_cot_cua_bieu_do\" title=\"Bi\u1ec3u di\u1ec5n s\u1ed1 li\u1ec7u tr\u00ean t\u1eebng c\u1ed9t c\u1ee7a bi\u1ec3u \u0111\u1ed3\">Bi\u1ec3u di\u1ec5n s\u1ed1 li\u1ec7u tr\u00ean t\u1eebng c\u1ed9t c\u1ee7a bi\u1ec3u \u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html#Bieu_dien_duong_Gridline_tren_bieu_do\" title=\"Bi\u1ec3u di\u1ec5n \u0111\u01b0\u1eddng Gridline tr\u00ean bi\u1ec3u \u0111\u1ed3\">Bi\u1ec3u di\u1ec5n \u0111\u01b0\u1eddng Gridline tr\u00ean bi\u1ec3u \u0111\u1ed3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Xac_dinh_du_lieu_va_dang_bieu_do\"><\/span>X\u00e1c \u0111\u1ecbnh d\u1eef li\u1ec7u v\u00e0 d\u1ea1ng bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y l\u00e0 b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean c\u1ea7n ph\u1ea3i l\u00e0m khi ch\u00fang ta g\u1eb7p ph\u1ea3i 1 y\u00eau c\u1ea7u <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016.html\"><strong>v\u1ebd bi\u1ec3u \u0111\u1ed3trong Excel<\/strong><\/a>. Nh\u1eefng c\u00e2u h\u1ecfi c\u1ea7n ph\u1ea3i tr\u1ea3 l\u1eddi l\u1ea7n l\u01b0\u1ee3t l\u00e0:<\/p>\n<ul>\n<li>D\u1eef li\u1ec7u ta c\u00f3 l\u00e0 g\u00ec?\u00a0C\u00f3 th\u1ec3 v\u1ebd \u0111\u01b0\u1ee3c tr\u1ef1c ti\u1ebfp ngay kh\u00f4ng? =&gt; D\u1eef li\u1ec7u nh\u01b0 th\u1ebf n\u00e0o?<\/li>\n<li>N\u1ebfu v\u1ebd th\u00ec v\u1ebd d\u1ea1ng bi\u1ec3u \u0111\u1ed3 n\u00e0o?<\/li>\n<li>Cu\u1ed1i c\u00f9ng m\u1edbi \u0111\u1ebfn c\u00e2u h\u1ecfi: V\u1ebd nh\u01b0 th\u1ebf n\u00e0o?<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Du_lieu_nhu_the_nao\"><\/span>D\u1eef li\u1ec7u nh\u01b0 th\u1ebf n\u00e0o?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta c\u00f3 1 b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m 6 n\u0103m, t\u1eeb 2014 \u0111\u1ebfn 2019. Trong \u0111\u00f3 c\u00f3 3 ch\u1ec9 ti\u00eau: Doanh thu, Chi ph\u00ed, L\u1ee3i nhu\u1eadn.<\/p>\n<p>M\u1ee5c ti\u00eau l\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3 th\u1ec3 hi\u1ec7n gi\u00e1 tr\u1ecb l\u1ee3i nhu\u1eadn. \u0110\u1eb7c tr\u01b0ng c\u1ee7a d\u1eef li\u1ec7u l\u1ee3i nhu\u1eadn n\u00e0y l\u00e0:<\/p>\n<ul>\n<li>D\u1eef li\u1ec7u d\u1ea1ng s\u1ed1<\/li>\n<li>Bao g\u1ed3m c\u1ea3 gi\u00e1 tr\u1ecb \u00e2m v\u00e0 d\u01b0\u01a1ng<\/li>\n<\/ul>\n<p>Do \u0111\u00f3 \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd \u1edf \u0111\u00e2y l\u00e0:<\/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-135.gif\" title=\"ex101_92019-nho-135\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>N\u1ebfu ch\u1ecdn bi\u1ec3u \u0111\u1ed3 c\u1ed9t th\u00ec gi\u00e1 tr\u1ecb d\u01b0\u01a1ng s\u1ebd h\u01b0\u1edbng l\u00ean tr\u00ean, c\u00f2n gi\u00e1 tr\u1ecb \u00e2m s\u1ebd h\u01b0\u1edbng xu\u1ed1ng d\u01b0\u1edbi.<\/li>\n<li>C\u1ea7n ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c ph\u1ea7n \u00e2m v\u00e0 ph\u1ea7n d\u01b0\u01a1ng tr\u00ean bi\u1ec3u \u0111\u1ed3.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Dang_bieu_do_nao\"><\/span>D\u1ea1ng bi\u1ec3u \u0111\u1ed3 n\u00e0o?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y d\u01b0\u1edbi d\u1ea1ng li\u1ec7t k\u00ea, d\u1eef li\u1ec7u ch\u1ec9 c\u00f3 1 d\u1ea1ng\u00a0 th\u00ec th\u00f4ng th\u01b0\u1eddng ch\u00fang ta hay v\u1ebd b\u1eb1ng lo\u1ea1i bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t th\u00f4ng th\u01b0\u1eddng (kh\u00f4ng ph\u1ea3i c\u1ed9t ch\u1ed3ng l\u00ean nhau)<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ve_nhu_the_nao\"><\/span>V\u1ebd nh\u01b0 th\u1ebf n\u00e0o?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Ve_bieu_do_cot_va_to_mau_phan_biet_phan_gia_tri_am_khac_mau\"><\/span>V\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t v\u00e0 t\u00f4 m\u00e0u ph\u00e2n bi\u1ec7t ph\u1ea7n gi\u00e1 tr\u1ecb \u00e2m kh\u00e1c m\u00e0u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu v\u1ebd tr\u1ef1c ti\u1ebfp bi\u1ec3u \u0111\u1ed3 t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean, ch\u00fang ta c\u00f3:<\/p>\n<ul>\n<li>Ch\u1ecdn v\u00f9ng <strong>D1:D7<\/strong><\/li>\n<li>Ch\u1ecdn th\u1ebb <strong>Insert\/ Chart\/ 2D column\/ Clustered Column<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21371\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ve-bieu-do-cot-thong-thuong.png\" width=\"1240\" height=\"766\" title=\"ve-bieu-do-cot-thong-thuong\"><\/p>\n<p>Sau khi v\u1ebd ra bi\u1ec3u \u0111\u1ed3 n\u00e0y, ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh \u0111\u1ed5i m\u00e0u cho ph\u1ea7n c\u1ed9t th\u1ec3 hi\u1ec7n gi\u00e1 tr\u1ecb \u00e2m nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m ch\u1ecdn v\u00e0o ph\u1ea7n c\u1ed9t c\u1ee7a bi\u1ec3u \u0111\u1ed3 r\u1ed3i ch\u1ecdn Format Data Series<\/li>\n<li>Trong ph\u1ea7n Format Data Series ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng t\u00f4 m\u00e0u, m\u1ee5c Fill =&gt; \u0110\u00e1nh d\u1ea5u v\u00e0o \u00f4<strong> Invert if ngative<\/strong><\/li>\n<li>Ti\u1ebfp theo ch\u1ecdn m\u00e0u cho ph\u1ea7n gi\u00e1 tr\u1ecb d\u01b0\u01a1ng (b\u00ean tr\u00e1i), m\u00e0u cho gi\u00e1 tr\u1ecb \u00e2m (b\u00ean ph\u1ea3i)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21372\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/to-mau-gia-tri-am-duong-khac-nhau.png\" width=\"944\" height=\"470\" title=\"to-mau-gia-tri-am-duong-khac-nhau\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y ph\u1ea7n c\u1ed9t gi\u00e1 tr\u1ecb d\u01b0\u01a1ng c\u00f3 1 m\u00e0u ri\u00eang, ph\u1ea7n c\u1ed9t gi\u00e1 tr\u1ecb \u00e2m c\u00f3 m\u00e0u kh\u00e1c r\u1ed3i. Nh\u01b0ng nh\u01b0 v\u1eady ch\u01b0a ph\u1ea3i l\u00e0 xong. B\u1edfi 1 y\u1ebfu t\u1ed1 r\u1ea5t quan tr\u1ecdng c\u1ee7a bi\u1ec3u \u0111\u1ed3 ch\u00ednh l\u00e0 t\u00ednh th\u1ea9m m\u1ef9. N\u1ebfu b\u1ecf qua y\u1ebfu t\u1ed1 n\u00e0y th\u00ec bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n s\u1ebd m\u1ea5t t\u1edbi 70% gi\u00e1 tr\u1ecb.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Trang_tri_bieu_do_the_nao_cho_dep\"><\/span>Trang tr\u00ed bi\u1ec3u \u0111\u1ed3 th\u1ebf n\u00e0o cho \u0111\u1eb9p?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Chuan_hoa_lai_du_lieu_trong_bieu_do\"><\/span>Chu\u1ea9n h\u00f3a l\u1ea1i d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00f4i khi vi\u1ec7c t\u1ef1 \u0111\u1ed9ng x\u00e1c \u0111\u1ecbnh n\u1ed9i dung c\u1ee7a bi\u1ec3u \u0111\u1ed3 d\u1eabn t\u1edbi vi\u1ec7c l\u1ea5y th\u1eeba \/ thi\u1ebfu n\u1ed9i dung c\u1ea7n th\u1ec3 hi\u1ec7n. Do \u0111\u00f3 ch\u00fang ta c\u1ea7n ki\u1ec3m tra, x\u00e1c \u0111\u1ecbnh l\u1ea1i c\u00e1c n\u1ed9i dung n\u00e0y b\u1eb1ng c\u00e1ch:<\/p>\n<ul>\n<li>B\u1ea5m v\u00e0o bi\u1ec3u \u0111\u1ed3 (kho\u1ea3ng tr\u1ed1ng b\u1ea5t k\u1ef3 trong bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 ch\u1ecdn bi\u1ec3u \u0111\u1ed3)<\/li>\n<li>Tr\u00ean thanh c\u00f4ng c\u1ee5 xu\u1ea5t hi\u1ec7n th\u1ebb Chart Tools &gt; trong th\u1ebb n\u00e0y ch\u1ecdn th\u1ebb Design &gt; Ch\u1ecdn m\u1ee5c Select Data<\/li>\n<li>Edit l\u1ea1i c\u00e1c n\u1ed9i dung c\u1ee7a bi\u1ec3u \u0111\u1ed3:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21373\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/edit-select-data-bieu-do.png\" width=\"712\" height=\"406\" title=\"edit-select-data-bieu-do\"><\/p>\n<p style=\"padding-left: 60px\"><strong>Horizontal Axis Labels<\/strong>: n\u1ed9i dung tr\u00ean tr\u1ee5c ho\u00e0nh. B\u1ea5m edit v\u00e0 ch\u1ecdn v\u00f9ng <strong>A2:A7<\/strong><\/p>\n<p style=\"padding-left: 60px\"><strong>Legen Entries (Series)<\/strong>: n\u1ed9i dung v\u1ebd tr\u00ean bi\u1ec3u \u0111\u1ed3. B\u1ea5m ch\u1ecdn L\u1ee3i nhu\u1eadn, sau \u0111\u00f3 b\u1ea5m Edit:<\/p>\n<p style=\"padding-left: 90px\">Series name: ch\u1ecdn \u00f4 <strong>D1<\/strong><\/p>\n<p style=\"padding-left: 90px\">Series values: ch\u1ecdn v\u00f9ng <strong>D2:D7<\/strong><\/p>\n<p>Sau khi ho\u00e0n th\u00e0nh ch\u00fang ta c\u00f3 n\u1ed9i dung nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21374\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-edit-data-bieu-do.png\" width=\"615\" height=\"371\" title=\"ket-qua-edit-data-bieu-do\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_deu_do_lon_cua_truc_tung\"><\/span>C\u0103n \u0111\u1ec1u \u0111\u1ed9 l\u1edbn c\u1ee7a tr\u1ee5c tung<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u00ean tr\u1ee5c tung c\u00f3 2 ph\u1ea7n D\u01b0\u01a1ng (&gt;0) v\u00e0 \u00c2m (&lt;0), trong \u0111\u00f3:<\/p>\n<ul>\n<li>Ph\u1ea7n d\u01b0\u01a1ng t\u1eeb o t\u1edbi 250<\/li>\n<li>Ph\u1ea7n \u00e2m t\u1eeb 0 t\u1edbi -150<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady \u0111\u1ed9 l\u1edbn kh\u00f4ng \u0111\u1ed3ng \u0111\u1ec1u. Ch\u00fang ta c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh l\u1ea1i \u0111\u1ed9 l\u1edbn n\u00e0y b\u1eb1ng c\u00e1ch:<\/p>\n<ul>\n<li>B\u1ea5m ch\u1ecdn v\u00e0o ph\u1ea7n s\u1ed1 bi\u1ec3u di\u1ec5n tr\u1ee5c tung tr\u00ean bi\u1ec3u \u0111\u1ed3<\/li>\n<li>B\u1ea5m chu\u1ed9t ph\u1ea3i ch\u1ecdn Format Axis<\/li>\n<li>Trong Axis Options ch\u1ecdn Minimum l\u00e0 -250 \u0111\u1ec3 b\u1eb1ng v\u1edbi Maximum (250)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21375\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/thay-doi-do-rong-truc-tung.png\" width=\"951\" height=\"393\" title=\"thay-doi-do-rong-truc-tung\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Bieu_dien_gia_tri_nam_tai_truc_hoanh_ben_ngoai_pham_vi_bieu_do\"><\/span>Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb n\u0103m t\u1ea1i tr\u1ee5c ho\u00e0nh b\u00ean ngo\u00e0i ph\u1ea1m vi bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c gi\u00e1 tr\u1ecb c\u00e1c n\u0103m tr\u00ean tr\u1ee5c ho\u00e0nh \u0111\u00e8 v\u00e0o bi\u1ec3u \u0111\u1ed3 khi\u1ebfn vi\u1ec7c theo d\u00f5i bi\u1ec3u \u0111\u1ed3 c\u00f3 gi\u00e1 tr\u1ecb \u00e2m b\u1ecb \u1ea3nh h\u01b0\u1edfng r\u1ea5t nhi\u1ec1u. Do \u0111\u00f3 ch\u00fang ta c\u1ea7n \u0111\u01b0a ph\u1ea7n n\u1ed9i dung tr\u1ee5c ho\u00e0nh ra b\u00ean ngo\u00e0i bi\u1ec3u \u0111\u1ed3, c\u1ee5 th\u1ec3 l\u00e0 ph\u00eda d\u01b0\u1edbi c\u1ee7a ph\u1ea1m vi bi\u1ec3u di\u1ec5n c\u1ee7a bi\u1ec3u \u0111\u1ed3. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m ch\u1ecdn gi\u00e1 tr\u1ecb tr\u00ean tr\u1ee5c ho\u00e0nh (s\u1ed1 n\u0103m)<\/li>\n<li>B\u1ea5m chu\u1ed9t ph\u1ea3i ch\u1ecdn <strong>Format Axis<\/strong><\/li>\n<li>Trong m\u1ee5c Format Axis, ch\u1ecdn ph\u1ea7n Labels &gt; <strong>Label Position<\/strong> (v\u1ecb tr\u00ed c\u1ee7a label) ch\u1ecdn<strong> Low<\/strong><\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21376\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bieu-dien-truc-hoanh-ben-duoi-bieu-do.png\" width=\"954\" height=\"390\" title=\"bieu-dien-truc-hoanh-ben-duoi-bieu-do\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Bieu_dien_so_lieu_tren_tung_cot_cua_bieu_do\"><\/span>Bi\u1ec3u di\u1ec5n s\u1ed1 li\u1ec7u tr\u00ean t\u1eebng c\u1ed9t c\u1ee7a bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu ch\u1ec9 nh\u00ecn c\u00e1c c\u1ed9t kh\u00f4ng th\u00f4i th\u00ec r\u1ea5t kh\u00f3 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c \u0111\u1ed9 l\u1edbn c\u1ee7a m\u1ed7i gi\u00e1 tr\u1ecb trong c\u00e1c c\u1ed9t n\u00e0y. Do \u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 th\u00eam d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ed7i c\u1ed9t \u0111\u1ec3 d\u1ec5 d\u00e0ng ph\u00e2n bi\u1ec7t. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m v\u00e0o bi\u1ec3u \u0111\u1ed3 t\u1ea1i v\u1ecb tr\u00ed b\u1ea5t k\u1ef3<\/li>\n<li>Tr\u00ean th\u1ebb <strong>Design<\/strong> c\u1ee7a bi\u1ec3u \u0111\u1ed3, ch\u1ecdn <strong>Add Chart Element &gt; Data Labels &gt; Outside End<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21377\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/them-du-lieu-vao-bieu-do-ben-ngoai-moi-cot.png\" width=\"1066\" height=\"639\" title=\"them-du-lieu-vao-bieu-do-ben-ngoai-moi-cot\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Bieu_dien_duong_Gridline_tren_bieu_do\"><\/span>Bi\u1ec3u di\u1ec5n \u0111\u01b0\u1eddng Gridline tr\u00ean bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u01b0\u1eddng Gridline l\u00e0 \u0111\u01b0\u1eddng d\u00f3ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c tr\u1ee5c. Vi\u1ec7c bi\u1ec3u di\u1ec5n \u0111\u01b0\u1eddng Gridline gi\u00fap ch\u00fang ta l\u00e0m n\u1ed5i b\u1eadt c\u00e1c c\u1ed9t v\u00e0 x\u00e1c \u0111\u1ecbnh t\u01b0\u01a1ng \u1ee9ng gi\u00e1 tr\u1ecb bi\u1ec3u \u0111\u1ed3 theo c\u00e1c tr\u1ee5c t\u1ecda \u0111\u1ed9. Khi tr\u00ecnh b\u00e0y bi\u1ec3u \u0111\u1ed3 th\u00ec b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn (ho\u1eb7c kh\u00f4ng) t\u00f9y theo nhu c\u1ea7u bi\u1ec3u di\u1ec5n.<\/p>\n<p>V\u00ed d\u1ee5 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta s\u1ebd bi\u1ec3u di\u1ec5n \u0111\u01b0\u1eddng Gridline d\u1ea1ng l\u01b0\u1edbi s\u00e1t nhau (c\u1ea3 chi\u1ec1u d\u1ecdc v\u00e0 chi\u1ec1u ngang) nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21378\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/them-gridline-vao-bieu-do.png\" width=\"933\" height=\"602\" title=\"them-gridline-vao-bieu-do\"><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 bi\u1ec3u \u0111\u1ed3 c\u1ee7a ch\u00fang ta \u0111\u00e3 ho\u00e0n th\u00e0nh r\u1ed3i. B\u00e2y gi\u1edd bi\u1ec3u \u0111\u1ed3 c\u1ee7a ch\u00fang ta \u0111\u00e3 tr\u00f4ng \u0111\u1eb9p m\u1eaft v\u00e0 d\u1ec5 nh\u00ecn h\u01a1n r\u1ea5t nhi\u1ec1u r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dinh-dang-bieu-theo-dieu-kien-cho-bieu-do-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n cho bi\u1ec3u \u0111\u1ed3 tr\u00ean Excel<\/a><\/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>\u0110\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3 t\u1ed1t tr\u00ean Excel, b\u1ea1n c\u1ea7n n\u1eafm v\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 v\u1ebd bi\u1ec3u \u0111\u1ed3 tr\u00ean Excel. Ngo\u00e0i ra trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong excel \u0111\u1ec3 t\u00f9y bi\u1ebfn, x\u1eed l\u00fd l\u1ea1i d\u1eef li\u1ec7u tr\u01b0\u1edbc khi v\u1ebd n\u1eefa. Vi\u1ec7c h\u1ecdc v\u1ebd bi\u1ec3u \u0111\u1ed3s\u1ebd gi\u00fap b\u1ea1n n\u00e2ng cao t\u01b0 duy v\u1ec1 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u tr\u00ean excel, n\u00e2ng cao khi\u1ebfu th\u1ea9m m\u1ef9 c\u1ee7a m\u00ecnh n\u1eefa \u0111\u00f3. \u0110\u00e2y l\u00e0 2 y\u1ebfu t\u1ed1 r\u1ea5t quan tr\u1ecdng trong b\u1ea5t k\u1ef3\u00a0c\u00f4ng vi\u1ec7c n\u00e0o c\u00f3 s\u1eed d\u1ee5ng t\u1edbi Excel.<\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c qua kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2vRouT0\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao<\/a> c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-135.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10131,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10130","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\/10130","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=10130"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10130\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10131"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}