{"id":2391,"date":"2024-12-02T07:36:25","date_gmt":"2024-12-02T07:36:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-chi-tiet-cach-ve-bieu-do-duong-thang-trong-excel\/"},"modified":"2024-12-02T07:36:25","modified_gmt":"2024-12-02T07:36:25","slug":"huong-dan-chi-tiet-cach-ve-bieu-do-duong-thang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-chi-tiet-cach-ve-bieu-do-duong-thang-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng th\u1eb3ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng (line) l\u00e0 m\u1ed9t trong nh\u1eefng lo\u1ea1i bi\u1ec3u\u00a0\u0111\u1ed3 kh\u00e1 th\u00f4ng d\u1ee5ng trong\u00a0Excel.\u00a0\u0110\u1eb7c tr\u01b0ng c\u1ee7a lo\u1ea1i bi\u1ec3u\u00a0\u0111\u1ed3 n\u00e0y l\u00e0 gi\u00fap ch\u00fang ta theo d\u00f5i\u00a0\u0111\u01b0\u1ee3c s\u1ef1 bi\u1ebfn\u00a0\u0111\u1ed9ng, xu h\u01b0\u1edbng di\u1ec5n bi\u1ebfn\u00a0c\u1ee7a c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n. Trong b\u00e0i vi\u1ebft n\u00e0y\u00a0<a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> s\u1ebd\u00a0h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng th\u1eb3ng trong Excel. C\u00f9ng t\u00ecm hi\u1ec3u ngay n\u00e0o.<\/em><\/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-674d6378d5153\" 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-chi-tiet-cach-ve-bieu-do-duong-thang-trong-excel.html#Dac_diem_du_lieu_ve_bieu_do_duong_thang\" title=\"\u0110\u1eb7c\u00a0\u0111i\u1ec3m d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng\">\u0110\u1eb7c\u00a0\u0111i\u1ec3m d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng<\/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-chi-tiet-cach-ve-bieu-do-duong-thang-trong-excel.html#Cach_ve_bieu_do_duong_thang_trong_Excel\" title=\"C\u00e1ch v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng trong\u00a0Excel\">C\u00e1ch v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng trong\u00a0Excel<\/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-chi-tiet-cach-ve-bieu-do-duong-thang-trong-excel.html#Cach_ve_nhanh_bieu_do_duong_thang\" title=\"C\u00e1ch v\u1ebd nhanh bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng\">C\u00e1ch v\u1ebd nhanh bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng<\/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-chi-tiet-cach-ve-bieu-do-duong-thang-trong-excel.html#Ve_bieu_do_duong_thang_bang_cach_nap_du_lieu_thu_cong\" title=\"V\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng b\u1eb1ng c\u00e1ch n\u1ea1p d\u1eef li\u1ec7u th\u1ee7 c\u00f4ng\">V\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng b\u1eb1ng c\u00e1ch n\u1ea1p d\u1eef li\u1ec7u th\u1ee7 c\u00f4ng<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-chi-tiet-cach-ve-bieu-do-duong-thang-trong-excel.html#Cach_trang_tri_bieu_do_duong_thang\" title=\"C\u00e1ch trang tr\u00ed bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng\">C\u00e1ch trang tr\u00ed bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dac_diem_du_lieu_ve_bieu_do_duong_thang\"><\/span>\u0110\u1eb7c\u00a0\u0111i\u1ec3m d\u1eef li\u1ec7u v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kh\u00f4ng ph\u1ea3i d\u1eef li\u1ec7u n\u00e0o c\u0169ng v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng. Ch\u00fang ta ch\u1ec9 v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng v\u1edbi c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u sau:<\/p>\n<ul>\n<li>G\u1ed3m nhi\u1ec1u\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng v\u00e0 c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 t\u00ednh li\u00ean t\u1ee5c v\u1ec1 th\u1eddi gian (v\u00ed d\u1ee5 theo c\u00e1c th\u00e1ng trong n\u0103m)<\/li>\n<li>Gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0\u00a0\u0111\u1ed9c l\u1eadp v\u1edbi nhau<\/li>\n<\/ul>\n<p>Nguy\u00ean nh\u00e2n l\u00e0 do:<\/p>\n<ul>\n<li>M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng\u00a0\u0111\u1ec3 theo d\u00f5i xu h\u01b0\u1edbng di\u1ec5n\u00a0bi\u1ebfn, do\u00a0\u0111\u00f3\u00a0\u0111\u00f2i h\u1ecfi qu\u00e1 tr\u00ecnh di\u1ec5n bi\u1ebfn ph\u1ea3i ghi nh\u1eadn li\u00ean t\u1ee5c theo th\u1eddi gian (Kh\u00f4ng\u00a0\u00e1p d\u1ee5ng cho bi\u1ec3u\u00a0\u0111\u1ed3 h\u00ecnh c\u1ed9t)<\/li>\n<li>N\u1ebfu c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 m\u1ed1i quan h\u1ec7\u00a0v\u1edbi nhau th\u01b0\u1eddng ch\u1ec9 d\u00f9ng\u00a0\u0111\u1ec3 bi\u1ec3u di\u1ec5n theo bi\u1ec3u\u00a0\u0111\u1ed3 h\u00ecnh tr\u00f2n (m\u1ed7i gi\u00e1 tr\u1ecb c\u1ee7a 1\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0 m\u1ed9t ph\u1ea7n trong t\u1ed5ng s\u1ed1).<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26757\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bieu-do-column-mau-01.png\" width=\"794\" height=\"333\" title=\"bieu-do-column-mau-01\"><\/p>\n<p style=\"text-align: center\"><em>Bi\u1ec3u\u00a0\u0111\u1ed3 h\u00ecnh c\u1ed9t<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26758\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bieu-do-hinh-tron-mau-01.png\" width=\"782\" height=\"337\" title=\"bieu-do-hinh-tron-mau-01\"><\/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-184.gif\" title=\"ex101_92019-nho-184\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: center\"><em>Bi\u1ec3u\u00a0\u0111\u1ed3 h\u00ecnh tr\u00f2n<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26759\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bieu-do-line-mau-01.png\" width=\"806\" height=\"339\" title=\"bieu-do-line-mau-01\"><\/p>\n<p style=\"text-align: center\"><em>Bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng<\/em><\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y v\u1edbi b\u1ea3ng s\u1ed1 li\u1ec7u tr\u00ean, d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng s\u1ebd gi\u00fap ch\u00fang ta c\u00f3\u00a0\u0111\u01b0\u1ee3c nhi\u1ec1u th\u00f4ng tin nh\u1ea5t, d\u1ec5 xem nh\u1ea5t so v\u1edbi 2 lo\u1ea1i bi\u1ec3u\u00a0\u0111\u1ed3 c\u00f2n l\u1ea1i.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_ve_bieu_do_duong_thang_trong_Excel\"><\/span>C\u00e1ch v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 m\u1ecdi c\u00e1ch<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> kh\u00e1c; \u0111\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng th\u1eb3ng trong Excel, c\u00e1c b\u1ea1n c\u1ea7n c\u00f3 1 b\u1ea3ng d\u1eef li\u1ec7u tr\u01b0\u1edbc.<\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m 2 c\u1ed9t:<\/p>\n<ul>\n<li>C\u00e1c th\u00e1ng trong n\u0103m: g\u1ed3m 12 th\u00e1ng<\/li>\n<li>S\u1ed1 l\u01b0\u1ee3ng theo t\u1eebng th\u00e1ng<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_ve_nhanh_bieu_do_duong_thang\"><\/span>C\u00e1ch v\u1ebd nhanh bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Thao t\u00e1c v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 nh\u01b0 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-1.png\" width=\"1024\" height=\"457\" title=\"cach-ve-bieu-do-line-12-thang-1024x457-1\"><\/p>\n<p style=\"padding-left: 30px\">S\u1ed1 1 \u2013\u00a0Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n v\u1ebd<\/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<p>Tuy nhi\u00ean kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o vi\u1ec7c v\u1ebd nhanh c\u0169ng\u00a0\u0111\u00fang nh\u01b0\u00a0\u00fd mu\u1ed1n. B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1ch v\u1ebd ch\u00ednh x\u00e1c h\u01a1n nh\u01b0 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ve_bieu_do_duong_thang_bang_cach_nap_du_lieu_thu_cong\"><\/span>V\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng b\u1eb1ng c\u00e1ch n\u1ea1p d\u1eef li\u1ec7u th\u1ee7 c\u00f4ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ea7u ti\u00ean ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n t\u1eeb b\u01b0\u1edbc s\u1ed1 2 trong h\u00ecnh tr\u00ean, t\u1ee9c l\u00e0 kh\u00f4ng ch\u1ecdn b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u n\u00e0o (b\u1ecf qua b\u01b0\u1edbc 1), ch\u1ecdn 1\u00a0\u00f4 tr\u1ed1ng b\u00ean ngo\u00e0i b\u1ea3ng d\u1eef li\u1ec7u, sau\u00a0\u0111\u00f3 th\u1ef1c hi\u1ec7n v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 Line. K\u1ebft qu\u1ea3 l\u00e0 1 khung h\u00ecnh\u00a0tr\u1ed1ng.<\/p>\n<p>Ti\u1ebfp theo ch\u00fang ta n\u1ea1p d\u1eef li\u1ec7u cho bi\u1ec3u\u00a0\u0111\u1ed3 th\u00f4ng qua ch\u1ee9c n\u0103ng Select Data<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26763\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-data-bieu-do-line.png\" width=\"800\" height=\"448\" title=\"select-data-bieu-do-line\"><\/p>\n<p>Trong c\u1eeda s\u1ed5 Select Data, ch\u00fang ta n\u1ea1p d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26764\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nap-du-lieu-vao-bieu-do.png\" width=\"800\" height=\"359\" title=\"nap-du-lieu-vao-bieu-do\"><\/p>\n<p>Ph\u1ea7n Legend Entries (series) l\u00e0 n\u1ed9i dung s\u1ebd hi\u1ec3n th\u1ecb tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3.<\/p>\n<p>Ph\u1ea7n Horizontal (category)\u00a0Axis Labels l\u00e0 n\u1ed9i dung s\u1ebd hi\u1ec3n th\u1ecb b\u00ean d\u01b0\u1edbi tr\u1ee5c ho\u00e0nh c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3 (tr\u1ee5c n\u1eb1m ngang)<\/p>\n<p>=&gt; B\u1ea5m Add v\u00e0 th\u00eam ph\u1ea7n S\u1ed1 l\u01b0\u1ee3ng v\u00e0o Legend Entries<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26766\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nap-du-lieu-vao-legend-entries.png\" width=\"778\" height=\"465\" title=\"nap-du-lieu-vao-legend-entries\"><\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26768\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-select-data-bieu-do.png\" width=\"713\" height=\"404\" title=\"ket-qua-select-data-bieu-do\"><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 v\u1ebd\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u\u00a0\u0111\u1ed3 theo\u00a0\u0111\u00fang\u00a0\u00fd mu\u1ed1n r\u1ed3i.<\/p>\n<p>N\u1ebfu s\u1eed d\u1ee5ng c\u00e1ch v\u1ebd nhanh m\u00e0 ra k\u1ebft qu\u1ea3 ch\u01b0a\u00a0\u0111\u00fang\u00a0\u00fd mu\u1ed1n, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 v\u00e0o m\u1ee5c Select data\u00a0\u0111\u1ec3\u00a0\u0111i\u1ec1u ch\u1ec9nh l\u1ea1i d\u1eef li\u1ec7u trong bi\u1ec3u\u00a0\u0111\u1ed3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_trang_tri_bieu_do_duong_thang\"><\/span>C\u00e1ch trang tr\u00ed bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1eddng th\u1eb3ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kh\u00f4ng ph\u1ea3i ngay l\u1eadp t\u1ee9c bi\u1ec3u\u00a0\u0111\u1ed3 s\u1ebd\u00a0\u0111\u1eb9p v\u00e0\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 c\u00e1c n\u1ed9i dung. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u1ea7n bi\u1ebft th\u00eam m\u1ed9t s\u1ed1 thao t\u00e1c v\u1ec1 trang tr\u00ed, tr\u00ecnh b\u00e0y bi\u1ec3u\u00a0\u0111\u1ed3 nh\u01b0 sau:<\/p>\n<p>Ch\u1ecdn bi\u1ec3u\u00a0\u0111\u1ed3, sau\u00a0\u0111\u00f3 ch\u1ecdn m\u1ee5c <strong>Add Chart Element<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26771\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-chart-element-trang-tri-bieu-do.png\" width=\"785\" height=\"506\" title=\"add-chart-element-trang-tri-bieu-do\"><\/p>\n<p>C\u00e1c n\u1ed9i dung trong Chart Element bao g\u1ed3m:<\/p>\n<ul>\n<li><strong>Axes<\/strong>: Chia t\u1ef7 l\u1ec7 tr\u00ean c\u00e1c tr\u1ee5c t\u1ecda\u00a0\u0111\u1ed9<\/li>\n<li><strong>Axis Titles<\/strong>: T\u00ean ti\u00eau\u00a0\u0111\u1ec1 c\u1ee7a t\u1eebng ph\u1ea7n tr\u00ean m\u1ed7i tr\u1ee5c t\u1ecda\u00a0\u0111\u1ed9<\/li>\n<li><strong>Chart Title<\/strong>: T\u00ean bi\u1ec3u\u00a0\u0111\u1ed3<\/li>\n<li><strong>Data Labels<\/strong>: Nh\u00e3n s\u1ed1 li\u1ec7u tr\u00ean c\u00e1c n\u1ed9i dung bi\u1ec3u\u00a0\u0111\u1ed3<\/li>\n<li><strong>Data Table<\/strong>: D\u1eef li\u1ec7u c\u1ee7a c\u00e1c n\u1ed9i dung bi\u1ec3u\u00a0\u0111\u1ed3 th\u1ec3 hi\u1ec7n d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng<\/li>\n<li><strong>Error Bar<\/strong>: Thanh hi\u1ec3n th\u1ecb l\u1ed7i\/\u0111\u1ed9 l\u1ec7ch c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3<\/li>\n<li><strong>Gridlines<\/strong>:\u00a0\u0111\u01b0\u1eddng k\u1ebb m\u1edd l\u00e0m n\u1ec1n trong bi\u1ec3u\u00a0\u0111\u1ed3<\/li>\n<li><strong>Legend<\/strong>: Ghi ch\u00fa cho c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng th\u1ec3 hi\u1ec7n trong bi\u1ec3u\u00a0\u0111\u1ed3<\/li>\n<li><strong>Lines<\/strong>:\u00a0\u0110\u01b0\u1eddng k\u1ebb d\u00f3ng xu\u1ed1ng tr\u1ee5c ho\u00e0nh (ch\u1ec9\u00a0\u00e1p d\u1ee5ng cho bi\u1ec3u\u00a0\u0111\u1ed3 d\u1ea1ng Line)<\/li>\n<li><strong>Trendline<\/strong>:\u00a0\u0110\u01b0\u1eddng xu h\u01b0\u1edbng c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 mu\u1ed1n th\u00eam s\u1ed1 li\u1ec7u v\u00e0o m\u1ed7i\u00a0\u0111i\u1ec3m trong\u00a0\u0111o\u1ea1n Line c\u1ee7a t\u1eebng th\u00e1ng, ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<p>Add Chart Element &gt; Data Labels &gt; Above (s\u1ed1\u00a0li\u1ec7u\u00a0\u1edf ph\u00eda tr\u00ean m\u1ed7i\u00a0\u0111i\u1ec3m)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26774\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-data-label.png\" width=\"782\" height=\"524\" title=\"add-data-label\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o 1 m\u1eabu bi\u1ec3u\u00a0\u0111\u1ed3 ho\u00e0n thi\u1ec7n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26776\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-bieu-do-line.png\" width=\"775\" height=\"324\" title=\"ket-qua-bieu-do-line\"><\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Chart Style l\u00e0 <strong>Style 15<\/strong> (Ch\u1ecdn 1 phong c\u00e1ch th\u1ec3 hi\u1ec7n bi\u1ec3u\u00a0\u0111\u1ed3 trong Chart Style)<\/li>\n<li>C\u00f3 Data Labels l\u00e0 Above<\/li>\n<li>C\u00f3 Lines l\u00e0 DropLines (\u0111\u01b0\u1eddng k\u1ebb d\u00f3ng xu\u1ed1ng c\u00e1c\u00a0\u0111i\u1ec3m tr\u00ean tr\u1ee5c ho\u00e0nh)<\/li>\n<li>\u0110\u1ed5i t\u00ean bi\u1ec3u\u00a0\u0111\u1ed3<\/li>\n<\/ul>\n<p>Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u00e1p d\u1ee5ng nh\u1eefng ki\u1ebfn th\u1ee9c tr\u00ean v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n<p><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-184.gif\" title=\"ex101_92019-nho-184\"><br \/>\n<\/a><\/p>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft kh\u00e1c li\u00ean quan t\u1edbi v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel 2010 2013 2016<\/a><\/p>\n<p style=\"padding-left: 30px\"><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 style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dieu-khien-bieu-do-tu-dong-thay-doi-theo-nut-tuy-chon-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111i\u1ec1u khi\u1ec3n bi\u1ec3u \u0111\u1ed3 t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i theo n\u00fat t\u00f9y ch\u1ecdn tr\u00ean Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tao-mot-bieu-trong-excel-tu-hai-hoac-nhieu-trang-khac-nhau.html\">T\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 trong Excel t\u1eeb hai ho\u1eb7c nhi\u1ec1u trang kh\u00e1c nhau<\/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-184.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2392,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2391","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\/2391","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=2391"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2392"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}