{"id":8773,"date":"2024-12-29T05:30:15","date_gmt":"2024-12-29T05:30:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-cach-ve-bieu-do-duong-thang-tu-dong-danh-dau-diem-lon-nhat-nho-nhat\/"},"modified":"2024-12-29T05:30:15","modified_gmt":"2024-12-29T05:30:15","slug":"huong-dan-cach-ve-bieu-do-duong-thang-tu-dong-danh-dau-diem-lon-nhat-nho-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-cach-ve-bieu-do-duong-thang-tu-dong-danh-dau-diem-lon-nhat-nho-nhat\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng th\u1eb3ng t\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh d\u1ea5u \u0111i\u1ec3m l\u1edbn nh\u1ea5t nh\u1ecf nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng (line) l\u00e0 m\u1ed9t trong nh\u1eefng lo\u1ea1i bi\u1ec3u \u0111\u1ed3 kh\u00e1 th\u00f4ng d\u1ee5ng trong Excel. \u0110\u1eb7c tr\u01b0ng c\u1ee7a lo\u1ea1i bi\u1ec3u \u0111\u1ed3 n\u00e0y l\u00e0 gi\u00fap ch\u00fang ta theo d\u00f5i \u0111\u01b0\u1ee3c s\u1ef1 bi\u1ebfn \u0111\u1ed9ng, xu h\u01b0\u1edbng di\u1ec5n bi\u1ebfn c\u1ee7a c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n. Trong \u0111\u00f3 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t (\u0111\u1ec9nh) v\u00e0 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t (\u0111\u00e1y) l\u00e0 hai ti\u00eau ch\u00ed quan tr\u1ecdng c\u1ee7a bi\u1ec3u \u0111\u1ed3. Trong b\u00e0i vi\u1ebft n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> c\u00f9ng b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng th\u1eb3ng t\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh d\u1ea5u \u0111i\u1ec3m l\u1edbn nh\u1ea5t nh\u1ecf nh\u1ea5t.<\/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-6770de6636ba2\" 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-duong-thang-tu-dong-danh-dau-diem-lon-nhat-nho-nhat.html#Cach_ve_bieu_do_duong_trong_Excel\" title=\"C\u00e1ch v\u1ebd\u00a0bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng trong\u00a0Excel\">C\u00e1ch v\u1ebd\u00a0bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng trong\u00a0Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-duong-thang-tu-dong-danh-dau-diem-lon-nhat-nho-nhat.html#Cach_tu_dong_danh_dau_diem_lon_nhat_nho_nhat_trong_bieu_do_duong\" title=\"C\u00e1ch t\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh d\u1ea5u\u00a0\u0111i\u1ec3m\u00a0l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t trong bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng\">C\u00e1ch t\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh d\u1ea5u\u00a0\u0111i\u1ec3m\u00a0l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t trong bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-duong-thang-tu-dong-danh-dau-diem-lon-nhat-nho-nhat.html#Buoc_1_%E2%80%93_Xac_dinh_gi_tri_lon_nhat_nho_nhat_trong_bang_du_lieu\" title=\"B\u01b0\u1edbc 1 \u2013 X\u00e1c\u00a0\u0111\u1ecbnh g\u00ed tr\u1ecb l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t trong b\u1ea3ng d\u1eef li\u1ec7u\">B\u01b0\u1edbc 1 \u2013 X\u00e1c\u00a0\u0111\u1ecbnh g\u00ed tr\u1ecb l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t trong b\u1ea3ng d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-duong-thang-tu-dong-danh-dau-diem-lon-nhat-nho-nhat.html#Buoc_2_%E2%80%93_Them_du_lieu_vao_bieu_do\" title=\"B\u01b0\u1edbc 2 \u2013 Th\u00eam d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3\">B\u01b0\u1edbc 2 \u2013 Th\u00eam d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-duong-thang-tu-dong-danh-dau-diem-lon-nhat-nho-nhat.html#Buoc_3_%E2%80%93_Lam_ro_cac_diem_Min_Max_trong_bieu_do\" title=\"B\u01b0\u1edbc 3 \u2013 L\u00e0m r\u00f5 c\u00e1c\u00a0\u0111i\u1ec3m Min, Max trong bi\u1ec3u\u00a0\u0111\u1ed3\">B\u01b0\u1edbc 3 \u2013 L\u00e0m r\u00f5 c\u00e1c\u00a0\u0111i\u1ec3m Min, Max trong bi\u1ec3u\u00a0\u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-duong-thang-tu-dong-danh-dau-diem-lon-nhat-nho-nhat.html#Buoc_4_%E2%80%93_Thay_doi_che_do_hien_thi_so_tren_moi_diem_trong_bieu_do\" title=\"B\u01b0\u1edbc 4 \u2013\u00a0Thay\u00a0\u0111\u1ed5i ch\u1ebf\u00a0\u0111\u1ed9 hi\u1ec3n th\u1ecb s\u1ed1 tr\u00ean m\u1ed7i \u0111i\u1ec3m trong bi\u1ec3u\u00a0\u0111\u1ed3\">B\u01b0\u1edbc 4 \u2013\u00a0Thay\u00a0\u0111\u1ed5i ch\u1ebf\u00a0\u0111\u1ed9 hi\u1ec3n th\u1ecb s\u1ed1 tr\u00ean m\u1ed7i \u0111i\u1ec3m trong bi\u1ec3u\u00a0\u0111\u1ed3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_ve_bieu_do_duong_trong_Excel\"><\/span>C\u00e1ch v\u1ebd\u00a0bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ea7u ti\u00ean b\u1ea1n ph\u1ea3i ch\u1ecdn m\u1ee5c <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016.html\"><strong>v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/strong><\/a> tr\u01b0\u1edbc. \u0110\u1ec3 c\u00f3 th\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3 d\u1ea1ng \u0111\u01b0\u1eddng th\u1eb3ng (line) trong Excel, ch\u00fang ta c\u00f9ng theo d\u00f5i v\u1edbi v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26729\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-ve-bieu-do-line-12-thang-1024x457-2.png\" width=\"1024\" height=\"457\" title=\"cach-ve-bieu-do-line-12-thang-1024x457-2\"><\/p>\n<p style=\"padding-left: 30px\">S\u1ed1 1 \u2013 B\u1eaft\u00a0\u0111\u1ea7u v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m 2 c\u1ed9t: Th\u00e1ng v\u00e0 S\u1ed1 l\u01b0\u1ee3ng theo t\u1eebng th\u00e1ng<\/p>\n<p style=\"padding-left: 30px\">S\u1ed1 2 \u2013\u00a0\u0110\u1ec3 v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3, ch\u1ecdn th\u1ebb\u00a0Insert &gt; Ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng nh\u00f3m bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng (Line)<\/p>\n<p style=\"padding-left: 30px\">S\u1ed1 3 \u2013 Ch\u1ecdn 1 d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3 theo\u00a0\u00fd mu\u1ed1n trong c\u00e1c d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng<\/p>\n<p style=\"padding-left: 30px\">S\u1ed1 4 \u2013 K\u1ebft qu\u1ea3 c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3 sau khi\u00a0\u0111\u01b0\u1ee3c v\u1ebd<\/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\/2024\/12\/ex101_92019-nho-819.gif\" title=\"ex101_92019-nho-819\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"padding-left: 30px\">(Xem th\u00eam b\u00e0i:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-chi-tiet-cach-ve-bieu-do-duong-thang-trong-excel.html\">H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng th\u1eb3ng trong Excel<\/a>)<\/p>\n<p>Tuy nhi\u00ean trong bi\u1ec3u\u00a0\u0111\u1ed3 n\u00e0y, ch\u00fang ta th\u1ea5y ph\u1ea7n s\u1ed1 li\u1ec7u hi\u1ec3n th\u1ecb tr\u00ean t\u1eebng\u00a0\u0111i\u1ec3m c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3 lu\u00f4n hi\u1ec3n th\u1ecb h\u1ebft\u1ea5t c\u1ea3 c\u00e1c n\u1ed9i dung. C\u00f3 c\u00e1ch n\u00e0o\u00a0\u0111\u1ec3 ch\u1ec9 hi\u1ec3n th\u1ecb \u0111i\u1ec3m c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 \u0111i\u1ec3m c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t? Gi\u1ed1ng nh\u01b0 k\u1ebft qu\u1ea3 bi\u1ec3u\u00a0\u0111\u1ed3 d\u01b0\u1edbi\u00a0\u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26795\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-highlight-max-min-bieu-do-line.png\" width=\"599\" height=\"302\" title=\"ket-qua-highlight-max-min-bieu-do-line\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tu_dong_danh_dau_diem_lon_nhat_nho_nhat_trong_bieu_do_duong\"><\/span>C\u00e1ch t\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh d\u1ea5u\u00a0\u0111i\u1ec3m\u00a0l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t trong bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_%E2%80%93_Xac_dinh_gi_tri_lon_nhat_nho_nhat_trong_bang_du_lieu\"><\/span>B\u01b0\u1edbc 1 \u2013 X\u00e1c\u00a0\u0111\u1ecbnh g\u00ed tr\u1ecb l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t trong b\u1ea3ng d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong b\u1ea3ng d\u1eef li\u1ec7u ban\u00a0\u0111\u1ea7u, ch\u00fang ta t\u1ea1o th\u00eam 2 c\u1ed9t:<\/p>\n<ul>\n<li>C\u1ed9t C \u2013 MAX: t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t<\/li>\n<li>C\u1ed9t D \u2013 MIN: T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t<\/li>\n<\/ul>\n<p><strong>T\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t<\/strong><\/p>\n<p>S\u1eed d\u1ee5ng h\u00e0m\u00a0IF\u00a0\u0111\u1ec3 so s\u00e1nh t\u1eebng gi\u00e1 tr\u1ecb trong c\u1ed9t B v\u1edbi gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong c\u1ea3 c\u1ed9t B:<\/p>\n<p style=\"padding-left: 30px\">C2 =IF(B2=MAX($B$2:$B$13), B2, NA())<\/p>\n<ul>\n<li>N\u1ebfu\u00a0\u0111\u00fang, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c so s\u00e1nh<\/li>\n<li>N\u1ebfu sai, tr\u1ea3 v\u1ec1 l\u1ed7i NA (m\u1ee5c\u00a0\u0111\u00edch\u00a0\u0111\u1ec3 tr\u00e1nh l\u1ed7i bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng ch\u1ea1y v\u1ec1 0)<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">Tham kh\u1ea3o:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-khac-phuc-loi-chay-ve-0-khi-ve-bieu-do-dang-duong-thang-trong-excel.html\">C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i ch\u1ea1y v\u1ec1 0 khi v\u1ebd bi\u1ec3u \u0111\u1ed3 d\u1ea1ng \u0111\u01b0\u1eddng th\u1eb3ng trong Excel<\/a><\/p>\n<p><strong>T\u00ecm gi\u00e1 tr\u1ecb\u00a0nh\u1ecf\u00a0nh\u1ea5t<\/strong><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean, ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t t\u1ea1i c\u1ed9t D nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">D2 =IF(B2=MIN($B$2:$B$13), B2, NA())<\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26798\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tim-gia-tri-lon-nhat-nho-nhat.png\" width=\"354\" height=\"328\" title=\"tim-gia-tri-lon-nhat-nho-nhat\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2_%E2%80%93_Them_du_lieu_vao_bieu_do\"><\/span>B\u01b0\u1edbc 2 \u2013 Th\u00eam d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u00e3 c\u00f3, b\u1ea5m ch\u1ecdn Select Data cho bi\u1ec3u\u00a0\u0111\u1ed3 v\u00e0 Add th\u00eam 2 c\u1ed9t v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26799\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-data-to-chart-1024x387-1.png\" width=\"800\" height=\"302\" title=\"add-data-to-chart-1024x387-1\"><\/p>\n<p>Sau khi th\u00eam d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3, ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26800\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/diem-min-max-trong-bieu-do.png\" width=\"932\" height=\"339\" title=\"diem-min-max-trong-bieu-do\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_3_%E2%80%93_Lam_ro_cac_diem_Min_Max_trong_bieu_do\"><\/span>B\u01b0\u1edbc 3 \u2013 L\u00e0m r\u00f5 c\u00e1c\u00a0\u0111i\u1ec3m Min, Max trong bi\u1ec3u\u00a0\u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong h\u00ecnh tr\u00ean, ch\u00fang ta th\u1ea5y c\u00e1c\u00a0\u0111i\u1ec3m l\u1edbn nh\u1ea5t (Max), nh\u1ecf nh\u1ea5t (Min) kh\u00e1 nh\u1ecf v\u00e0 kh\u00f4ng c\u00f3 nhi\u1ec1u kh\u00e1c bi\u1ec7t so v\u1edbi c\u00e1c\u00a0\u0111i\u1ec3m c\u00f2n l\u1ea1i ph\u1ea3i kh\u00f4ng?\u00a0\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c\u00a0\u0111i\u1ec3m n\u00e0y, ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<p>B\u1ea5m ch\u1ecdn\u00a0\u0111i\u1ec3m mu\u1ed1n bi\u1ec3u di\u1ec5n (v\u00ed d\u1ee5\u00a0\u0111i\u1ec3m Max), b\u1ea5m chu\u1ed9t ph\u1ea3i ch\u1ecdn Format Data\u00a0Point (ho\u1eb7c n\u1ed9i dung c\u00f3 t\u00ean Format Data\u2026)<\/p>\n<p>Trong c\u1eeda s\u1ed5 Format Data Point, ch\u00fang ta ch\u1ecdn h\u00ecnh bi\u1ec3u di\u1ec5n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26801\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-data-point-setting-01.png\" width=\"928\" height=\"427\" title=\"format-data-point-setting-01\"><\/p>\n<p>S\u1ed1 1 \u2013 Ch\u1ecdn m\u1ee5c Fill &amp; Line<\/p>\n<p>S\u1ed1 2 \u2013 Ch\u1ecdn th\u1ebb Marker<\/p>\n<p>S\u1ed1 3 \u2013 Trong Marker Options ch\u1ecdn Built-in<\/p>\n<ul>\n<li>Ch\u1ecdn Type theo bi\u1ec3u t\u01b0\u1ee3ng ph\u00f9 h\u1ee3p<\/li>\n<li>Ch\u1ecdn Size\u00a0\u0111\u1ec3 t\u0103ng k\u00edch c\u1ee1 c\u1ee7a bi\u1ec3u t\u01b0\u1ee3ng (th\u01b0\u1eddng ch\u1ecdn =10)<\/li>\n<\/ul>\n<p>Ti\u1ebfp theo c\u00e1c n\u1ed9i dung b\u00ean d\u01b0\u1edbi c\u00f3 th\u1ec3 ch\u1ecdn nh\u01b0 sau:<\/p>\n<p><strong>Fill<\/strong>: No Fill (kh\u00f4ng c\u00f3 m\u00e0u n\u1ec1n b\u00ean trong bi\u1ec3u t\u01b0\u1ee3ng, ch\u1ec9 d\u00f9ng\u00a0\u0111\u01b0\u1eddng vi\u1ec1n xung quanh bi\u1ec3u t\u01b0\u1ee3ng)<\/p>\n<p><strong>Border<\/strong>: C\u00f3 th\u1ec3 ch\u1ecdn<\/p>\n<ul>\n<li>Color: m\u00e0u cho\u00a0\u0111\u01b0\u1eddng vi\u1ec1n<\/li>\n<li>Width:\u00a0\u0111\u1ed9 d\u00e0y\u00a0\u0111\u01b0\u1eddng vi\u1ec1n (th\u01b0\u1eddng ch\u1ecdn = 1 pt)<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 ta c\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26802\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-bieu-tuong-highlight-max-min-bieu-do-line.png\" width=\"555\" height=\"302\" title=\"tao-bieu-tuong-highlight-max-min-bieu-do-line\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_4_%E2%80%93_Thay_doi_che_do_hien_thi_so_tren_moi_diem_trong_bieu_do\"><\/span>B\u01b0\u1edbc 4 \u2013\u00a0Thay\u00a0\u0111\u1ed5i ch\u1ebf\u00a0\u0111\u1ed9 hi\u1ec3n th\u1ecb s\u1ed1 tr\u00ean m\u1ed7i \u0111i\u1ec3m trong bi\u1ec3u\u00a0\u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 th\u1ec3 th\u1ea5y vi\u1ec7c hi\u1ec3n th\u1ecb s\u1ed1 tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3 kh\u00e1 r\u1ed1i v\u00ec c\u00f3 qu\u00e1 nhi\u1ec1u s\u1ed1,\u00a0\u0111i\u1ec3m tr\u00f9ng nhau (t\u1ea1i v\u1ecb tr\u00ed min-max c\u00f3 s\u1ed1\u00a0\u0111\u00e8 l\u00ean nhau).<\/p>\n<p>\u0110\u1ec3 l\u00e0m\u00a0\u0111\u01a1n gi\u1ea3n cho bi\u1ec3u\u00a0\u0111\u1ed3, ch\u00fang ta c\u00f3 th\u1ec3:<\/p>\n<ul>\n<li>X\u00f3a ph\u1ea7n s\u1ed1 trong c\u00e1c\u00a0\u0111i\u1ec3m b\u00ecnh th\u01b0\u1eddng: b\u1ea5m ch\u1ecdn 1 s\u1ed1 c\u1ee7a 1 th\u00e1ng b\u1ea5t k\u1ef3, sau\u00a0\u0111\u00f3 nh\u1ea5n ph\u00edm Delete)<\/li>\n<li>V\u1ecb tr\u00ed Max: Thi\u1ebft l\u1eadp Data Labels l\u00e0 Above: b\u1ea5m ch\u1ecdn\u00a0\u0111i\u1ec3m Max r\u1ed3i ch\u1ecdn Add Chart Element &gt; Data Labels &gt; Above)<\/li>\n<li>V\u1ecb tr\u00ed Min: Thi\u1ebft l\u1eadp Data Labels l\u00e0 Below: b\u1ea5m ch\u1ecdn\u00a0\u0111i\u1ec3m Min r\u1ed3i ch\u1ecdn Add Chart Element &gt; Data Labels &gt; Below)<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26803\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-bieu-tuong-highlight-max-min-bieu-do-line-data-labels.png\" width=\"555\" height=\"303\" title=\"tao-bieu-tuong-highlight-max-min-bieu-do-line-data-labels\"><\/p>\n<p>Cu\u1ed1i c\u00f9ng ch\u00fang ta ch\u1ec9 c\u1ea7n trang tr\u00ed, tr\u00ecnh b\u00e0y th\u00eam m\u1ed9t s\u1ed1 n\u1ed9i dung\u00a0\u0111\u1ec3 l\u00e0m\u00a0\u0111\u1eb9p cho bi\u1ec3u\u00a0\u0111\u1ed3 nh\u01b0:<\/p>\n<ul>\n<li>Th\u00eam Chart Title (t\u00ean bi\u1ec3u\u00a0\u0111\u1ed3),<\/li>\n<li>\u0110i\u1ec1u ch\u1ec9nh Gridline (\u0111\u01b0\u1eddng k\u1ebb m\u1edd b\u00ean trong bi\u1ec3u\u00a0\u0111\u1ed3),<\/li>\n<li>Th\u00eam Lines (\u0111\u01b0\u1eddng d\u00f3ng c\u00e1c\u00a0\u0111i\u1ec3m xu\u1ed1ng tr\u1ee5c ho\u00e0nh theo t\u1eebng th\u00e1ng)\u2026<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 ho\u00e0n th\u00e0nh\u00a0\u0111\u01b0\u1ee3c 1 bi\u1ec3u\u00a0\u0111\u1ed3 kh\u00e1\u00a0\u0111\u1eb9p m\u1eaft v\u00e0 c\u00f3 th\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng thay\u00a0\u0111\u1ed5i c\u00e1c\u00a0\u0111i\u1ec3m l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t, gi\u00fap vi\u1ec7c\u00a0\u0111\u1ecdc v\u00e0 ph\u00e2n t\u00edch bi\u1ec3u\u00a0\u0111\u1ed3 tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26804\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/highlight-min-max-line-chart.gif\" width=\"918\" height=\"325\" title=\"highlight-min-max-line-chart\"><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u00e1p d\u1ee5ng t\u1ed1t ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o trong c\u00f4ng vi\u1ec7c.<\/p>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft th\u00fa v\u1ecb kh\u00e1c v\u1ec1 bi\u1ec3u\u00a0\u0111\u1ed3 trong\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-quan-ly-du-an-trong-excel-chi-tiet-nhat.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 qu\u1ea3n l\u00fd d\u1ef1 \u00e1n trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-ke-hoach-thuc-te-dang-cot-long-nhau-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 k\u1ebf ho\u1ea1ch th\u1ef1c t\u1ebf d\u1ea1ng c\u1ed9t l\u1ed3ng nhau tr\u00ean Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bang-so-sanh-ke-hoach-voi-thuc-hien-du-an-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u1ea3ng so s\u00e1nh k\u1ebf ho\u1ea1ch v\u1edbi th\u1ef1c hi\u1ec7n d\u1ef1 \u00e1n trong Excel<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-819.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8774,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8773","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\/8773","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=8773"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8773\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8774"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}