{"id":2822,"date":"2024-12-02T08:47:48","date_gmt":"2024-12-02T08:47:48","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tuy-chinh-bieu-do-excel-them-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac\/"},"modified":"2024-12-02T08:47:48","modified_gmt":"2024-12-02T08:47:48","slug":"tuy-chinh-bieu-do-excel-them-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tuy-chinh-bieu-do-excel-them-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac\/","title":{"rendered":"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"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id='=\"hi\u1ec7n-s\u1ed1-li\u1ec7u-tr\u00ean-bi\u1ec3u-\u0111\u1ed3-excel\"' cite=\"https:\/\/blog.hocexcel.online\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html?hien-so-lieu-tren-bieu-do-excel\">\n<p><em>Sau khi b\u1ea1n \u0111\u00e3 t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 trong Excel, \u0111i\u1ec1u \u0111\u1ea7u ti\u00ean b\u1ea1n th\u01b0\u1eddng mu\u1ed1n l\u00e0m v\u1edbi n\u00f3 l\u00e0 g\u00ec? L\u00e0m cho \u0111\u1ed3 th\u1ecb tr\u00f4ng gi\u1ed1ng \u0111\u00fang v\u1edbi t\u01b0\u1edfng t\u01b0\u1ee3ng trong \u0111\u1ea7u b\u1ea1n! <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u00fap b\u1ea1n t\u00f9y ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 chuy\u00ean nghi\u1ec7p nh\u1ea5t, <strong>hi\u1ec7n s\u1ed1 li\u1ec7u tr\u00ean bi\u1ec3u \u0111\u1ed3 excel<\/strong><\/em><\/p>\n<\/blockquote>\n<p>Trong c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n \u0111\u1ea1i c\u1ee7a Excel, 2013 v\u00e0 2016, bi\u1ec3u \u0111\u1ed3 c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh d\u1ec5 d\u00e0ng.\u00a0Microsoft \u0111\u00e3 th\u1ef1c s\u1ef1 \u0111\u00e3 n\u1ed7 l\u1ef1c \u0111\u1ec3 \u0111\u01a1n gi\u1ea3n h\u00f3a qu\u00e1 tr\u00ecnh v\u00e0 \u0111\u1eb7t c\u00e1c tu\u1ef3 ch\u1ecdn tu\u1ef3 ch\u1ec9nh d\u1ec5 d\u00e0ng h\u01a1n.\u00a0Trong h\u01b0\u1edbng d\u1eabn n\u00e0y, b\u1ea1n s\u1ebd h\u1ecdc m\u1ed9t s\u1ed1 c\u00e1ch l\u00e0m nhanh ch\u00f3ng \u0111\u1ec3 th\u00eam v\u00e0 s\u1eeda \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c y\u1ebfu t\u1ed1 thi\u1ebft y\u1ebfu c\u1ee7a bi\u1ec3u \u0111\u1ed3 Excel.<\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li>H\u01b0\u1edbng d\u1eabn 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\u1ed3 trong Excel<\/strong> <\/a>2010, 2013, 2016<\/li>\n<li><a href=\"http:\/\/phan-tich-du-lieu.hocexcel.online?utm_source=Blog&amp;utm_medium=BLOG_EX101_BACHNX_POST_01_05&amp;utm_campaign=DV101\" target=\"_blank\" rel=\"noopener noreferrer\">Hi\u1ec3u v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi bi\u1ec3u \u0111\u1ed3 Excel<\/a><\/li>\n<li><a href=\"http:\/\/phan-tich-du-lieu.hocexcel.online?utm_source=Blog&amp;utm_medium=BLOG_EX101_BACHNX_POST_01_05&amp;utm_campaign=DV101\" target=\"_blank\" rel=\"noopener noreferrer\">X\u00e2y d\u1ef1ng bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng trong Excel<\/a><\/li>\n<\/ul>\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-674d743311ac6\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Ba_cach_de_tuy_chinh_cac_bieu_do_trong_Excel_hien_so_lieu_tren_bieu_do_excel\" title=\"Ba c\u00e1ch \u0111\u1ec3 t\u00f9y ch\u1ec9nh c\u00e1c bi\u1ec3u \u0111\u1ed3 trong Excel, hi\u1ec7n s\u1ed1 li\u1ec7u tr\u00ean bi\u1ec3u \u0111\u1ed3 excel\">Ba c\u00e1ch \u0111\u1ec3 t\u00f9y ch\u1ec9nh c\u00e1c bi\u1ec3u \u0111\u1ed3 trong Excel, hi\u1ec7n s\u1ed1 li\u1ec7u tr\u00ean bi\u1ec3u \u0111\u1ed3 excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Lam_the_nao_de_them_tieu_de_vao_bieu_do_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 th\u00eam ti\u00eau \u0111\u1ec1 v\u00e0o bi\u1ec3u \u0111\u1ed3 Excel\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 th\u00eam ti\u00eau \u0111\u1ec1 v\u00e0o bi\u1ec3u \u0111\u1ed3 Excel<\/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\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Lien_ket_tieu_de_bieu_do_den_mot_so_o_tren_trang_tinh\" title=\"Li\u00ean k\u1ebft ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 \u0111\u1ebfn m\u1ed9t s\u1ed1 \u00f4 tr\u00ean trang t\u00ednh:\">Li\u00ean k\u1ebft ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 \u0111\u1ebfn m\u1ed9t s\u1ed1 \u00f4 tr\u00ean trang t\u00ednh:<\/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\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Xoa_tieu_de_bieu_do\" title=\"X\u00f3a ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3:\">X\u00f3a ti\u00eau \u0111\u1ec1 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-5\" href=\"https:\/\/blog.hocexcel.online\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Thay_doi_phong_chu_va_dinh_dang_cua_tieu_de_bieu_do\" title=\"Thay \u0111\u1ed5i ph\u00f4ng ch\u1eef v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3:\">Thay \u0111\u1ed5i ph\u00f4ng ch\u1eef v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ti\u00eau \u0111\u1ec1 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-6\" href=\"https:\/\/blog.hocexcel.online\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Tuy_chinh_cac_truc_trong_bieu_do_Excel\" title=\"T\u00f9y ch\u1ec9nh c\u00e1c tr\u1ee5c trong bi\u1ec3u \u0111\u1ed3 Excel:\">T\u00f9y ch\u1ec9nh c\u00e1c tr\u1ee5c trong bi\u1ec3u \u0111\u1ed3 Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Them_tieu_de_truc_vao_bieu_do\" title=\"Th\u00eam ti\u00eau \u0111\u1ec1 tr\u1ee5c v\u00e0o bi\u1ec3u \u0111\u1ed3:\">Th\u00eam ti\u00eau \u0111\u1ec1 tr\u1ee5c v\u00e0o 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\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Tieu_de_truc_lien_ket_den_mot_o_nhat_dinh_tren_trang_tinh\" title=\"Ti\u00eau \u0111\u1ec1 tr\u1ee5c li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t \u00f4 nh\u1ea5t \u0111\u1ecbnh tr\u00ean trang t\u00ednh:\">Ti\u00eau \u0111\u1ec1 tr\u1ee5c li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t \u00f4 nh\u1ea5t \u0111\u1ecbnh tr\u00ean trang t\u00ednh:<\/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\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Thay_doi_thang_do_cua_truc_trong_bieu_do\" title=\"Thay \u0111\u1ed5i thang \u0111o c\u1ee7a tr\u1ee5c trong bi\u1ec3u \u0111\u1ed3:\">Thay \u0111\u1ed5i thang \u0111o c\u1ee7a tr\u1ee5c 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-10\" href=\"https:\/\/blog.hocexcel.online\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Thay_doi_dinh_dang_so_tren_nhan_truc\" title=\"Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 tr\u00ean nh\u00e3n tr\u1ee5c:\">Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 tr\u00ean nh\u00e3n tr\u1ee5c:<\/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\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Them_nhan_du_lieu_vao_bieu_do_Excel\" title=\"Th\u00eam nh\u00e3n d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u \u0111\u1ed3 Excel:\">Th\u00eam nh\u00e3n d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u \u0111\u1ed3 Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Cach_thay_doi_du_lieu_duoc_hien_thi_tren_nhan\" title=\"C\u00e1ch thay \u0111\u1ed5i d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb tr\u00ean nh\u00e3n:\">C\u00e1ch thay \u0111\u1ed5i d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb tr\u00ean nh\u00e3n:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/tuy-chinh-bieu-excel-tieu-de-truc-chu-thich-nhan-du-lieu-va-nhieu-thu-khac.html#Di_chuyen_dinh_dang_hoac_an_chu_thich_cua_bieu_do\" title=\"Di chuy\u1ec3n, \u0111\u1ecbnh d\u1ea1ng ho\u1eb7c \u1ea9n ch\u00fa th\u00edch c\u1ee7a bi\u1ec3u \u0111\u1ed3:\">Di chuy\u1ec3n, \u0111\u1ecbnh d\u1ea1ng ho\u1eb7c \u1ea9n ch\u00fa th\u00edch c\u1ee7a bi\u1ec3u \u0111\u1ed3:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ba_cach_de_tuy_chinh_cac_bieu_do_trong_Excel_hien_so_lieu_tren_bieu_do_excel\"><\/span><strong>Ba c\u00e1ch \u0111\u1ec3 t\u00f9y ch\u1ec9nh c\u00e1c bi\u1ec3u \u0111\u1ed3 trong Excel, hi\u1ec7n s\u1ed1 li\u1ec7u tr\u00ean bi\u1ec3u \u0111\u1ed3 excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Ch\u1ecdn bi\u1ec3u \u0111\u1ed3 v\u00e0 \u0111i t\u1edbi\u00a0tab\u00a0<strong>Chart Tools\u00a0<\/strong>(\u00a0<em>Design\u00a0<\/em>v\u00e0<em>\u00a0Format<\/em>) tr\u00ean ribbon Excel.<\/li>\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o ph\u1ea7n t\u1eed bi\u1ec3u \u0111\u1ed3 b\u1ea1n mu\u1ed1n t\u00f9y ch\u1ec9nh v\u00e0 ch\u1ecdn m\u1ee5c t\u01b0\u01a1ng \u1ee9ng t\u1eeb tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.<\/li>\n<li>S\u1eed d\u1ee5ng n\u00fat tu\u1ef3 ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 xu\u1ea5t hi\u1ec7n \u1edf g\u00f3c tr\u00ean c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a bi\u1ec3u \u0111\u1ed3 Excel khi b\u1ea1n nh\u1ea5p v\u00e0o n\u00f3.<\/li>\n<\/ol>\n<p>B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y th\u00eam t\u00f9y ch\u1ecdn t\u00f9y ch\u1ec9nh tr\u00ean<strong>\u00a0Format Chart pane <\/strong>xu\u1ea5t hi\u1ec7n \u1edf b\u00ean ph\u1ea3i trang t\u00ednh c\u1ee7a b\u1ea1n ngay khi b\u1ea1n nh\u1ea5p v\u00e0o\u00a0<em>More options \u2026<\/em>\u00a0trong tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh c\u1ee7a bi\u1ec3u \u0111\u1ed3 ho\u1eb7c tr\u00ean\u00a0tab\u00a0<em>Chart Tools<\/em>\u00a0tr\u00ean Ribbon.<\/p>\n<p><strong>M\u1eb9o.\u00a0<\/strong>\u0110\u1ec3 truy c\u1eadp ngay v\u00e0o c\u00e1c tu\u1ef3\u00a0ch\u1ecdn\u00a0<em>Format Chart pane\u00a0<\/em>c\u00f3 li\u00ean quan, nh\u1ea5p \u0111\u00fap v\u00e0o ph\u1ea7n t\u1eed t\u01b0\u01a1ng \u1ee9ng trong bi\u1ec3u \u0111\u1ed3.<\/p>\n<p>V\u1edbi ki\u1ebfn \u200b\u200bth\u1ee9c c\u01a1 b\u1ea3n n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eeda \u0111\u1ed5i c\u00e1c y\u1ebfu t\u1ed1 bi\u1ec3u \u0111\u1ed3 kh\u00e1c nhau sao cho bi\u1ec3u \u0111\u1ed3 Excel c\u1ee7a b\u1ea1n ch\u00ednh x\u00e1c theo c\u00e1ch b\u1ea1n mu\u1ed1n.<\/p>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/lam-viec-voi-ban-do-trong-excel-2016-2010.html\">L\u00e0m vi\u1ec7c v\u1edbi b\u1ea3n \u0111\u1ed3 trong Excel 2016 \u2013 2010<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_them_tieu_de_vao_bieu_do_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 th\u00eam ti\u00eau \u0111\u1ec1 v\u00e0o bi\u1ec3u \u0111\u1ed3 Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ph\u1ea7n n\u00e0y tr\u00ecnh b\u00e0y <strong>c\u00e1ch \u0111\u1ec3 ch\u00e8n c\u00e1c ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 trong c\u00e1c phi\u00ean b\u1ea3n Excel kh\u00e1c nhau<\/strong> \u0111\u1ec3 b\u1ea1n bi\u1ebft v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n c\u1ee7a c\u00e1c t\u00ednh n\u0103ng n\u00e0y.\u00a0V\u00e0 trong ph\u1ea7n h\u01b0\u1edbng d\u1eabn c\u00f2n l\u1ea1i, ch\u00fang t\u00f4i s\u1ebd t\u1eadp trung v\u00e0o c\u00e1c phi\u00ean b\u1ea3n Excel 2013 v\u00e0 g\u1ea7n \u0111\u00e2y nh\u1ea5t l\u00e0 2016.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-90.gif\" title=\"vba101_92019-nho-90\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-217.gif\" title=\"ex101_92019-nho-217\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Th\u00eam ti\u00eau \u0111\u1ec1 v\u00e0o bi\u1ec3u \u0111\u1ed3 trong Excel 2013 v\u00e0 Excel 2016<\/p>\n<p>Trong Excel 2013 v\u00e0 Excel 2016, m\u1ed9t bi\u1ec3u \u0111\u1ed3 \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00e8n s\u1ebd c\u00f3 t\u00ean m\u1eb7c \u0111\u1ecbnh l\u00e0 \u201d\u00a0<em>Chart Title<\/em>\u00a0\u201d\u00a0.\u00a0\u0110\u1ec3 thay \u0111\u1ed5i ti\u00eau \u0111\u1ec1, ch\u1ec9 c\u1ea7n ch\u1ecdn h\u1ed9p \u0111\u00f3 v\u00e0 nh\u1eadp ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea1n:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/1-13.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7620\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-13.bmp\" width=\"600\" height=\"245\" title=\"1-13\"><\/a>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3\u00a0<strong>li\u00ean k\u1ebft ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3<\/strong>\u00a0v\u1edbi m\u1ed9t s\u1ed1 \u00f4 tr\u00ean trang, \u0111\u1ec3 n\u00f3 \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng m\u1ed7i khi \u00f4 \u0111\u00f3 \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt.<\/p>\n<p>N\u1ebfu v\u00ec l\u00fd do n\u00e0o \u0111\u00f3 ti\u00eau \u0111\u1ec1 kh\u00f4ng \u0111\u01b0\u1ee3c ch\u00e8n t\u1ef1 \u0111\u1ed9ng, nh\u1ea5p v\u00e0o b\u1ea5t c\u1ee9 n\u01a1i n\u00e0o trong bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 c\u00e1c\u00a0tab\u00a0<strong>Chart Tools<\/strong>\u00a0xu\u1ea5t hi\u1ec7n.\u00a0Chuy\u1ec3n sang\u00a0<em>Design<\/em>, v\u00e0 nh\u1ea5n\u00a0<em><strong>Chart Element\u00a0&gt;\u00a0Chart Title\u00a0&gt;\u00a0Above Chart<\/strong> \u00a0(<\/em>ho\u1eb7c<em>\u00a0Centered Overlay)<\/em><\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Adding a chart title in Excel 2013 and Excel 2016\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-chart-title-excel.png\" alt=\"Adding a chart title in Excel 2013 and Excel 2016\"><br \/>\nHo\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>Chart Elements\u00a0<\/em>\u1edf g\u00f3c tr\u00ean b\u00ean ph\u1ea3i c\u1ee7a bi\u1ec3u \u0111\u1ed3 v\u00e0 \u0111\u1eb7t d\u1ea5u\u00a0ki\u1ec3m v\u00e0o h\u1ed9p ki\u1ec3m\u00a0<strong>Chart Title<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Adding a title to the chart using the Chart Elements button.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-chart-title-excel2.png\" alt=\"Adding a title to the chart using the Chart Elements button.\"><\/p>\n<p><strong>Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o m\u0169i t\u00ean b\u00ean c\u1ea1nh\u00a0<em>Chart Title\u00a0<\/em>v\u00e0 ch\u1ecdn m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn sau:<\/strong><\/p>\n<ul>\n<li><em>Above Chart\u00a0<\/em>\u2013 t\u00f9y ch\u1ecdn m\u1eb7c \u0111\u1ecbnh hi\u1ec3n th\u1ecb ti\u00eau \u0111\u1ec1 \u1edf tr\u00ean c\u00f9ng c\u1ee7a khu v\u1ef1c bi\u1ec3u \u0111\u1ed3 v\u00e0 thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc c\u1ee7a bi\u1ec3u \u0111\u1ed3.<\/li>\n<li><em>Centered Overlay<\/em>\u2013 ch\u00e8n ti\u00eau \u0111\u1ec1 l\u00ean trung t\u00e2m bi\u1ec3u \u0111\u1ed3 m\u00e0 kh\u00f4ng thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc bi\u1ec3u \u0111\u1ed3.<\/li>\n<\/ul>\n<p>\u0110\u1ed1i th\u00eam l\u1ef1a ch\u1ecdn, \u0111\u1ebfn\u00a0 tab<strong><em> Design\u00a0 &gt;\u00a0Add Chart Element\u00a0&gt;\u00a0Chart Title\u00a0&gt;\u00a0More Options.<\/em>.<\/strong><\/p>\n<p><em>Ho\u1eb7c,<\/em>\u00a0b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>Chart Elements <\/em>v\u00e0 nh\u1ea5p v\u00e0o\u00a0<strong><em>Chart Title\u00a0&gt;\u00a0More Options\u2026.<\/em><\/strong><\/p>\n<p>Nh\u1ea5p v\u00e0o\u00a0m\u1ee5c\u00a0<em>More Options\u00a0 <\/em>(tr\u00ean ribbon ho\u1eb7c trong tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh) m\u1edf b\u1ea3ng\u00a0<strong>\u00a0Format Chart Title\u00a0 <\/strong>\u1edf ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a b\u1ea3ng t\u00ednh, v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng c\u1ee7a m\u00ecnh.<\/p>\n<p>Th\u00eam ti\u00eau \u0111\u1ec1 v\u00e0o bi\u1ec3u \u0111\u1ed3 trong Excel 2010 v\u00e0 Excel 2007<\/p>\n<p><strong>\u0110\u1ec3 th\u00eam ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 trong Excel 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau.<\/strong><\/p>\n<ol>\n<li>Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 n\u01a1i n\u00e0o trong bi\u1ec3u \u0111\u1ed3 Excel \u0111\u1ec3 k\u00edch ho\u1ea1t tab Chart Tools\u00a0tr\u00ean<\/li>\n<li>Tr\u00ean\u00a0tab\u00a0<em>Layout<\/em>, h\u00e3y nh\u1ea5p v\u00e0o\u00a0<strong>hart Title\u00a0&gt;\u00a0<em>Above Chart<\/em><\/strong><strong>ho\u1eb7c<\/strong><strong>\u00a0<em>Centered Overlay<\/em><\/strong>\u00a0.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Adding a chart title in Excel 2010\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-chart-title-excel2010.png\" alt=\"Adding a chart title in Excel 2010\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lien_ket_tieu_de_bieu_do_den_mot_so_o_tren_trang_tinh\"><\/span><strong>Li\u00ean k\u1ebft ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 \u0111\u1ebfn m\u1ed9t s\u1ed1 \u00f4 tr\u00ean trang t\u00ednh:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ed1i v\u1edbi h\u1ea7u h\u1ebft c\u00e1c lo\u1ea1i bi\u1ec3u \u0111\u1ed3 Excel, \u0111\u1ed3 th\u1ecb m\u1edbi \u0111\u01b0\u1ee3c t\u1ea1o s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o v\u1edbi tr\u00ecnh Ti\u00eau \u0111\u1ec1 m\u1eb7c \u0111\u1ecbnh.\u00a0\u0110\u1ec3 th\u00eam ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 c\u1ee7a ri\u00eang b\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn h\u1ed9p title v\u00e0 g\u00f5 t\u00ean v\u00e0o ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 li\u00ean k\u1ebft ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 v\u1edbi m\u1ed9t s\u1ed1 \u00f4 tr\u00ean trang t\u00ednh, v\u00ed d\u1ee5 nh\u01b0 ti\u00eau \u0111\u1ec1 b\u1ea3ng.\u00a0Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ti\u00eau \u0111\u1ec1 c\u1ee7a bi\u1ec3u \u0111\u1ed3 Excel s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng m\u1ed7i khi b\u1ea1n ch\u1ec9nh s\u1eeda \u00f4 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft.<\/p>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-tao-hieu-ung-hoa-3d-trong-excel.html\">C\u00e1ch t\u1ea1o hi\u1ec7u \u1ee9ng \u0111\u1ed3 h\u1ecda 3D trong Excel<\/a><\/p>\n<p><em>\u0110\u1ec3 li\u00ean k\u1ebft ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 \u0111\u1ebfn m\u1ed9t \u00f4, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/em><\/p>\n<ol>\n<li>Ch\u1ecdn ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3.<\/li>\n<li>Tr\u00ean b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n, nh\u1eadp d\u1ea5u b\u1eb1ng (=) v\u00e0o thanh c\u00f4ng th\u1ee9c, nh\u1ea5p v\u00e0o \u00f4 ch\u1ee9a v\u0103n b\u1ea3n c\u1ea7n thi\u1ebft v\u00e0 nh\u1ea5n Enter.<\/li>\n<\/ol>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta \u0111ang li\u00ean k\u1ebft ti\u00eau \u0111\u1ec1 c\u1ee7a bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n v\u1edbi \u00f4 A1.\u00a0B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn hai ho\u1eb7c nhi\u1ec1u \u00f4, v\u00ed d\u1ee5 nh\u01b0 m\u1ed9t v\u00e0i ti\u00eau \u0111\u1ec1 c\u1ed9t, v\u00e0 n\u1ed9i dung c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn s\u1ebd xu\u1ea5t hi\u1ec7n trong ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7621\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-6.bmp\" width=\"600\" height=\"337\" title=\"new-bitmap-image-6\"><\/p>\n<p><strong>Di chuy\u1ec3n ti\u00eau \u0111\u1ec1 trong bi\u1ec3u \u0111\u1ed3<\/strong><\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n chuy\u1ec3n ti\u00eau \u0111\u1ec1 sang m\u1ed9t v\u1ecb tr\u00ed kh\u00e1c trong bi\u1ec3u \u0111\u1ed3, h\u00e3y ch\u1ecdn n\u00f3 v\u00e0 k\u00e9o chu\u1ed9t:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Moving the title to a different place within the chart\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/move-chart-title.png\" alt=\"Moving the title to a different place within the chart\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xoa_tieu_de_bieu_do\"><\/span><strong>X\u00f3a ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n b\u1ea5t k\u1ef3 ti\u00eau \u0111\u1ec1 n\u00e0o trong bi\u1ec3u \u0111\u1ed3 Excel c\u1ee7a m\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a n\u00f3 b\u1eb1ng hai c\u00e1ch:<\/p>\n<ul>\n<li>Tr\u00ean tab\u00a0<em>Design<\/em>, b\u1ea5m v\u00e0o\u00a0<em>Add Chart Element\u00a0&gt;\u00a0Chart Title\u00a0&gt;\u00a0None.<\/em>.<\/li>\n<li>Tr\u00ean bi\u1ec3u \u0111\u1ed3, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3, v\u00e0 ch\u1ecdn\u00a0<em>Delete <\/em>trong tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Removing the chart title\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/delete-chart-title.png\" alt=\"Removing the chart title\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_phong_chu_va_dinh_dang_cua_tieu_de_bieu_do\"><\/span><strong>Thay \u0111\u1ed5i ph\u00f4ng ch\u1eef v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 thay \u0111\u1ed5i\u00a0<strong>ph\u00f4ng ch\u1eef<\/strong>\u00a0c\u1ee7a ti\u00eau \u0111\u1ec1 trong Excel, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o ti\u00eau \u0111\u1ec1 v\u00e0 ch\u1ecdn\u00a0<strong>Font<\/strong>\u00a0trong tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.\u00a0C\u00e1c\u00a0<em>Font<\/em>\u00a0c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i s\u1ebd b\u1eadt l\u00ean, n\u01a1i b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Changing font and formatting of the chart title\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chart-title-font.png\" alt=\"Changing font and formatting of the chart title\"><\/p>\n<p>\u0110\u1ec3\u00a0<strong>c\u00f3 th\u00eam c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng<\/strong>\u00a0, h\u00e3y ch\u1ecdn ti\u00eau \u0111\u1ec1 tr\u00ean bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n, \u0111i t\u1edbi\u00a0tab\u00a0<strong>Format <\/strong>tr\u00ean ribbon v\u00e0 d\u00f9ng c\u00e1c t\u00ednh n\u0103ng kh\u00e1c.\u00a0V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i ti\u00eau \u0111\u1ec1 c\u1ee7a bi\u1ec3u \u0111\u1ed3 Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ribbon:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Find advanced formatting options on the Format tab.]\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-chart-title.png\" alt=\"Find advanced formatting options on the Format tab.]\"><\/p>\n<p>C\u0169ng c\u00f9ng m\u1ed9t c\u00e1ch, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a c\u00e1c y\u1ebfu t\u1ed1 bi\u1ec3u \u0111\u1ed3 kh\u00e1c nh\u01b0\u00a0ti\u00eau \u0111\u1ec1\u00a0tr\u1ee5c,\u00a0nh\u00e3n tr\u1ee5c\u00a0v\u00e0\u00a0ch\u00fa th\u00edch c\u1ee7a bi\u1ec3u \u0111\u1ed3\u00a0.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tuy_chinh_cac_truc_trong_bieu_do_Excel\"><\/span><strong>T\u00f9y ch\u1ec9nh c\u00e1c tr\u1ee5c trong bi\u1ec3u \u0111\u1ed3 Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ed1i v\u1edbi h\u1ea7u h\u1ebft c\u00e1c lo\u1ea1i bi\u1ec3u \u0111\u1ed3, tr\u1ee5c th\u1eb3ng \u0111\u1ee9ng (\u00a0c\u00f2n g\u1ecdi l\u00e0 tr\u1ee5c <em>value<\/em> hay\u00a0<em>tr\u1ee5c Y<\/em>\u00a0) v\u00e0 tr\u1ee5c ngang (c\u00f2n g\u1ecdi l\u00e0\u00a0<em>category<\/em>\u00a0ho\u1eb7c\u00a0<em>X<\/em>) \u0111\u01b0\u1ee3c th\u00eam t\u1ef1 \u0111\u1ed9ng khi b\u1ea1n t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 trong Excel.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb ho\u1eb7c \u1ea9n c\u00e1c tr\u1ee5c bi\u1ec3u \u0111\u1ed3 b\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o\u00a0n\u00fat\u00a0 <em>Chart Elements<\/em>\u00a0, sau \u0111\u00f3 nh\u1ea5p v\u00e0o m\u0169i t\u00ean b\u00ean c\u1ea1nh\u00a0<strong>Axes<\/strong>\u00a0, v\u00e0 sau \u0111\u00f3 \u0111\u00e1nh d\u1ea5u c\u00e1c tr\u1ee5c b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb v\u00e0 b\u1ecf ch\u1ecdn nh\u1eefng th\u1ee9 b\u1ea1n mu\u1ed1n \u1ea9n.<\/p>\n<p>\u0110\u1ed1i v\u1edbi m\u1ed9t s\u1ed1 lo\u1ea1i bi\u1ec3u \u0111\u1ed3, ch\u1eb3ng h\u1ea1n nh\u01b0\u00a0bi\u1ec3u \u0111\u1ed3 k\u1ebft h\u1ee3p\u00a0, m\u1ed9t\u00a0<strong>secondary axis \u2013 tr\u1ee5c th\u1ee9 c\u1ea5p <\/strong>c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7623\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-11.bmp\" width=\"600\" height=\"284\" title=\"2-11\"><\/p>\n<p>Khi t\u1ea1o bi\u1ec3u \u0111\u1ed3 3-D trong Excel, c\u00f3 th\u1ec3 c\u00f3 th\u00eam <strong>depth axis<\/strong>:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7624\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-8.bmp\" width=\"600\" height=\"245\" title=\"3-8\"><\/p>\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c \u0111i\u1ec1u ch\u1ec9nh kh\u00e1c nhau cho c\u00e1ch c\u00e1c ph\u1ea7n t\u1eed c\u1ee7a tr\u1ee5c kh\u00e1c nhau \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong bi\u1ec3u \u0111\u1ed3 Excel c\u1ee7a b\u1ea1n:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Change the way that different axis elements are displayed in your Excel chart\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chart-axis-elements.png\" alt=\"Change the way that different axis elements are displayed in your Excel chart\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Them_tieu_de_truc_vao_bieu_do\"><\/span><strong>Th\u00eam ti\u00eau \u0111\u1ec1 tr\u1ee5c v\u00e0o bi\u1ec3u \u0111\u1ed3:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi t\u1ea1o \u0111\u1ed3 th\u1ecb trong Excel, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam c\u00e1c ti\u00eau \u0111\u1ec1 v\u00e0o tr\u1ee5c ngang v\u00e0 d\u1ecdc \u0111\u1ec3 gi\u00fap ng\u01b0\u1eddi xem hi\u1ec3u \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u tr\u00ean bi\u1ec3u \u0111\u1ed3 l\u00e0 g\u00ec.\u00a0\u0110\u1ec3 th\u00eam ti\u00eau \u0111\u1ec1 tr\u1ee5c, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol>\n<li>Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 n\u01a1i n\u00e0o trong bi\u1ec3u \u0111\u1ed3 Excel c\u1ee7a b\u1ea1n, sau \u0111\u00f3 nh\u1ea5p v\u00e0o n\u00fat\u00a0<em>Chart Elements <\/em>v\u00e0 ch\u1ecdn\u00a0<strong>Axis Titles<\/strong>.\u00a0N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n hi\u1ec3n th\u1ecb ti\u00eau \u0111\u1ec1 cho m\u1ed9t tr\u1ee5c ngang ho\u1eb7c d\u1ecdc, h\u00e3y nh\u1ea5p v\u00e0o m\u0169i t\u00ean b\u00ean c\u1ea1nh\u00a0<em>Axis Titles <\/em>v\u00e0 b\u1ecf ch\u1ecdn m\u1ed9t trong c\u00e1c \u00f4:<\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/4-7.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7625\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-7.bmp\" width=\"600\" height=\"205\" title=\"4-7\"><\/a><\/p>\n<ol start=\"2\">\n<li>Nh\u1ea5p v\u00e0o h\u1ed9p ti\u00eau \u0111\u1ec1 tr\u1ee5c tr\u00ean bi\u1ec3u \u0111\u1ed3 v\u00e0 nh\u1eadp t\u00ean.<\/li>\n<\/ol>\n<p>Xem th\u00eam: <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<p>\u0110\u1ec3\u00a0<strong>\u0111\u1ecbnh d\u1ea1ng\u00a0ti\u00eau \u0111\u1ec1 tr\u1ee5c<\/strong>\u00a0, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o n\u00f3 v\u00e0 ch\u1ecdn\u00a0<em>Format Axis Title\u00a0<\/em>\u00a0t\u1eeb tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.\u00a0C\u1eeda\u00a0s\u1ed5\u00a0<em>Format Axis Title\u00a0<\/em>s\u1ebd xu\u1ea5t hi\u1ec7n v\u1edbi nhi\u1ec1u t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 l\u1ef1a ch\u1ecdn.\u00a0B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1eed c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau tr\u00ean\u00a0tab\u00a0<strong>Format<\/strong>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tieu_de_truc_lien_ket_den_mot_o_nhat_dinh_tren_trang_tinh\"><\/span><strong>Ti\u00eau \u0111\u1ec1 tr\u1ee5c li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t \u00f4 nh\u1ea5t \u0111\u1ecbnh tr\u00ean trang t\u00ednh:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u0169ng gi\u1ed1ng nh\u01b0 c\u00e1c\u00a0ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3, b\u1ea1n c\u00f3 th\u1ec3 li\u00ean k\u1ebft m\u1ed9t ti\u00eau \u0111\u1ec1 tr\u1ee5c v\u1edbi m\u1ed9t s\u1ed1 \u00f4 trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n \u0111\u1ec3 n\u00f3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt m\u1ed7i khi b\u1ea1n ch\u1ec9nh s\u1eeda c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p>\u0110\u1ec3 li\u00ean k\u1ebft m\u1ed9t ti\u00eau \u0111\u1ec1 tr\u1ee5c, h\u00e3y ch\u1ecdn n\u00f3, sau \u0111\u00f3 \u0111\u00e1nh d\u1ea5u b\u1eb1ng (=) v\u00e0o thanh c\u00f4ng th\u1ee9c, nh\u1ea5p v\u00e0o \u00f4 b\u1ea1n mu\u1ed1n li\u00ean k\u1ebft ti\u00eau \u0111\u1ec1, v\u00e0 nh\u1ea5n ph\u00edm Enter.<\/p>\n<p><strong>Xem th\u00eam<\/strong>: T\u1ed5ng h\u1ee3p b\u1ed9 <a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">t\u00e0i li\u1ec7u Excel c\u01a1 b\u1ea3n<\/a> hay nh\u1ea5t<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Linking the axis title to a given cell on the sheet\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/link-axis-title.png\" alt=\"Linking the axis title to a given cell on the sheet\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_thang_do_cua_truc_trong_bieu_do\"><\/span><strong>Thay \u0111\u1ed5i thang \u0111o c\u1ee7a tr\u1ee5c trong bi\u1ec3u \u0111\u1ed3:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Microsoft Excel t\u1ef1 \u0111\u1ed9ng x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t v\u00e0 l\u1edbn nh\u1ea5t c\u0169ng nh\u01b0 kho\u1ea3ng chia cho\u00a0<strong>vertical axis\u00a0<\/strong>d\u1ef1a tr\u00ean d\u1eef li\u1ec7u c\u00f3 trong bi\u1ec3u \u0111\u1ed3.\u00a0Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh \u0111\u1ec3 \u0111\u00e1p \u1ee9ng t\u1ed1t h\u01a1n nhu c\u1ea7u c\u1ee7a b\u1ea1n.<\/p>\n<ol>\n<li>Ch\u1ecdn tr\u1ee5c \u0111\u1ee9ng trong bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n, v\u00e0 nh\u1ea5p v\u00e0o n\u00fat\u00a0.\u00a0<em>Elements Chart<\/em><\/li>\n<li>Nh\u1ea5p v\u00e0o m\u0169i t\u00ean b\u00ean c\u1ea1nh\u00a0<em>Axis<\/em>, sau \u0111\u00f3 nh\u1ea5p v\u00e0o\u00a0<em>\u00a0More options\u2026 <\/em>Thao t\u00e1c n\u00e0y s\u1ebd m\u1edf ra\u00a0<em>Format Axis<\/em>.<\/li>\n<li>Tr\u00ean thanh\u00a0<em>Format Axis<\/em>, trong\u00a0<em>Axis Options,<\/em>nh\u1ea5p chu\u1ed9t v\u00e0o tr\u1ee5c gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i v\u00e0 th\u1ef1c hi\u1ec7n m\u1ed9t trong c\u00e1c thao t\u00e1c sau:<\/li>\n<\/ol>\n<ul>\n<li>\u0110\u1ec3 \u0111\u1eb7t \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u ho\u1eb7c \u0111i\u1ec3m k\u1ebft th\u00fac cho tr\u1ee5c th\u1eb3ng \u0111\u1ee9ng, h\u00e3y nh\u1eadp c\u00e1c s\u1ed1 t\u01b0\u01a1ng \u1ee9ng trong ph\u1ea7n\u00a0<em>Minimum\u00a0or\u00a0Maximum<\/em><\/li>\n<li>\u0110\u1ec3 thay \u0111\u1ed5i kho\u1ea3ng chia, h\u00e3y nh\u1eadp v\u00e0o\u00a0unit &gt;\u00a0<em>Major \u2013 \u0111\u01a1n v\u1ecb ch\u00ednh <\/em>v\u00e0\u00a0 <em>Minor- \u0111\u01a1n v\u1ecb chia nh\u1ecf<\/em>.<\/li>\n<li>\u0110\u1ec3 \u0111\u1ea3o ng\u01b0\u1ee3c th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb, \u0111\u00e1nh d\u1ea5u v\u00e0o <em>Values in reverse order<\/em>\u00a0.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Changing the vertical axis scale\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-axis-scale.png\" alt=\"Changing the vertical axis scale\"><\/p>\n<p>B\u1edfi v\u00ec m\u1ed9t\u00a0<strong>tr\u1ee5c ngang<\/strong>\u00a0hi\u1ec3n th\u1ecb c\u00e1c nh\u00e3n v\u0103n b\u1ea3n ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 kho\u1ea3ng s\u1ed1, n\u00f3 c\u00f3 \u00edt l\u1ef1a ch\u1ecdn thay \u0111\u1ed5i h\u01a1n.\u00a0Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i s\u1ed1 l\u01b0\u1ee3ng c\u00e1c m\u1ee5c \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Scaling options of the horizontal axis\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/customize-horizontal-axis.png\" alt=\"Scaling options of the horizontal axis\"><br \/>\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-217.gif\" title=\"ex101_92019-nho-217\"><br \/>\n<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_dinh_dang_so_tren_nhan_truc\"><\/span><strong>Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 tr\u00ean nh\u00e3n tr\u1ee5c:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n s\u1ed1 nh\u00e3n tr\u1ee5c gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7, t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m, th\u1eddi gian ho\u1eb7c m\u1ed9t s\u1ed1 \u0111\u1ecbnh d\u1ea1ng kh\u00e1c, h\u00e3y nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o nh\u00e3n tr\u1ee5c v\u00e0 ch\u1ecdn\u00a0<em>Format Axis\u00a0 <\/em>trong tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.\u00a0Tr\u00ean thanh\u00a0<em>Format Axis<\/em>\u00a0, nh\u1ea5p v\u00e0o\u00a0<strong>Number <\/strong>v\u00e0 ch\u1ecdn m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng c\u00f3 s\u1eb5n:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/5-4.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7626\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-4.bmp\" width=\"600\" height=\"455\" title=\"5-4\"><\/a><strong>M\u1eb9o.\u00a0<\/strong>\u0110\u1ec3 tr\u1edf v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ban \u0111\u1ea7u (c\u00e1ch th\u1ee9c \u0111\u1ecbnh d\u1ea1ng trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n), h\u00e3y ch\u1ecdn h\u1ed9p\u00a0<em>Linked to source\u00a0<\/em>.<\/p>\n<p>N\u1ebfu b\u1ea1n kh\u00f4ng th\u1ea5y ph\u1ea7n\u00a0<em>Number <\/em>trong ng\u0103n\u00a0<em>\u00a0Format Axis<\/em>, h\u00e3y ch\u1eafc r\u1eb1ng b\u1ea1n \u0111\u00e3 ch\u1ecdn \u0111\u00fang tr\u1ee5c gi\u00e1 tr\u1ecb (th\u01b0\u1eddng l\u00e0 tr\u1ee5c d\u1ecdc) trong bi\u1ec3u \u0111\u1ed3 Excel c\u1ee7a m\u00ecnh.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Them_nhan_du_lieu_vao_bieu_do_Excel\"><\/span><strong>Th\u00eam nh\u00e3n d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u \u0111\u1ed3 Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 l\u00e0m cho bi\u1ec3u \u0111\u1ed3 Excel d\u1ec5 hi\u1ec3u h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam nh\u00e3n d\u1eef li\u1ec7u \u0111\u1ec3 hi\u1ec3n th\u1ecb chi ti\u1ebft v\u1ec1 chu\u1ed7i d\u1eef li\u1ec7u.\u00a0T\u00f9y thu\u1ed9c v\u00e0o n\u01a1i b\u1ea1n mu\u1ed1n t\u1eadp trung s\u1ef1 ch\u00fa \u00fd c\u1ee7a ng\u01b0\u1eddi xem, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam nh\u00e3n cho m\u1ed9t chu\u1ed7i, t\u1ea5t c\u1ea3 c\u00e1c chu\u1ed7i ho\u1eb7c c\u00e1c \u0111i\u1ec3m d\u1eef li\u1ec7u c\u00e1c bi\u1ec7t<\/p>\n<ol>\n<li>Nh\u1ea5p v\u00e0o chu\u1ed7i d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n g\u1eafn nh\u00e3n.\u00a0\u0110\u1ec3 th\u00eam nh\u00e3n v\u00e0o m\u1ed9t \u0111i\u1ec3m d\u1eef li\u1ec7u, h\u00e3y nh\u1ea5p v\u00e0o \u0111i\u1ec3m d\u1eef li\u1ec7u \u0111\u00f3 sau khi ch\u1ecdn chu\u1ed7i.<\/li>\n<\/ol>\n<p><strong><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Select the data series or data point you want to label.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-data-series.png\" alt=\"Select the data series or data point you want to label.\"><\/strong><\/p>\n<ol start=\"2\">\n<li>Nh\u1ea5p v\u00e0o n\u00fat\u00a0<em>Chart Elements <\/em>v\u00e0 ch\u1ecdn\u00a0t\u00f9y ch\u1ecdn\u00a0<em>Data Labels<\/em>.<\/li>\n<\/ol>\n<p>V\u00ed d\u1ee5: \u0111\u00e2y l\u00e0 c\u00e1ch ch\u00fang ta c\u00f3 th\u1ec3 th\u00eam nh\u00e3n v\u00e0o m\u1ed9t trong c\u00e1c chu\u1ed7i d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 Excel n\u00e0y:<\/p>\n<p><strong><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Adding labels to one of the data series in the chart\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-data-labels-1.png\" alt=\"Adding labels to one of the data series in the chart\"><\/strong>\u0110\u1ed1i v\u1edbi c\u00e1c lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ee5 th\u1ec3, ch\u1eb3ng h\u1ea1n nh\u01b0 bi\u1ec3u \u0111\u1ed3 tr\u00f2n, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3\u00a0<strong>choose the labels location<\/strong>.\u00a0H\u00e3y nh\u1ea5p v\u00e0o m\u0169i t\u00ean b\u00ean c\u1ea1nh\u00a0<em>Data Labels,<\/em>v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn b\u1ea1n mu\u1ed1n.\u00a0\u0110\u1ec3 hi\u1ec3n th\u1ecb nh\u00e3n d\u1eef li\u1ec7u b\u00ean trong v\u0103n b\u1ea3n, h\u00e3y nh\u1ea5p v\u00e0o\u00a0<em>Data Callout.<\/em>.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Choosing the labels location\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-data-label-position.png\" alt=\"Choosing the labels location\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thay_doi_du_lieu_duoc_hien_thi_tren_nhan\"><\/span><strong>C\u00e1ch thay \u0111\u1ed5i d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb tr\u00ean nh\u00e3n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 thay \u0111\u1ed5i n\u1ed9i dung \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb tr\u00ean nh\u00e3n d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat\u00a0<em>hart Elements\u00a0 &gt;\u00a0Data Labels &gt; More options\u2026.<\/em>\u00a0Thao t\u00e1c n\u00e0y s\u1ebd hi\u1ec3n th\u1ecb b\u1ea3ng\u00a0<em>Format Data Labels<\/em>\u00a0\u1edf b\u00ean ph\u1ea3i trang t\u00ednh c\u1ee7a b\u1ea1n.\u00a0Chuy\u1ec3n sang\u00a0tab\u00a0<em>Label Options\u00a0<\/em>\u00a0, v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn m\u00e0 b\u1ea1n mu\u1ed1n \u1edf\u00a0<em>Label Contains<\/em>:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/6-2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7627\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-2.bmp\" width=\"600\" height=\"541\" title=\"6-2\"><\/a>N\u1ebfu b\u1ea1n mu\u1ed1n\u00a0<strong>th\u00eam v\u0103n b\u1ea3n c\u1ee7a ri\u00eang b\u1ea1n<\/strong>\u00a0cho m\u1ed9t \u0111i\u1ec3m d\u1eef li\u1ec7u, h\u00e3y nh\u1ea5p v\u00e0o nh\u00e3n cho \u0111i\u1ec3m d\u1eef li\u1ec7u \u0111\u00f3 v\u00e0 sau \u0111\u00f3 nh\u1ea5p l\u1ea1i v\u00e0o \u0111\u00f3 \u0111\u1ec3 ch\u1ec9 ch\u1ecdn m\u1ed9t nh\u00e3n n\u00e0y.\u00a0R\u1ed3i nh\u1eadp v\u00e0o v\u0103n b\u1ea3n thay th\u1ebf:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Adding your own text for some data point\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/img-blog\/type-text-data-label.png\" alt=\"Adding your own text for some data point\"><\/p>\n<p>N\u1ebfu b\u1ea1n th\u1ea5y r\u1eb1ng c\u00f3 qu\u00e1 nhi\u1ec1u nh\u00e3n d\u1eef li\u1ec7u l\u1ed9n x\u1ed9n trong bi\u1ec3u \u0111\u1ed3 Excel c\u1ee7a b\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a b\u1ea5t k\u1ef3 m\u1ed9t ho\u1eb7c t\u1ea5t c\u1ea3 b\u1eb1ng c\u00e1ch nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o nh\u00e3n v\u00e0 ch\u1ecdn\u00a0<em>Delete <\/em>t\u1eeb tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.<\/p>\n<p><strong>M\u1eb9o:<\/strong><\/p>\n<ul>\n<li>\u0110\u1ec3 thay \u0111\u1ed5i\u00a0<strong>v\u1ecb tr\u00ed<\/strong>\u00a0c\u1ee7a m\u1ed9t nh\u00e3n d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh, h\u00e3y nh\u1ea5p v\u00e0o n\u00f3 v\u00e0 k\u00e9o b\u1eb1ng chu\u1ed9t.<\/li>\n<li>\u0110\u1ec3 thay \u0111\u1ed5i\u00a0<strong>ph\u00f4ng ch\u1eef v\u00e0 m\u00e0u n\u1ec1n<\/strong>\u00a0c\u1ee7a nh\u00e3n\u00a0, h\u00e3y ch\u1ecdn ch\u00fang, \u0111i t\u1edbi\u00a0tab\u00a0<em>Format <\/em>tr\u00ean ribbon v\u00e0 ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n.<\/li>\n<\/ul>\n<h2><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Di_chuyen_dinh_dang_hoac_an_chu_thich_cua_bieu_do\"><\/span><strong>Di chuy\u1ec3n, \u0111\u1ecbnh d\u1ea1ng ho\u1eb7c \u1ea9n ch\u00fa th\u00edch c\u1ee7a bi\u1ec3u \u0111\u1ed3:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi b\u1ea1n t\u1ea1o bi\u1ec3u \u0111\u1ed3 trong Excel, ch\u00fa th\u00edch m\u1eb7c \u0111\u1ecbnh xu\u1ea5t hi\u1ec7n \u1edf cu\u1ed1i bi\u1ec3u \u0111\u1ed3 trong Excel 2013 v\u00e0 Excel 2016, v\u00e0 b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3 trong Excel 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n<p>\u0110\u1ec3\u00a0<strong>\u1ea9n<\/strong>\u00a0ch\u00fa th\u00edch nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>Chart Elements<\/em>\u00a0 \u1edf g\u00f3c tr\u00ean b\u00ean ph\u1ea3i c\u1ee7a bi\u1ec3u \u0111\u1ed3 v\u00e0 b\u1ecf ch\u1ecdn\u00a0h\u1ed9p\u00a0<strong>Legend<\/strong>\u00a0.<\/p>\n<p>\u0110\u1ec3\u00a0<strong>di chuy\u1ec3n<\/strong>\u00a0ch\u00fa th\u00edch c\u1ee7a bi\u1ec3u \u0111\u1ed3 sang v\u1ecb tr\u00ed kh\u00e1c, h\u00e3y ch\u1ecdn bi\u1ec3u \u0111\u1ed3, \u0111\u1ebfn\u00a0tab\u00a0<em>Design<\/em>, nh\u1ea5p v\u00e0o\u00a0<em>Add Chart Element\u00a0&gt;\u00a0Legend\u00a0 <\/em>v\u00e0 ch\u1ecdn v\u1ecb tr\u00ed \u0111\u1ec3 di chuy\u1ec3n.\u00a0\u0110\u1ec3\u00a0<strong>lo\u1ea1i b\u1ecf<\/strong>\u00a0c\u00e1c ch\u00fa th\u00edch, ch\u1ecdn\u00a0<em>None<\/em>.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Moving the chart legend\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/move-chart-legend.png\" alt=\"Moving the chart legend\"><\/p>\n<p>M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 di chuy\u1ec3n ch\u00fa th\u00edch l\u00e0 nh\u1ea5p \u0111\u00fap v\u00e0o n\u00f3 trong bi\u1ec3u \u0111\u1ed3, v\u00e0 sau \u0111\u00f3 ch\u1ecdn v\u1ecb tr\u00ed mong mu\u1ed1n tr\u00ean <em>Format Legend<\/em>\u00a0&gt; <em>Legend Options<\/em>.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/7-2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7628\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-2.bmp\" width=\"600\" height=\"283\" title=\"7-2\"><\/a><\/p>\n<p>\u0110\u1ec3 thay \u0111\u1ed5i\u00a0<strong>\u0111\u1ecbnh d\u1ea1ng c\u1ee7a ch\u00fa th\u00edch<\/strong>, b\u1ea1n c\u00f3 nhi\u1ec1u t\u00f9y ch\u1ecdn kh\u00e1c nhau tr\u00ean c\u00e1c\u00a0tab\u00a0<em>Fill &amp; Line<\/em>\u00a0v\u00e0\u00a0<em>Effects<\/em>\u00a0tr\u00ean ng\u0103n\u00a0<em>Format Legend\u00a0<\/em>\u00a0.<\/p>\n<p><strong>Hi\u1ec3n th\u1ecb ho\u1eb7c gi\u1ea5u c\u00e1c \u0111\u01b0\u1eddng l\u01b0\u1edbi tr\u00ean bi\u1ec3u \u0111\u1ed3 Excel:<\/strong><\/p>\n<p>Trong Excel 2013 v\u00e0 2016, b\u1eadt ho\u1eb7c m\u1edf l\u01b0\u1edbi ch\u1ec9 m\u1ea5t v\u00e0i gi\u00e2y.\u00a0\u0110\u01a1n gi\u1ea3n ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>Chart Elements <\/em>v\u00e0 ch\u1ecdn ho\u1eb7c b\u1ecf ch\u1ecdn\u00a0h\u1ed9p\u00a0<strong>Gridlines<\/strong>\u00a0.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/8.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7629\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8.bmp\" width=\"600\" height=\"240\" title=\"8\"><\/a><\/p>\n<p>Microsoft Excel t\u1ef1 \u0111\u1ed9ng x\u00e1c \u0111\u1ecbnh lo\u1ea1i l\u01b0\u1edbi th\u00edch h\u1ee3p nh\u1ea5t cho lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n.\u00a0V\u00ed d\u1ee5, tr\u00ean bi\u1ec3u \u0111\u1ed3 ngang, l\u00e0 c\u00e1c \u0111\u01b0\u1eddng k\u1ebb th\u1eb3ng \u0111\u1ee9ng, trong khi ch\u1ecdn\u00a0<em>t\u00f9y ch\u1ecdn Gridlines<\/em>\u00a0tr\u00ean bi\u1ec3u \u0111\u1ed3 c\u1ed9t s\u1ebd th\u00eam l\u01b0\u1edbi ngang v\u00e0o.<\/p>\n<p>\u0110\u1ec3 thay \u0111\u1ed5i ki\u1ec3u l\u01b0\u1edbi, h\u00e3y nh\u1ea5p v\u00e0o m\u0169i t\u00ean b\u00ean c\u1ea1nh\u00a0<em>Gridlines<\/em>\u00a0, v\u00e0 sau \u0111\u00f3 ch\u1ecdn ki\u1ec3u \u0111\u01b0\u1eddng l\u01b0\u1edbi mong mu\u1ed1n t\u1eeb danh s\u00e1ch ho\u1eb7c nh\u1ea5p v\u00e0o\u00a0<em>More Options\u2026<\/em>\u00a0\u0111\u1ec3 m\u1edf \u00f4 v\u1edbi c\u00e1c\u00a0t\u00f9y ch\u1ecdn\u00a0<em>Gridlines<\/em>\u00a0n\u00e2ng cao\u00a0.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Change the gridlines type\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-chart-gridline-options.png\" alt=\"Change the gridlines type\"><\/p>\n<p><strong>\u1ea8n v\u00e0 ch\u1ec9nh s\u1eeda chu\u1ed7i d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 Excel:<\/strong><\/p>\n<p>Khi c\u00f3 r\u1ea5t nhi\u1ec1u d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c v\u1ebd trong bi\u1ec3u \u0111\u1ed3, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1m th\u1eddi\u00a0<strong>\u1ea9n<\/strong>\u00a0m\u1ed9t s\u1ed1 chu\u1ed7i d\u1eef li\u1ec7u \u0111\u1ec3 b\u1ea1n ch\u1ec9 t\u1eadp trung v\u00e0o nh\u1eefng m\u1ee5c nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p>\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, h\u00e3y nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0\u00a0 \u00a0<strong>Chart Filters<\/strong>\u00a0 \u1edf b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3 v\u00e0 b\u1ecf ch\u1ecdn chu\u1ed7i d\u1eef li\u1ec7u v\u00e0 \/ ho\u1eb7c c\u00e1c lo\u1ea1i m\u00e0 b\u1ea1n mu\u1ed1n \u1ea9n.<\/p>\n<p>\u0110\u1ec3\u00a0<strong>ch\u1ec9nh s\u1eeda chu\u1ed7i d\u1eef li\u1ec7u<\/strong>\u00a0, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat\u00a0<em>Edit Series<\/em>\u00a0\u1edf b\u00ean ph\u1ea3i c\u1ee7a chu\u1ed7i d\u1eef li\u1ec7u.\u00a0N\u00fat\u00a0<em>Edit Series<\/em>\u00a0xu\u1ea5t hi\u1ec7n ngay sau khi b\u1ea1n di chu\u1ed9t tr\u00ean m\u1ed9t chu\u1ed7i d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh.\u00a0\u0110i\u1ec1u n\u00e0y c\u0169ng l\u00e0m n\u1ed5i b\u1eadt c\u00e1c chu\u1ed7i t\u01b0\u01a1ng \u1ee9ng tr\u00ean bi\u1ec3u \u0111\u1ed3, \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y ch\u00ednh x\u00e1c ph\u1ea7n n\u00e0o b\u1ea1n s\u1ebd ch\u1ec9nh s\u1eeda.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Editing a data series in the chart\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hide-edit-data-series.png\" alt=\"Editing a data series in the chart\"><\/p>\n<p><strong>Thay \u0111\u1ed5i lo\u1ea1i bi\u1ec3u \u0111\u1ed3 v\u00e0 phong c\u00e1ch:<\/strong><\/p>\n<p>N\u1ebfu b\u1ea1n th\u1ea5y r\u1eb1ng \u0111\u1ed3 th\u1ecb v\u1eeba \u0111\u01b0\u1ee3c t\u1ea1o kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng thay \u0111\u1ed5i\u00a0<strong>bi\u1ec3u \u0111\u1ed3<\/strong>\u00a0\u0111\u00f3 sang m\u1ed9t s\u1ed1 lo\u1ea1i\u00a0<strong>bi\u1ec3u \u0111\u1ed3<\/strong>\u00a0kh\u00e1c\u00a0.\u00a0\u0110\u01a1n gi\u1ea3n ch\u1ec9 c\u1ea7n ch\u1ecdn bi\u1ec3u \u0111\u1ed3 hi\u1ec7n t\u1ea1i, chuy\u1ec3n sang\u00a0tab\u00a0<em>Insert <\/em>v\u00e0 ch\u1ecdn m\u1ed9t lo\u1ea1i bi\u1ec3u \u0111\u1ed3 kh\u00e1c trong\u00a0nh\u00f3m\u00a0<em>Charts<\/em>.<\/p>\n<p>Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 \u0111\u00e2u trong bi\u1ec3u \u0111\u1ed3 v\u00e0 ch\u1ecdn\u00a0<em>\u00a0Change Chart Type\u2026<\/em>\u00a0t\u1eeb tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Changing the chart type\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-chart-type.png\" alt=\"Changing the chart type\"><br \/>\n\u0110\u1ec3 nhanh ch\u00f3ng\u00a0<strong>thay \u0111\u1ed5i phong c\u00e1ch<\/strong>\u00a0c\u1ee7a bi\u1ec3u \u0111\u1ed3 hi\u1ec7n c\u00f3 trong Excel, h\u00e3y nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0 \u00a0<em>Chart Styles<\/em>\u00a0 \u1edf b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3 v\u00e0 cu\u1ed9n xu\u1ed1ng \u0111\u1ec3 xem c\u00e1c ki\u1ec3u kh\u00e1c.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/9.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7630\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9.bmp\" width=\"600\" height=\"418\" title=\"9\"><\/a><\/p>\n<p>Ho\u1eb7c, ch\u1ecdn m\u1ed9t phong c\u00e1ch kh\u00e1c trong nh\u00f3m <em>Charts Styles<\/em>\u00a0tr\u00ean\u00a0tab\u00a0<em>Design<\/em>:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/10.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7631\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10.bmp\" width=\"600\" height=\"141\" title=\"10\"><\/a><\/p>\n<p><strong>Thay \u0111\u1ed5i m\u00e0u bi\u1ec3u \u0111\u1ed3:<\/strong><\/p>\n<p>\u0110\u1ec3 thay \u0111\u1ed5i <strong>m\u00e0u<\/strong>\u00a0c\u1ee7a bi\u1ec3u \u0111\u1ed3 Excel, h\u00e3y nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>Chart Styles<\/em>, chuy\u1ec3n sang\u00a0tab\u00a0<em>Color <\/em>v\u00e0 ch\u1ecdn m\u1ed9t trong c\u00e1c m\u00e0u c\u00f3 s\u1eb5n.\u00a0L\u1ef1a ch\u1ecdn c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c ph\u1ea3n \u00e1nh ngay l\u1eadp t\u1ee9c trong bi\u1ec3u \u0111\u1ed3, do \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 quy\u1ebft \u0111\u1ecbnh xem n\u00f3 c\u1ea7n \u0111\u1ed5i hay kh\u00f4ng.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/11.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7632\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11.bmp\" width=\"600\" height=\"434\" title=\"11\"><\/a>\u0110\u1ec3\u00a0<strong>ch\u1ecdn m\u00e0u<\/strong>\u00a0cho t\u1eebng chu\u1ed7i d\u1eef li\u1ec7u ri\u00eang l\u1ebb, ch\u1ecdn chu\u1ed7i d\u1eef li\u1ec7u tr\u00ean bi\u1ec3u \u0111\u1ed3, chuy\u1ec3n t\u1edbi\u00a0tab\u00a0<em>Format\u00a0tab &gt;\u00a0Shape Styles<\/em>\u00a0, v\u00e0 nh\u1ea5p v\u00e0o n\u00fat\u00a0<strong>Shape Fill\u00a0<\/strong>\u00a0:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Changing the color of the selected data series\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-chart-change-colors.png\" alt=\"Changing the color of the selected data series\"><\/p>\n<p><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ed5i tr\u1ee5c X v\u00e0 Y trong bi\u1ec3u \u0111\u1ed3:<\/strong><\/p>\n<p>Khi b\u1ea1n t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 trong Excel, \u0111\u1ecbnh h\u01b0\u1edbng c\u1ee7a chu\u1ed7i d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh t\u1ef1 \u0111\u1ed9ng d\u1ef1a tr\u00ean s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t trong bi\u1ec3u \u0111\u1ed3.\u00a0N\u00f3i c\u00e1ch kh\u00e1c, Microsoft Excel v\u1ebd c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t \u0111\u00e3 ch\u1ecdn v\u00ec n\u00f3 xem \u0111\u00f3 l\u00e0 c\u00e1ch t\u1ed1t nh\u1ea5t.<\/p>\n<p>N\u1ebfu b\u1ea1n kh\u00f4ng h\u00e0i l\u00f2ng v\u1edbi c\u00e1ch c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t c\u1ee7a b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c v\u1ebd theo m\u1eb7c \u0111\u1ecbnh, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng trao \u0111\u1ed5i tr\u1ee5c d\u1ecdc v\u00e0 ngang.\u00a0\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, h\u00e3y ch\u1ecdn bi\u1ec3u \u0111\u1ed3, v\u00e0o\u00a0tab\u00a0<em>Design <\/em>v\u00e0 nh\u1ea5p v\u00e0o n\u00fat\u00a0<strong>Switch Row\/Column\u00a0<\/strong>\u00a0.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/12.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7633\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12.bmp\" width=\"600\" height=\"427\" title=\"12\"><\/a><\/p>\n<p><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u1eadt m\u1ed9t bi\u1ec3u \u0111\u1ed3 Excel t\u1eeb tr\u00e1i sang ph\u1ea3i<\/strong><\/p>\n<p>B\u1ea1n \u0111\u00e3 bao gi\u1edd t\u1ea1o m\u1ed9t \u0111\u1ed3 th\u1ecb trong Excel r\u1ed3i th\u1ea5y r\u1eb1ng c\u00e1c \u0111i\u1ec3m d\u1eef li\u1ec7u c\u00f3 th\u1ee9 t\u1ef1 xu\u1ea5t hi\u1ec7n ng\u01b0\u1ee3c tr\u1edf l\u1ea1i m\u1edbi \u0111\u00fang nh\u1eefng g\u00ec b\u1ea1n mong \u0111\u1ee3i?\u00a0\u0110\u1ec3 kh\u1eafc ph\u1ee5c \u0111i\u1ec1u n\u00e0y:<\/p>\n<p>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o tr\u1ee5c ngang trong bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n v\u00e0 ch\u1ecdn\u00a0<strong>Format Axis\u2026 \u2026<\/strong>\u00a0trong tr\u00ecnh \u0111\u01a1n ng\u1eef c\u1ea3nh.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Right click on the horizontal axis and select Format Axis\u2026 in the context menu.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-chart-format-axis.png\" alt=\"Right click on the horizontal axis and select Format Axis\u2026 in the context menu.\"><\/p>\n<p>N\u1ebfu b\u1ea1n ch\u1ecdn t\u1eeb ribbon, h\u00e3y chuy\u1ec3n \u0111\u1ebfn\u00a0tab\u00a0<em>Design <\/em>v\u00e0 nh\u1ea5p v\u00e0o\u00a0<em>Add Chart Element\u00a0&gt;\u00a0Axes\u00a0&gt;\u00a0More Axis Options<\/em><\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Click Add Chart Element &gt; Axes &gt; More Axis Options\u2026 on the ribbon.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/more-axis-options.png\" alt=\"Click Add Chart Element &gt; Axes &gt; More Axis Options\u2026 on the ribbon.\"><\/p>\n<p>D\u00f9 b\u1eb1ng c\u00e1ch n\u00e0o, <em>Format Axis<\/em>\u00a0 s\u1ebd hi\u1ec3n ra, b\u1ea1n \u0111\u1ebfn\u00a0tab\u00a0<em>Axis Options <\/em>v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn\u00a0<strong>Categories in reverse order<\/strong>\u00a0.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Select the Categories in reverse order option to flip the chart.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-flip-chart.png\" alt=\"Select the Categories in reverse order option to flip the chart.\"><\/p>\n<p>Ngo\u00e0i vi\u1ec7c l\u1eadt b\u1ea3ng Excel t\u1eeb tr\u00e1i sang ph\u1ea3i, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u00e1c danh m\u1ee5c, gi\u00e1 tr\u1ecb ho\u1eb7c chu\u1ed7i trong bi\u1ec3u \u0111\u1ed3 c\u1ee7a m\u00ecnh, \u0111\u1ea3o ng\u01b0\u1ee3c th\u1ee9 t\u1ef1 v\u1ebd c\u00e1c gi\u00e1 tr\u1ecb, xoay m\u1ed9t bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n sang b\u1ea5t k\u1ef3 g\u00f3c \u0111\u1ed9 n\u00e0o v\u00e0 h\u01a1n th\u1ebf n\u1eefa.<\/p>\n<p>Nh\u01b0 v\u1eady qua b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang t\u00f4i \u0111\u00e3 chia s\u1ebb cho c\u00e1c b\u1ea1n c\u00e1ch \u0111i\u1ec1u ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 Excel nh\u01b0 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. N\u1ebfu b\u1ea1n c\u00f3 b\u1ea5t k\u1ef3 th\u1eafc m\u1eafc g\u00ec v\u1ec1 b\u00e0i vi\u1ebft c\u00f3 th\u1ec3 comment ngay b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 \u0111\u01b0\u1ee3c c\u00e1c chuy\u00ean gia v\u1ec1 Excel s\u1ebd tr\u1ea3 l\u1eddi m\u1ed9t c\u00e1ch s\u1edbm nh\u1ea5t.<\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong excel, \u1ee9ng d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c\u2026 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. H\u00e3y tham gia ngay t\u1ea1i \u0111\u1ecba ch\u1ec9: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel Online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-90.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2823,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2822","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2822","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=2822"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2822\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2823"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}