{"id":5948,"date":"2024-12-21T11:24:15","date_gmt":"2024-12-21T11:24:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016\/"},"modified":"2024-12-21T11:24:15","modified_gmt":"2024-12-21T11:24:15","slug":"huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel 2010 2013 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Bi\u1ec3u\u00a0\u0111\u1ed3 l\u00e0 m\u1ed9t\u00a0trong nh\u1eefng th\u00e0nh ph\u1ea7n kh\u00f4ng th\u1ec3 thi\u1ebfu trong c\u00e1c b\u00e1o c\u00e1o. Khi nh\u00ecn c\u00e1c s\u1ed1 li\u1ec7u\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3 ch\u00fang ta th\u1ea5y tr\u1ef1c quan v\u00e0 d\u1ec5 hi\u1ec3u h\u01a1n nhi\u1ec1u so v\u1edbi nh\u00ecn v\u00e0o c\u00e1c con s\u1ed1 trong b\u1ea3ng b\u00e1o c\u00e1o. V\u1eady <strong>c\u00e1ch v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 trong\u00a0Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng<strong> <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc\u00a0Excel Online<\/a><\/strong> t\u00ecm hi\u1ec3u ch\u1ee7\u00a0\u0111\u1ec1 n\u00e0y nh\u00e9.<\/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-6766a55f103c0\" 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-trong-excel-2010-2013-2016.html#Cac_tieu_chuan_ve_du_lieu_cho_bieu_do\" title=\"C\u00e1c ti\u00eau chu\u1ea9n v\u1ec1 d\u1eef li\u1ec7u cho bi\u1ec3u\u00a0\u0111\u1ed3\">C\u00e1c ti\u00eau chu\u1ea9n v\u1ec1 d\u1eef li\u1ec7u cho bi\u1ec3u\u00a0\u0111\u1ed3<\/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-trong-excel-2010-2013-2016.html#Cac_buoc_ve_bieu_do_trong_Excel\" title=\"C\u00e1c b\u01b0\u1edbc v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 trong\u00a0Excel\">C\u00e1c b\u01b0\u1edbc v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 trong\u00a0Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016.html#Cach_thay_doi_du_lieu_nap_vao_bieu_do\" title=\"C\u00e1ch thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u n\u1ea1p v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3\">C\u00e1ch thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u n\u1ea1p v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016.html#Cach_trang_tri_bieu_do_dep_mat\" title=\"C\u00e1ch trang tr\u00ed bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u1eb9p m\u1eaft\">C\u00e1ch trang tr\u00ed bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u1eb9p m\u1eaft<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cac_tieu_chuan_ve_du_lieu_cho_bieu_do\"><\/span>C\u00e1c ti\u00eau chu\u1ea9n v\u1ec1 d\u1eef li\u1ec7u cho bi\u1ec3u\u00a0\u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t trong nh\u1eefng quan ni\u1ec7m sai l\u1ea7m hay g\u1eb7p ph\u1ea3i khi mu\u1ed1n <strong>v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 tr\u00ean\u00a0Excel\u00a0<\/strong>\u0111\u00f3 l\u00e0: B\u1ea5t k\u1ef3 d\u1eef li\u1ec7u n\u00e0o c\u0169ng v\u1ebd th\u00e0nh bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>\u0110i\u1ec1u n\u00e0y g\u00e2y ra c\u00e1c l\u1ed7i r\u1ea5t kh\u00f3 ch\u1eefa,\u00a0\u0111\u00f3 l\u00e0:<\/p>\n<ul>\n<li>Kh\u00f4ng\u00a0bi\u1ebft ch\u1ecdn lo\u1ea1i bi\u1ec3u\u00a0\u0111\u1ed3 n\u00e0o.<\/li>\n<li>D\u1eef li\u1ec7u bi\u1ec3u di\u1ec5n kh\u00f4ng\u00a0\u0111\u00fang tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3.<\/li>\n<li>Thi\u1ebfu ho\u1eb7c th\u1eeba n\u1ed9i dung c\u1ea7n bi\u1ec3u di\u1ec5n.<\/li>\n<li>Bi\u1ec3u\u00a0\u0111\u1ed3 sai m\u00e0 kh\u00f4ng bi\u1ebft nguy\u00ean nh\u00e2n, kh\u00f4ng bi\u1ebft s\u1eeda th\u1ebf n\u00e0o cho\u00a0\u0111\u00fang.<\/li>\n<\/ul>\n<p>\u0110\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao ch\u00fang ta c\u1ea7n ph\u1ea3i bi\u1ebft v\u1ec1 c\u00e1c ti\u00eau chu\u1ea9n v\u1ec1 d\u1eef li\u1ec7u cho bi\u1ec3u\u00a0\u0111\u1ed3. Khi tu\u00e2n th\u1ee7 c\u00e1c ti\u00eau chu\u1ea9n n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 t\u1ef1 tin v\u1ebd\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u00fang.\u00a0\u0110\u00f3 l\u00e0:<\/p>\n<p><strong>Ti\u00eau chu\u1ea9n 1: D\u1eef li\u1ec7u\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p l\u1ea1i, kh\u00f4ng ph\u1ea3i d\u1eef li\u1ec7u chi ti\u1ebft.\u00a0<\/strong><\/p>\n<p>D\u1eef li\u1ec7u chi ti\u1ebft t\u1ee9c l\u00e0\u00a0c\u00f9ng 1\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng nh\u01b0ng xu\u1ea5t hi\u1ec7n nhi\u1ec1u l\u1ea7n, tr\u00ean nhi\u1ec1u d\u00f2ng, m\u1ed7i d\u00f2ng th\u1ec3 hi\u1ec7n 1 n\u1ed9i dung chi ti\u1ebft.<\/p>\n<p>Khi\u00a0\u0111\u00f3 tr\u00ean b\u1ea3ng d\u1eef li\u1ec7u, ch\u00fang ta th\u1ea5y c\u00f3 r\u1ea5t nhi\u1ec1u d\u00f2ng. M\u1ed7i\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng l\u1ea1i xu\u1ea5t hi\u1ec7n nhi\u1ec1u l\u1ea7n. Do\u00a0\u0111\u00f3 n\u1ebfu v\u1ebd ngay tr\u00ean b\u1ea3ng d\u1eef li\u1ec7u chi ti\u1ebft, ch\u00fang ta r\u1ea5t kh\u00f3\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u00fang\u00a0\u0111\u01b0\u1ee3c tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3 b\u1edfi v\u00ec bi\u1ec3u\u00a0\u0111\u1ed3 <strong>kh\u00f4ng c\u00f3<\/strong> ch\u1ee9c n\u0103ng t\u1ef1 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u. Vi\u1ec7c t\u1ed5ng h\u1ee3p ph\u1ea3i l\u00e0m tr\u01b0\u1edbc khi v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3.<\/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-532.gif\" title=\"ex101_92019-nho-532\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><em>D\u1ef1a tr\u00ean ti\u00eau chu\u1ea9n n\u00e0y ch\u00fang ta s\u1ebd v\u1ebd\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u\u00a0\u0111\u1ed3 th\u1ec3 hi\u1ec7n \u0111\u00fang v\u00e0\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 n\u1ed9i dung.<\/em><\/p>\n<p><strong>Ti\u00eau chu\u1ea9n 2: D\u1eef li\u1ec7u v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 ph\u1ea3i th\u1ed1ng nh\u1ea5t v\u1ec1 \u0111\u1ecbnh d\u1ea1ng\u00a0v\u00e0 lo\u1ea1i d\u1eef li\u1ec7u<\/strong><\/p>\n<p>Ti\u00eau chu\u1ea9n th\u1ee9 2 khi mu\u1ed1n <strong>v\u1ebd bi\u1ec3u \u0111\u1ed3 trong excel<\/strong> l\u00e0 s\u1ef1 th\u1ed1ng nh\u1ea5t bao g\u1ed3m c\u00e1c ti\u00eau ch\u00ed:<\/p>\n<ul>\n<li>C\u00e1c d\u1eef li\u1ec7u ph\u1ea3i\u00a0c\u00f9ng lo\u1ea1i: c\u00f9ng l\u00e0 Text ho\u1eb7c c\u00f9ng l\u00e0 Number, % ch\u1ee9 kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c l\u1eabn l\u1ed9n gi\u1eefa c\u00e1c lo\u1ea1i n\u00e0y.<\/li>\n<li>C\u00e1c d\u1eef li\u1ec7u c\u00f9ng lo\u1ea1i ph\u1ea3i n\u1eb1m tr\u00ean c\u00f9ng 1 h\u00e0ng ho\u1eb7c c\u00f9ng 1 c\u1ed9t.<\/li>\n<\/ul>\n<p><em>D\u1ef1a tr\u00ean c\u00e1c d\u1ea1ng d\u1eef li\u1ec7u n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3 ph\u00f9 h\u1ee3p.<\/em><\/p>\n<p><strong>Ti\u00eau chu\u1ea9n 3: C\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u (t\u00ean c\u1ed9t, t\u00ean h\u00e0ng) ph\u1ea3i c\u00f3 n\u1ed9i dung r\u00f5 r\u00e0ng.<\/strong><\/p>\n<p>Vi\u1ec7c n\u00e0y\u00a0\u1ea3nh h\u01b0\u1edfng khi v\u1ebd l\u00ean bi\u1ec3u\u00a0\u0111\u1ed3, ch\u00fang ta c\u00f3 th\u1ec3 g\u1eb7p t\u00ecnh tr\u1ea1ng: kh\u00f4ng bi\u1ebft c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3 th\u1ec3 hi\u1ec7n n\u1ed9i dung g\u00ec. Ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh r\u00f5 c\u00e1c n\u1ed9i dung th\u00ec m\u1edbi\u00a0\u0111\u1ecdc\u00a0\u0111\u01b0\u1ee3c\u00a0\u00fd ngh\u0129a c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3.<\/p>\n<p><em>D\u1ef1a tr\u00ean ti\u00eau chu\u1ea9n n\u00e0y ch\u00fang ta s\u1ebd x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c\u00a0\u00fd ngh\u0129a c\u1ee7a t\u1eebng n\u1ed9i dung\u00a0\u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3.<\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cac_buoc_ve_bieu_do_trong_Excel\"><\/span>C\u00e1c b\u01b0\u1edbc v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong Excel th\u00ec \u1edf m\u1ed7i 1 phi\u00ean b\u1ea3n c\u00f3 m\u1ed9t s\u1ed1 s\u1ef1 c\u1ea3i ti\u1ebfn trong vi\u1ec7c v\u1ebd bi\u1ec3u \u0111\u1ed3, \u0111\u1eb7c bi\u1ec7t t\u1eeb phi\u00ean b\u1ea3n Excel 2013 v\u00e0 2016 tr\u1edf \u0111i. Trong c\u00e1c phi\u00ean b\u1ea3n n\u00e0y c\u00f3 h\u1ed7 tr\u1ee3 th\u00eam nhi\u1ec1u lo\u1ea1i bi\u1ec3u \u0111\u1ed3 m\u1edbi, c\u00e1ch t\u00f9y bi\u1ebfn bi\u1ec3u \u0111\u1ed3 \u0111a d\u1ea1ng h\u01a1n. Trong ph\u1ea1m vi b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u<strong> c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/strong> \u00e1p d\u1ee5ng cho m\u1ecdi phi\u00ean b\u1ea3n.<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Trong th\u1ebb\u00a0<strong>Insert<\/strong>, ch\u1ecdn nh\u00f3m <strong>Chart<\/strong> v\u00e0 ch\u1ecdn lo\u1ea1i bi\u1ec3u\u00a0\u0111\u1ed3 ph\u00f9 h\u1ee3p<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-23129 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhom-chart-trong-the-insert.png\" alt=\"cach-ve-bieu-do-trong-excel-1\" width=\"553\" height=\"151\" title=\"nhom-chart-trong-the-insert\"><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: V\u1ebd ra v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong Sheet<\/p>\n<p>N\u1ebfu bi\u1ec3u\u00a0\u0111\u1ed3 ch\u01b0a\u00a0\u0111\u00fang ho\u1eb7c\u00a0c\u1ea7n thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u n\u1ea1p v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3, ch\u1ecdn th\u1ebb <strong>Chart Tools<\/strong> (th\u1ebb n\u00e0y xu\u1ea5t hi\u1ec7n khi b\u1ea5m ch\u1ecdn bi\u1ec3u\u00a0\u0111\u1ed3), ch\u1ecdn ti\u1ebfp th\u1ebb <strong>Design<\/strong>, r\u1ed3i ch\u1ecdn t\u1edbi ch\u1ee9c n\u0103ng <strong>Select Data<\/strong><\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-23130 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/design-select-data-cho-bieu-do.png\" alt=\"cach-ve-bieu-do-trong-excel-2\" width=\"533\" height=\"198\" title=\"design-select-data-cho-bieu-do\"><\/p>\n<p><strong>B\u01b0\u1edbc 4<\/strong>:\u00a0Trang tr\u00ed bi\u1ec3u\u00a0\u0111\u1ed3<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thay_doi_du_lieu_nap_vao_bieu_do\"><\/span>C\u00e1ch thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u n\u1ea1p v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong c\u00e1c b\u01b0\u1edbc v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u1edf tr\u00ean, ch\u00fang ta th\u1ea5y\u00a0\u1edf b\u01b0\u1edbc 3 c\u00f3 n\u00f3i t\u1edbi vi\u1ec7c ch\u00fang ta c\u00f3 th\u1ec3 thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u n\u1ea1p v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3, gi\u00fap bi\u1ec3u\u00a0\u0111\u1ed3 th\u1ec3 hi\u1ec7n\u00a0\u0111\u00fang h\u01a1n so v\u1edbi mong mu\u1ed1n. V\u1eady ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y th\u1ebf n\u00e0o?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-23132 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cua-so-select-data-chart.png\" alt=\"cach-ve-bieu-do-trong-excel-3\" width=\"712\" height=\"406\" title=\"cua-so-select-data-chart\"><\/p>\n<p><strong>Chart Data Source<\/strong>: Ngu\u1ed3n d\u1eef li\u1ec7u n\u1ea1p v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3: To\u00e0n b\u1ed9 c\u00e1c d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u01b0a v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3. C\u00f3 th\u1ec3 kh\u00f4ng c\u00f3 t\u00ednh li\u00ean t\u1ee5c m\u00e0 t\u1eebng v\u00f9ng ri\u00eang<\/p>\n<p><strong>Legend Entries (Series)<\/strong>: D\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n theo tr\u1ee5c tung: Chi\u1ec1u cao c\u1ee7a c\u00e1c c\u1ed9t trong bi\u1ec3u \u0111\u1ed3,\u00a0\u0111\u1ed9 l\u1edbn c\u1ee7a c\u00e1c m\u1ea3nh trong bi\u1ec3u\u00a0\u0111\u1ed3\u00a0h\u00ecnh tr\u00f2n\u2026\u00a0\u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n qua ph\u1ea7n n\u00e0y<\/p>\n<p><strong>Horizontal (category)\u00a0Axis Labels<\/strong>: D\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n theo tr\u1ee5c ho\u00e0ng: n\u1ed9i dung\u00a0\u0111\u1ea1i di\u1ec7n cho\u00a0\u00a0c\u00e1c c\u1ed9t, c\u00e1c m\u1ea3nh\u2026 tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-22634 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-data-tu-bieu-do.png\" alt=\"cach-ve-bieu-do-trong-excel-4\" width=\"589\" height=\"558\" title=\"change-data-tu-bieu-do\"><\/p>\n<p style=\"text-align: center\"><em>V\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c thi\u1ebft l\u1eadp thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u trong bi\u1ec3u\u00a0\u0111\u1ed3<\/em><\/p>\n<p style=\"text-align: left\">C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft sau\u00a0\u0111\u1ec3 bi\u1ebft th\u00eam v\u1ec1 c\u00e1ch thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u n\u1ea1p v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3:<\/p>\n<p style=\"text-align: left;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tu-dong-gan-logo-tren-bieu-do-hinh-cot.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ef1 \u0111\u1ed9ng g\u1eafn logo tr\u00ean bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t<\/a><\/p>\n<p style=\"text-align: left;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=\"text-align: left;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<h2><span class=\"ez-toc-section\" id=\"Cach_trang_tri_bieu_do_dep_mat\"><\/span>C\u00e1ch trang tr\u00ed bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u1eb9p m\u1eaft<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left\">Trang tr\u00ed bi\u1ec3u\u00a0\u0111\u1ed3 th\u01b0\u1eddng l\u00e0 b\u01b0\u1edbc cu\u1ed1i c\u00f9ng, nh\u01b0ng c\u0169ng l\u00e0 b\u01b0\u1edbc r\u1ea5t quan tr\u1ecdng v\u00ec bi\u1ec3u\u00a0\u0111\u1ed3 l\u00e0m ra\u00a0\u0111\u1ec3 ng\u01b0\u1eddi kh\u00e1c xem. Do\u00a0\u0111\u00f3 hi\u1ec7u qu\u1ea3 th\u1ea9m m\u1ef9 m\u00e0 bi\u1ec3u\u00a0\u0111\u1ed3 mang l\u1ea1i s\u1ebd t\u0103ng t\u00ednh thuy\u1ebft ph\u1ee5c ng\u01b0\u1eddi xem. M\u1ed9t bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u1eb9p th\u01b0\u1eddng bao g\u1ed3m c\u00e1c y\u1ebfu t\u1ed1:<\/p>\n<ul>\n<li style=\"text-align: left\">N\u1ed9i dung th\u1ec3 hi\u1ec7n\u00a0\u0111\u00fang<\/li>\n<li style=\"text-align: left\">C\u00f3 t\u00ean bi\u1ec3u\u00a0\u0111\u1ed3 v\u00e0 t\u00ean c\u00e1c m\u1ed1c tr\u00ean tr\u1ee5c t\u1ecda\u00a0\u0111\u1ed9 r\u00f5 r\u00e0ng<\/li>\n<li style=\"text-align: left\">C\u00e1c th\u00e0nh ph\u1ea7n\u00a0\u0111\u01b0\u1ee3c c\u00e1ch\u00a0\u0111\u1ec1u nhau ho\u1eb7c theo t\u1ef7 l\u1ec7\u00a0c\u00e2n\u00a0\u0111\u1ed1i<\/li>\n<li style=\"text-align: left\">C\u00e1ch ph\u1ed1i m\u00e0u\u00a0\u0111\u1ed3ng nh\u1ea5t, g\u1ecdn g\u00e0ng, c\u00e0ng\u00a0\u0111\u01a1n gi\u1ea3n c\u00e0ng t\u1ed1t.<\/li>\n<\/ul>\n<p style=\"text-align: left\">\u0110\u1ec3 th\u00eam c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3 nh\u01b0: T\u00ean bi\u1ec3u\u00a0\u0111\u1ed3, t\u00ean c\u00e1c tr\u1ee5c, s\u1ed1 li\u1ec7u k\u00e8m theo v\u1edbi t\u1eebng ph\u1ea7n n\u1ed9i dung bi\u1ec3u\u00a0\u0111\u1ed3\u2026 th\u00ec ch\u00fang ta s\u1ebd th\u00eam\u00a0\u1edf m\u1ee5c <strong>Add Chart Element<\/strong> trong th\u1ebb <strong>Design<\/strong> c\u1ee7a\u00a0<strong>Chart Tools<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-21140 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mos-excel-2010-add-element-1.png\" alt=\"cach-ve-bieu-do-trong-excel-5\" width=\"922\" height=\"367\" title=\"mos-excel-2010-add-element-1\"><\/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>Trong m\u1ed7i nh\u00f3m tr\u00ean l\u1ea1i c\u00f3 nh\u1eefng\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee5 th\u1ec3, v\u1ecb tr\u00ed c\u1ee5 th\u1ec3\u00a0\u0111\u1ec3 ch\u00fang ta ch\u1ecdn cho ph\u00f9 h\u1ee3p.<\/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-532.gif\" title=\"ex101_92019-nho-532\"><br \/>\n<\/a><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau\u00a0\u0111\u1ec3 bi\u1ebft c\u00e1ch t\u00f9y bi\u1ebfn n\u1ed9i dung th\u1ec3 hi\u1ec7n tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html\">T\u00f9y ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 Excel: th\u00eam ti\u00eau \u0111\u1ec1, tr\u1ee5c, ch\u00fa th\u00edch, nh\u00e3n d\u1eef li\u1ec7u v\u00e0 nhi\u1ec1u th\u1ee9 kh\u00e1c<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-them-va-xoa-tieu-de-ten-cac-truc-toa-do-cho-bieu-do-excel.html\">C\u00e1ch th\u00eam v\u00e0 xo\u00e1 ti\u00eau \u0111\u1ec1, t\u00ean c\u00e1c tr\u1ee5c to\u1ea1 \u0111\u1ed9 cho bi\u1ec3u \u0111\u1ed3 Excel<\/a><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c t\u1ed5ng quan v\u1ec1 quy tr\u00ecnh v\u00e0 c\u00e1c k\u1ef9 thu\u1eadt \u0111\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3 tr\u00ean excel. Ch\u00fac c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng t\u1ed1t nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c nh\u00e9. Tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft trong <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\"><strong>kh\u00f3a h\u1ecdc Excel C\u01a1 B\u1ea3n<\/strong><\/a> c\u1ee7a ch\u00fang t\u00f4i v\u1ec1\u00a0b\u00e1o c\u00e1o bi\u1ec3u \u0111\u1ed3th\u01b0\u1eddng g\u1eb7p trong th\u1ef1c t\u1ebf:<\/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-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n tr\u00ean 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-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-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<\/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-532.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5949,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5948","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\/5948","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=5948"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5948\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5949"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5948"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5948"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}