{"id":4257,"date":"2024-12-04T17:27:57","date_gmt":"2024-12-04T17:27:57","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich\/"},"modified":"2024-12-04T17:27:57","modified_gmt":"2024-12-04T17:27:57","slug":"huong-dan-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn x\u00e2y d\u1ef1ng bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel, nhi\u1ec1u k\u1ef9 thu\u1eadt hay v\u00e0 h\u1eefu \u00edch."},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y,<a href=\"http:\/\/blog.ezworkapp.com\"><strong> H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n, th\u00eam ho\u1eb7c x\u00f3a ch\u00fa th\u00edch bi\u1ec3u \u0111\u1ed3, \u0111\u1eb7t t\u00ean cho bi\u1ec3u \u0111\u1ed3, hi\u1ec3n th\u1ecb s\u1ed1 ph\u1ea7n tr\u0103m, ph\u00f3ng to ho\u1eb7c xoay bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n.<\/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-6750911bf353f\" 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-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#Cach_tao_bieu_do_hinh_tron_trong_Excel\" title=\"C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel:\">C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel:<\/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-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#Cach_tao_nhieu_kieu_bieu_do_hinh_tron_khac_nhau_trong_Excel\" title=\"C\u00e1ch t\u1ea1o nhi\u1ec1u ki\u1ec3u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n kh\u00e1c nhau trong Excel:\">C\u00e1ch t\u1ea1o nhi\u1ec1u ki\u1ec3u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n kh\u00e1c nhau trong Excel:<\/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-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#Bieu_do_banh_Doughnut\" title=\" Bi\u1ec3u \u0111\u1ed3 b\u00e1nh Doughnut:\"> Bi\u1ec3u \u0111\u1ed3 b\u00e1nh Doughnut:<\/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-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#_Tuy_chon_va_nang_cao_bieu_do_hinh_tron\" title=\"\u00a0T\u00f9y ch\u1ecdn v\u00e0 n\u00e2ng cao bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:\">\u00a0T\u00f9y ch\u1ecdn v\u00e0 n\u00e2ng cao bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:<\/a><\/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-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#Hien_thi_danh_muc_du_lieu_tren_nhan\" title=\"Hi\u1ec3n th\u1ecb danh m\u1ee5c d\u1eef li\u1ec7u tr\u00ean nh\u00e3n:\">Hi\u1ec3n th\u1ecb danh m\u1ee5c d\u1eef li\u1ec7u tr\u00ean nh\u00e3n:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#Cach_hien_thi_ty_le_phan_tram_tren_bieu_do_hinh_tron\" title=\"C\u00e1ch hi\u1ec3n th\u1ecb t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m tr\u00ean bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:\">C\u00e1ch hi\u1ec3n th\u1ecb t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m tr\u00ean bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#Keo_mot_mieng_rieng_le_ra_khoi_bieu_do_hinh_tron\" title=\"K\u00e9o m\u1ed9t mi\u1ebfng ri\u00eang l\u1ebb ra kh\u1ecfi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:\">K\u00e9o m\u1ed9t mi\u1ebfng ri\u00eang l\u1ebb ra kh\u1ecfi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#Xoay_bieu_do_hinh_tron\" title=\"Xoay bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\">Xoay bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#3D_Rotation_cho_bieu_do_hinh_tron_3D\" title=\"3D Rotation cho bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D:\">3D Rotation cho bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#Sap_xep_bieu_do_hinh_tron_theo_kich_thuoc\" title=\"S\u1eafp x\u1ebfp bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n theo k\u00edch th\u01b0\u1edbc:\">S\u1eafp x\u1ebfp bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n theo k\u00edch th\u01b0\u1edbc:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#Thay_doi_mau_bieu_do_hinh_tron\" title=\"Thay \u0111\u1ed5i m\u00e0u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:\">Thay \u0111\u1ed5i m\u00e0u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-xay-dung-bieu-do-hinh-tron-trong-excel-nhieu-ky-thuat-hay-va-huu-ich.html#Dinh_dang_mot_bieu_do_hinh_tron_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng m\u1ed9t bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel:\">\u0110\u1ecbnh d\u1ea1ng m\u1ed9t bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tao_bieu_do_hinh_tron_trong_Excel\"><\/span><strong>C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>1. Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u ngu\u1ed3n \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3.\u00a0<\/strong><\/p>\n<p style=\"text-align: justify\">Kh\u00f4ng gi\u1ed1ng v\u1edbi 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> th\u00f4ng th\u01b0\u1eddng, bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel \u0111\u00f2i h\u1ecfi ngu\u1ed3n d\u1eef li\u1ec7u s\u1eafp x\u1ebfp th\u00e0nh m\u1ed9t c\u1ed9t ho\u1eb7c m\u1ed9t h\u00e0ng. V\u00ec v\u1eady m\u1ed7i bi\u1ec3u \u0111\u1ed3 ch\u1ec9 th\u1ec3 hi\u1ec7n m\u1ed9t lo\u1ea1i d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 th\u00eam t\u00ean danh m\u1ee5c (<strong>category<\/strong> <strong>names<\/strong>)<strong>\u00a0<\/strong>v\u00e0o c\u1ed9t ho\u1eb7c h\u00e0ng v\u00e0 n\u00ean l\u00e0<span lang=\"vi\">\u00a0c\u1ed9t ho\u1eb7c h\u00e0ng \u0111\u1ea7u ti\u00ean trong v\u00f9ng l\u1ef1a ch\u1ecdn. T\u00ean danh m\u1ee5c s\u1ebd xu\u1ea5t hi\u1ec7n trong ch\u00fa th\u00edch bi\u1ec3u \u0111\u1ed3 ho\u1eb7c t\u00ean bi\u1ec3u \u0111\u1ed3.<\/span><\/p>\n<p style=\"text-align: justify\"><span lang=\"vi\"> N\u00f3i chung, m\u1ed9t bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n \u0111\u1ea7y \u0111\u1ee7 bao g\u1ed3m:<\/span><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li><span lang=\"vi\">Ch\u1ec9 m\u1ed9t lo\u1ea1i d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c v\u1ebd tr\u00ean bi\u1ec3u \u0111\u1ed3. <\/span><\/li>\n<li><span lang=\"vi\">T\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u l\u1edbn h\u01a1n kh\u00f4ng. <\/span><\/li>\n<li><span lang=\"vi\">Kh\u00f4ng c\u00f3 h\u00e0ng r\u1ed7ng ho\u1eb7c c\u1ed9t r\u1ed7ng. <\/span><\/li>\n<li><span lang=\"vi\">Kh\u00f4ng c\u00f3 nhi\u1ec1u h\u01a1n 7 \u2013 9 d\u1eef li\u1ec7u th\u00e0nh ph\u1ea7n, b\u1edfi v\u00ec qu\u00e1 nhi\u1ec1u ph\u1ea7n s\u1ebd khi\u1ebfn bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n kh\u00f3 hi\u1ec3u.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span lang=\"vi\">\u0110\u1ed1i v\u1edbi h\u01b0\u1edbng d\u1eabn n\u00e0y, ch\u00fang t\u00f4i s\u1ebd t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\u00a0<\/span>t\u1eeb d\u1eef li\u1ec7u sau:<\/p>\n<figure style=\"width: 198px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u ngu\u1ed3n \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pie-chart-source-data.png\" alt=\"Source data for an Excel pie chart\" width=\"198\" height=\"160\"><figcaption class=\"wp-caption-text\">Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u ngu\u1ed3n \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3<\/figcaption><\/figure>\n<p><strong>2. Ch\u00e8n bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n v\u00e0o trang t\u00ednh hi\u1ec7n t\u1ea1i<\/strong><\/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-342.gif\" title=\"ex101_92019-nho-342\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ngay sau kh\u1ecb b\u1ea1n s\u1eafp x\u1ebfp ngu\u1ed3n d\u1eef li\u1ec7u, ch\u1ecdn n\u00f3, \u0111i \u0111\u1ebfn th\u1ebb\u00a0<em><strong>Insert\u00a0<\/strong><\/em> v\u00e0 ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 b\u1ea1n mu\u1ed1n (ch\u00fang t\u00f4i s\u1ebd ph\u00e2n lo\u1ea1i bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n sau).<\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang t\u00f4i t\u1ea1p ki\u1ec3u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 2D th\u00f4ng th\u01b0\u1eddng nh\u1ea5t:<\/p>\n<p>\u00a0<\/p>\n<p><strong>Ch\u00fa \u00fd.\u00a0<\/strong>Ch\u00e8n ti\u00eau \u0111\u1ec1 c\u1ed9t ho\u1eb7c h\u00e0ng n\u1ebfu b\u1ea1n mu\u1ed1n ch\u00fang t\u1ef1 \u0111\u1ed9ng xu\u1ea5t hi\u1ec7n trong bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n.<\/p>\n<p><strong>3. Ch\u1ecdn ki\u1ec3u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n (t\u00f9y ch\u1ecdn)<\/strong><\/p>\n<p>Khi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n v\u1eeba ch\u00e8n v\u00e0o trang t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 \u0111i \u0111\u1ebfn nh\u00f3m\u00a0<em><strong>Design<\/strong><\/em>, th\u1eed nhi\u1ec1u ki\u1ec3u bi\u1ec3u \u0111\u1ed3 kh\u00e1c nhau trong nh\u00f3m\u00a0<em><strong>Charts<\/strong><\/em>\u00a0v\u00e0 ch\u1ecdn ki\u1ec3u ph\u00f9 h\u1ee3p nh\u1ea5t v\u1edbi d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/p>\n<figure id=\"attachment_4766\" aria-describedby=\"caption-attachment-4766\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4766 size-full\" title=\"Ch\u1ecdn ki\u1ec3u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-pie-chart-styles.png\" alt=\"Ch\u1ecdn ki\u1ec3u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" width=\"600\" height=\"134\"><figcaption id=\"caption-attachment-4766\" class=\"wp-caption-text\">Ch\u1ecdn ki\u1ec3u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Ki\u1ec3u bi\u1ec3u \u0111\u1ed3 m\u1eb7c \u0111\u1ecbnh (ki\u1ec3u 1) trong Excel 2013 \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o trang t\u00ednh nh\u01b0 sau:<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<figure style=\"width: 397px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Ch\u1ecdn ki\u1ec3u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-pie-graph.png\" alt=\"Ch\u1ecdn ki\u1ec3u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 1\" width=\"397\" height=\"298\"><figcaption class=\"wp-caption-text\">Ch\u1ecdn ki\u1ec3u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 1<\/figcaption><\/figure>\n<p>B\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam VIDEO h\u01b0\u1edbng d\u1eabn V\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n nh\u00e9!<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/ozbe4JLXRaY?list=PLALCv46JuKEIb30S1S2jPgHLQnUvPpmsz&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tao_nhieu_kieu_bieu_do_hinh_tron_khac_nhau_trong_Excel\"><\/span><strong>C\u00e1ch t\u1ea1o nhi\u1ec1u ki\u1ec3u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n kh\u00e1c nhau trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi b\u1ea1n t\u1ea1o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t trong nh\u1eefng ki\u1ec3u d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><strong>Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 2D<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 ti\u00eau chu\u1ea9n v\u00e0 l\u00e0 d\u1ea1ng ph\u1ed5 bi\u1ebfn nh\u1ea5t. V\u00e0o tab\u00a0<em><strong>Insert\u00a0<\/strong>&gt;\u00a0<strong>Charts<\/strong>.<\/em><\/p>\n<p style=\"text-align: justify\"><strong>Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D<\/strong><\/p>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D t\u01b0\u01a1ng t\u1ef1 2D, nh\u01b0ng n\u00f3 s\u1ebd hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng kh\u1ed1i 3 chi\u1ec1u.<\/p>\n<figure style=\"width: 436px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-3d-pie-chart.png\" alt=\"Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D\" width=\"436\" height=\"239\"><figcaption class=\"wp-caption-text\">Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Mi\u1ebfng c\u1ee7a bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n (Pie of Pie chart) v\u00e0 thanh c\u1ee7a bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n (Bar of Pie chart)<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n c\u00f3 qu\u00e1 nhi\u1ec1u ph\u1ea7n nh\u1ecf, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n t\u1ea1o\u00a0<strong>Pie of Pie chart<\/strong>. Ph\u1ea7n n\u00e0y \u0111\u01b0\u1ee3c g\u1ed9p t\u1eeb nhi\u1ec1u ph\u1ea7n nh\u1ecf h\u01a1n\u00a0v\u00e0 s\u1ebd hi\u1ec3n th\u1ecb ph\u1ea7n th\u00eam b\u00ean ngo\u00e0i.<\/p>\n<figure style=\"width: 581px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Mi\u1ebfng c\u1ee7a bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-pie-of-pie-chart.png\" alt=\"Pie of Pie chart\" width=\"581\" height=\"155\"><figcaption class=\"wp-caption-text\">Mi\u1ebfng c\u1ee7a bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Bar of Pie chart\u00a0<\/strong>t\u01b0\u01a1ng t\u1ef1 nh\u01b0\u00a0<strong>Pie of Pie chart,\u00a0<\/strong>ngo\u1ea1i tr\u1eeb ph\u1ea7n \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb th\u00e0nh c\u1ed9t (thay v\u00ec th\u00e0nh h\u00ecnh tr\u00f2n).<\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n t\u1ea1o <strong>Bar of Pie chart <\/strong>ho\u1eb7c\u00a0<strong>Pie of Pie chart<\/strong>, ba lo\u1ea1i d\u1eef li\u1ec7u cu\u1ed1i c\u00f9ng\u00a0\u0111\u01b0\u1ee3c di chuy\u1ec3n \u0111\u1ebfn bi\u1ec3u \u0111\u1ed3 th\u1ee9 hai theo m\u1eb7c \u0111\u1ecbnh (th\u1eadm ch\u00ed ngay khi \u0111\u00f3 l\u00e0 danh m\u1ee5c chi\u1ebfm t\u1ef7 tr\u1ecdng l\u1edbn nh\u1ea5t). B\u1edfi v\u00ec m\u1eb7c \u0111\u1ecbnh kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng t\u1ed1t, b\u1ea1n c\u00f3 th\u1ec3:<\/p>\n<ul style=\"list-style-type: circle\">\n<li style=\"text-align: justify\">S\u1eafp x\u1ebfp d\u1eef li\u1ec7u ngu\u1ed3n trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n \u0111\u1ec3 c\u00e1c danh m\u1ee5c chi\u1ebfm t\u1ef7 tr\u1ecdng th\u1ea5p nh\u1ea5t s\u1ebd \u0111\u01b0\u1ee3c gi\u1ea3i th\u00edch th\u00eam \u1edf bi\u1ec3u \u0111\u1ed3 ph\u1ee5.<\/li>\n<li style=\"text-align: justify\">Ch\u1ecdn lo\u1ea1i d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3 ph\u1ee5.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>Ch\u1ecdn lo\u1ea1i d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3 ph\u1ee5<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ef1 ch\u1ecdn c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u t\u1ea1o th\u00e0nh bi\u1ec3u \u0111\u1ed3 ph\u1ee5, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p style=\"text-align: justify\">1. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 ph\u1ea7n n\u00e0o trong bi\u1ec3u \u0111\u1ed3 v\u00e0 ch\u1ecdn <em><strong>Format Data Series\u2026\u00a0<\/strong><\/em>t\u1eeb danh m\u1ee5c.<\/p>\n<p style=\"text-align: justify\">2. Tr\u00ean b\u1ea3ng <em><strong>Format Data Series<\/strong><\/em>, trong <em><strong>Series Options<\/strong><\/em>,\u00a0ch\u1ecdn m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn sau trong danh s\u00e1ch <em><strong>Split Series By<\/strong><\/em>:<\/p>\n<ul style=\"list-style-type: circle\">\n<li style=\"text-align: justify\"><em><strong>Position<\/strong><\/em>\u00a0\u2013 cho ph\u00e9p b\u1ea1n ch\u1ecdn s\u1ed1 danh m\u1ee5c \u0111\u01b0\u1ee3c t\u1ea1o th\u00eam \u1edf bi\u1ec3u \u0111\u1ed3 ph\u1ee5.<\/li>\n<li style=\"text-align: justify\"><em><strong>Value<\/strong><\/em>\u00a0\u2013 cho ph\u00e9p b\u1ea1n ch\u1ec9 \u0111\u1ecbnh gi\u00e1 tr\u1ecb t\u1ed1i thi\u1ec3u \u0111\u01b0\u1ee3c chuy\u1ec3n sang bi\u1ec3u \u0111\u1ed3 b\u1ed5 sung.<\/li>\n<li style=\"text-align: justify\"><em><strong>Percentage value<\/strong><\/em>\u00a0\u2013 n\u00f3 gi\u1ed1ng <em><strong>Value<\/strong><\/em>, nh\u01b0ng \u1edf \u0111\u00e2y b\u1ea1n c\u1ea7n ch\u1ec9 \u0111\u1ecbnh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m t\u1ed1i thi\u1ec3u.<\/li>\n<li style=\"text-align: justify\"><em><strong>Custom<\/strong><\/em>\u00a0\u2013 cho ph\u00e9p b\u1ea1n t\u1ef1 ch\u1ecdn b\u1ea5t k\u1ef3 ph\u1ea7n n\u00e0o tr\u00ean bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n, sau \u0111\u00f3 ch\u1ec9 \u0111\u1ecbnh \u0111\u1eb7t n\u00f3 v\u00e0o bi\u1ec3u \u0111\u1ed3 ch\u00ednh ho\u1eb7c ph\u1ee5.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p, vi\u1ec7c \u0111\u1eb7t ng\u01b0\u1ee1ng t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m l\u00e0 s\u1ef1 l\u1ef1a ch\u1ecdn h\u1ee3p l\u00fd nh\u1ea5t, nh\u01b0ng m\u1ecdi th\u1ee9 t\u00f9y v\u00e0o d\u1eef li\u1ec7u ngu\u1ed3n v\u00e0 s\u1edf th\u00edch c\u00e1 nh\u00e2n c\u1ee7a b\u1ea1n. H\u00ecnh sau th\u1ec3 hi\u1ec7n s\u1ef1 chia t\u00e1ch chu\u1ed7i d\u1eef li\u1ec7u theo <em><strong>Percentage value<\/strong><\/em>:<\/p>\n<figure id=\"attachment_4772\" aria-describedby=\"caption-attachment-4772\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4772 size-full\" title=\"Ch\u1ecdn lo\u1ea1i d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3 ph\u1ee5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/split-series-by.png\" alt=\"Ch\u1ecdn lo\u1ea1i d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3 ph\u1ee5\" width=\"600\" height=\"292\"><figcaption id=\"caption-attachment-4772\" class=\"wp-caption-text\">Ch\u1ecdn lo\u1ea1i d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3 ph\u1ee5<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea5u h\u00ecnh c\u00e1c c\u00e0i \u0111\u1eb7t sau:<\/p>\n<ul style=\"list-style-type: circle\">\n<li style=\"text-align: justify\">Thay \u0111\u1ed5i <strong>\u0111\u1ed9 r\u1ed9ng cho m\u1ed7i ph\u1ea7n bi\u1ec3u \u0111\u1ed3<\/strong>. <strong>Gap Width<\/strong> \u0111\u1ea1i di\u1ec7n cho \u0111\u1ed9 r\u1ed9ng c\u1ee7a m\u1ed9t ph\u1ea7n bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n t\u01b0\u01a1ng \u1ee9ng v\u1edbi 1% trong bi\u1ec3u \u0111\u1ed3 ph\u1ee5. \u0110\u1ec3 thay \u0111\u1ed5i \u0111\u1ed9 r\u1ed9ng, k\u00e9o thanh tr\u01b0\u1ee3t ho\u1eb7c g\u00f5 con s\u1ed1 ch\u00ednh x\u00e1c v\u00e0o h\u1ed9p t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m.<\/li>\n<li style=\"text-align: justify\">Thay \u0111\u1ed5i <strong>k\u00edch th\u01b0\u1edbc c\u1ee7a bi\u1ec3u \u0111\u1ed3 ph\u1ee5. <\/strong>Nh\u1eefng con s\u1ed1 trong h\u1ed9p\u00a0<em><strong>Second Plot Size\u00a0<\/strong><\/em>\u0111\u1ea1i di\u1ec7n cho t\u1ef7 l\u1ec7 trong bi\u1ec3u \u0111\u1ed3 ph\u1ee5 t\u01b0\u01a1ng \u1ee9ng v\u1edbi 1% trong bi\u1ec3u \u0111\u1ed3 ch\u00ednh. K\u00e9o thanh tr\u01b0\u1ee3t \u0111\u1ec3 t\u0103ng ho\u1eb7c gi\u1ea3m k\u00edch th\u01b0\u1edbc bi\u1ec3u \u0111\u1ed3 ph\u1ee5, ho\u1eb7c g\u00f5 con s\u1ed1 ch\u00ednh x\u00e1c v\u00e0o h\u1ed9p ph\u1ea7n tr\u0103m.<\/li>\n<\/ul>\n<blockquote>\n<p>Xem th\u00eam:\u00a0H\u1ecdc excel n\u00e2ng cao online<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Bieu_do_banh_Doughnut\"><\/span><strong> Bi\u1ec3u \u0111\u1ed3 b\u00e1nh Doughnut:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u h\u01a1n m\u1ed9t chu\u1ed7i d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong>bi\u1ec3u \u0111\u1ed3 Doughnut<\/strong> thay cho bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n. Tuy nhi\u00ean, trong bi\u1ec3u \u0111\u1ed3 Doughnut, th\u1eadt kh\u00f3 \u0111\u1ec3 \u01b0\u1edbc t\u00ednh t\u1ef7 l\u1ec7 gi\u1eefa c\u00e1c ph\u1ea7n t\u1eed trong c\u00e1c chu\u1ed7i kh\u00e1c nhau, v\u00e0 \u0111\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao n\u00ean s\u1eed d\u1ee5ng c\u00e1c lo\u1ea1i bi\u1ec3u \u0111\u1ed3 kh\u00e1c, ch\u1eb3ng h\u1ea1n\u00a0bi\u1ec3u \u0111\u1ed3 thanh (<strong>bar chart<\/strong>) ho\u1eb7c bi\u1ec3u \u0111\u1ed3 c\u1ed9t (<strong>column chart<\/strong>).<\/p>\n<figure style=\"width: 439px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Bi\u1ec3u \u0111\u1ed3 b\u00e1nh Doughnut\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-doughnut-chart.png\" alt=\"Bi\u1ec3u \u0111\u1ed3 b\u00e1nh Doughnut\" width=\"439\" height=\"233\"><figcaption class=\"wp-caption-text\">Bi\u1ec3u \u0111\u1ed3 b\u00e1nh Doughnut<\/figcaption><\/figure>\n<p><strong>Thay \u0111\u1ed5i k\u00edch thu\u1edbc trong bi\u1ec3u \u0111\u1ed3 Doughnut<\/strong><\/p>\n<p><span lang=\"vi\"> 1. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 chu\u1ed7i d\u1eef li\u1ec7u n\u00e0o trong bi\u1ec3u \u0111\u1ed3 Doughnut, ch\u1ecdn t\u00f9y ch\u1ecdn\u00a0<em><strong>Format Data<\/strong> <strong>Series.<\/strong><\/em><\/span><\/p>\n<figure style=\"width: 545px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Thay \u0111\u1ed5i k\u00edch thu\u1edbc trong bi\u1ec3u \u0111\u1ed3 Doughnut\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/resize-doughnut-chart-hole.png\" alt=\"Changing the hole size in a doughnut chart\" width=\"545\" height=\"264\"><figcaption class=\"wp-caption-text\">Thay \u0111\u1ed5i k\u00edch thu\u1edbc trong bi\u1ec3u \u0111\u1ed3 Doughnut<\/figcaption><\/figure>\n<p>2. Trong b\u1ea3ng\u00a0<em><strong>Format Data<\/strong> <strong>Series<\/strong><\/em>, \u0111\u1ebfn th\u1ebb t\u00f9y ch\u1ecdn\u00a0<em><strong>Series Options<\/strong><\/em>,\u00a0<span lang=\"vi\">thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc l\u1ed7 b\u1eb1ng c\u00e1ch di chuy\u1ec3n thanh tr\u01b0\u1ee3t b\u00ean d\u01b0\u1edbi <em><strong>Doughnut Hole Size\u00a0<\/strong><\/em>ho\u1eb7c\u00a0nh\u1eadp ph\u1ea7n tr\u0103m tr\u1ef1c ti\u1ebfp v\u00e0o \u00f4 s\u1ed1.<\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"_Tuy_chon_va_nang_cao_bieu_do_hinh_tron\"><\/span>\u00a0<strong>T\u00f9y ch\u1ecdn v\u00e0 n\u00e2ng cao bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>C\u00e1ch th\u00eam nh\u00e3n cho d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/strong><\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n n\u00e0y, ch\u00fang ta s\u1ebd th\u00eam nh\u00e3n cho t\u1ea5t c\u1ea3 \u0111i\u1ec3m d\u1eef li\u1ec7u. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat\u00a0<em><strong>Chart Elements\u00a0<\/strong><\/em>\u1edf g\u00f3c tr\u00ean b\u00ean ph\u1ea3i c\u1ee7a bi\u1ec3u \u0111\u1ed3 v\u00e0 ch\u1ecdn\u00a0<em><strong>Data Labels<\/strong>.<\/em><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 mu\u1ed1n thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c nh\u00e3n n\u00e0y b\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o m\u0169i t\u00ean k\u1ebf b\u00ean\u00a0<em><strong>Data Labels<\/strong><\/em>. So v\u1edbi c\u00e1c d\u1ea1ng bi\u1ec3u \u0111\u1ed3 kh\u00e1c, bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n cung c\u1ea5p nhi\u1ec1u l\u1ef1a ch\u1ecdn nh\u1ea5t v\u1ec1 v\u1ecb tr\u00ed ti\u00eau \u0111\u1ec1:<\/p>\n<figure id=\"attachment_4833\" aria-describedby=\"caption-attachment-4833\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4833 size-full\" title=\"C\u00e1ch th\u00eam nh\u00e3n cho d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pie-chart-data-labels.png\" alt=\"C\u00e1ch th\u00eam nh\u00e3n cho d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" width=\"600\" height=\"274\"><figcaption id=\"caption-attachment-4833\" class=\"wp-caption-text\">C\u00e1ch th\u00eam nh\u00e3n cho d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb nh\u00e3n d\u1eef li\u1ec7u b\u00ean ngo\u00e0i h\u00ecnh tr\u00f2n, ch\u1ecdn\u00a0<em><strong>Data Callout<\/strong><\/em>:<\/p>\n<figure id=\"attachment_4834\" aria-describedby=\"caption-attachment-4834\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4834 size-full\" title=\"C\u00e1ch th\u00eam nh\u00e3n cho d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-chart-data-callout.png\" alt=\"C\u00e1ch th\u00eam nh\u00e3n cho d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" width=\"600\" height=\"285\"><figcaption id=\"caption-attachment-4834\" class=\"wp-caption-text\">C\u00e1ch th\u00eam nh\u00e3n cho d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>N\u1ebfu b\u1ea1n \u0111\u1eb7t nh\u00e3n b\u00ean trong mi\u1ebfng c\u1eaft bi\u1ec3u \u0111\u1ed3, m\u00e0u \u0111en m\u1eb7c \u0111\u1ecbnh c\u1ee7a nh\u00e3n c\u00f3 th\u1ec3 kh\u00f3 \u0111\u1ecdc tr\u00ean n\u1ec1n t\u1ed1i nh\u01b0 m\u00e0u xanh \u0111\u1eadm trong v\u00ed d\u1ee5. T\u1ed1t nh\u1ea5t, b\u1ea1n h\u00e3y thay \u0111\u1ed5i m\u00e0u nh\u00e3n (nh\u1ea5p v\u00e0o nh\u00e3n, \u0111\u1ebfn th\u1ebb\u00a0<em><strong>Format\u00a0<\/strong>&gt;\u00a0<strong>Text Fill<\/strong><\/em>); ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i m\u00e0u c\u1ee7a t\u1eebng mi\u1ebfng c\u1eaft bi\u1ec3u \u0111\u1ed3.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Hien_thi_danh_muc_du_lieu_tren_nhan\"><\/span><strong>Hi\u1ec3n th\u1ecb danh m\u1ee5c d\u1eef li\u1ec7u tr\u00ean nh\u00e3n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n c\u1ee7a b\u1ea1n c\u00f3 nhi\u1ec1u h\u01a1n ba l\u00e1t c\u1eaft, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n \u0111\u1eb7t t\u00ean tr\u1ef1c ti\u1ebfp thay v\u00ec v\u1eeba ph\u1ea3i xem ch\u00fa th\u00edch v\u1eeba ph\u1ea3i \u0111\u1ed1i chi\u1ebfu v\u1edbi bi\u1ec3u \u0111\u1ed3.<\/p>\n<p style=\"text-align: justify\">C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y l\u00e0 ch\u1ecdn m\u1ed9t trong nh\u1eefng c\u00e1ch ch\u00fa th\u00edch l\u1ea1i bi\u1ec3u \u0111\u1ed3 trong th\u1ebb\u00a0<em><strong>Design\u00a0<\/strong>&gt;\u00a0<strong>Styles\u00a0<\/strong>&gt;\u00a0<strong>Quick Layout<\/strong>.\u00a0<\/em>Layout 1 v\u00e0 4 l\u00e0 nh\u1eefng c\u00e1ch c\u00f3 nh\u00e3n d\u1eef li\u1ec7u.<\/p>\n<figure style=\"width: 457px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Hi\u1ec3n th\u1ecb danh m\u1ee5c d\u1eef li\u1ec7u tr\u00ean nh\u00e3n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pie-chart-label-slices.png\" alt=\"Choosing one of the predefined pie chart layouts\" width=\"457\" height=\"492\"><figcaption class=\"wp-caption-text\">Hi\u1ec3n th\u1ecb danh m\u1ee5c d\u1eef li\u1ec7u tr\u00ean nh\u00e3n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f3 nhi\u1ec1u l\u1ef1a ch\u1ecdn h\u01a1n, b\u1ea5m v\u00e0o n\u00fat\u00a0<em><strong>Chart Elements\u00a0<\/strong><\/em>(d\u1ea5u ch\u00e9o m\u00e0u xanh l\u00e1) \u1edf g\u00f3c tr\u00ean b\u00ean ph\u1ea3i c\u1ee7a bi\u1ec3u \u0111\u1ed3, nh\u1ea5p v\u00e0o m\u0169i t\u00ean k\u1ebf b\u00ean\u00a0<em><strong>Data Labels<\/strong><\/em>, v\u00e0 ch\u1ecdn\u00a0<em><strong>More options\u2026<\/strong><\/em> B\u1ea3ng\u00a0<em><strong>Format Data Labels\u00a0<\/strong><\/em>s\u1ebd m\u1edf ra \u01a1 b\u00ean ph\u1ea3i trang t\u00ednh. M\u1edf th\u1ebb\u00a0<em><strong>Label Options<\/strong><\/em>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn\u00a0<em><strong>Category Name<\/strong><\/em>.<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng t\u00f9y ch\u1ecdn sau:<\/p>\n<ul style=\"list-style-type: circle\">\n<li style=\"text-align: justify\">Du\u1edbi\u00a0<em><strong>Label Contains<\/strong><\/em>, ch\u1ecdn d\u1eef li\u1ec7u \u0111u\u1ee3c hi\u1ec3n th\u1ecb tr\u00ean nh\u00e3n (t\u00ean danh m\u1ee5c\u00a0<em><strong>Category Name<\/strong>\u00a0<\/em>v\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m\u00a0<em><strong>Value\u00a0<\/strong><\/em>trong v\u00ed d\u1ee5)<\/li>\n<li style=\"text-align: justify\">Trong danh s\u00e1ch\u00a0<em><strong>Separator<\/strong><\/em>, ch\u1ecdn c\u00e1ch t\u00e1ch d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb tr\u00ean nh\u00e3n (sang d\u00f2ng m\u1edbi\u00a0<em><strong>New Line\u00a0<\/strong><\/em>trong v\u00ed d\u1ee5)<\/li>\n<li style=\"text-align: justify\">Du\u1edbi\u00a0<em><strong>Label Position<\/strong><\/em>, ch\u1ecdn n\u01a1i \u0111\u1eb7t nh\u00e3n d\u1eef li\u1ec7u (<em><strong>Outside End\u00a0<\/strong><\/em>trong v\u00ed d\u1ee5)<\/li>\n<\/ul>\n<figure style=\"width: 594px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Hi\u1ec3n th\u1ecb danh m\u1ee5c d\u1eef li\u1ec7u tr\u00ean nh\u00e3n 2\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/customized-pie-chart-labels.png\" alt=\"Hi\u1ec3n th\u1ecb danh m\u1ee5c d\u1eef li\u1ec7u tr\u00ean nh\u00e3n 2\" width=\"594\" height=\"504\"><figcaption class=\"wp-caption-text\">Hi\u1ec3n th\u1ecb danh m\u1ee5c d\u1eef li\u1ec7u tr\u00ean nh\u00e3n 2<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span lang=\"vi\"><strong>Ghi ch\u00fa.\u00a0<\/strong>B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 th\u00eam nh\u00e3n d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n, b\u1ea3ng ch\u00fa th\u00edch tr\u1edf n\u00ean d\u01b0 th\u1eeba v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a n\u00f3 b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o n\u00fat <em><strong>Chart Elements<\/strong><\/em>,\u00a0b\u1ecf ch\u1ecdn h\u1ed9p <em><strong>Legend<\/strong><\/em>.<\/span><\/p>\n<figure style=\"width: 190px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Chart Elements\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-chart-legend.png\" alt=\"Chart Elements\" width=\"190\" height=\"109\"><figcaption class=\"wp-caption-text\">Chart Elements<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_hien_thi_ty_le_phan_tram_tren_bieu_do_hinh_tron\"><\/span><strong>C\u00e1ch hi\u1ec3n th\u1ecb t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m tr\u00ean bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi d\u1eef li\u1ec7u ngu\u1ed3n \u0111\u01b0\u1ee3c v\u1ebd tr\u00ean bi\u1ec3u \u0111\u1ed3 l\u00e0 <strong>ph\u1ea7n tr\u0103m<\/strong>, <em><strong>%<\/strong><\/em> s\u1ebd t\u1ef1 \u0111\u1ed9ng xu\u1ea5t hi\u1ec7n tr\u00ean c\u00e1c nh\u00e3n d\u1eef li\u1ec7u ngay khi b\u1ea1n b\u1eadt t\u00f9y ch\u1ecdn <em><strong>Data Labels<\/strong><\/em>\u00a0trong <em><strong>Chart Elements<\/strong><\/em>,\u00a0ho\u1eb7c ch\u1ecdn t\u00f9y ch\u1ecdn <em><strong>Value\u00a0<\/strong><\/em>trong b\u1ea3ng\u00a0<em><strong>Format Data Labels<\/strong><\/em>, nh\u01b0 \u0111\u01b0\u1ee3c minh h\u1ecda trong bi\u1ec3u \u0111\u1ed3\u00a0tr\u00ean.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu d\u1eef li\u1ec7u ngu\u1ed3n c\u1ee7a b\u1ea1n l\u00e0 <strong>s\u1ed1<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh \u00a0d\u1ea1ng nh\u00e3n hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb g\u1ed1c ho\u1eb7c ho\u1eb7c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m, ho\u1eb7c c\u1ea3 hai.<\/p>\n<ul style=\"list-style-type: circle\">\n<li style=\"text-align: justify\">Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 ph\u1ea7n n\u00e0o tr\u00ean bi\u1ec3u \u0111\u1ed3, ch\u1ecdn <em><strong>Format Data Labels<\/strong><\/em>.<\/li>\n<li style=\"text-align: justify\">Trong b\u1ea3ng <em><strong>Format Data Labels<\/strong><\/em><em>,<\/em>\u00a0\u0111\u00e1nh d\u1ea5u ch\u1ecdn\u00a0<em><strong>Value<\/strong><\/em>\u00a0ho\u1eb7c <em><strong>Percentage<\/strong><\/em> ho\u1eb7c c\u1ea3 hai nh\u01b0 trong v\u00ed d\u1ee5.\u00a0Ph\u1ea7n tr\u0103m s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh t\u1ef1 \u0111\u1ed9ng, t\u01b0\u01a1ng \u1ee9ng v\u1edbi to\u00e0n b\u1ed9 h\u00ecnh tr\u00f2n l\u00e0 100%.<\/li>\n<\/ul>\n<figure style=\"width: 585px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch hi\u1ec3n th\u1ecb t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m tr\u00ean bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pie-chart-percentage-value.png\" alt=\"Excel pie chart percentage and value\" width=\"585\" height=\"304\"><figcaption class=\"wp-caption-text\">C\u00e1ch hi\u1ec3n th\u1ecb t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m tr\u00ean bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>T\u00e1ch r\u1eddi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n ho\u1eb7c t\u00e1ch t\u1eebng ph\u1ea7n c\u1ee7a bi\u1ec3u \u0111\u1ed3:<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 nh\u1ea5n m\u1ea1nh t\u1eebng ph\u1ea7n ri\u00eang l\u1ebb c\u1ee7a bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n, b\u1ea1n c\u00f3 th\u1ec3 t\u00e1ch r\u1eddi<strong>\u00a0<\/strong>n\u00f3, v\u00ed d\u1ee5 t\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n ra ri\u00eang bi\u1ec7t. Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n m\u1ea1nh b\u1eb1ng c\u00e1ch k\u00e9o m\u1ed9t ph\u1ea7n ra kh\u1ecfi ph\u1ea7n c\u00f2n l\u1ea1i\u00a0c\u1ee7a bi\u1ec3u \u0111\u1ed3.<\/p>\n<figure id=\"attachment_4836\" aria-describedby=\"caption-attachment-4836\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4836 size-full\" title=\"T\u00e1ch r\u1eddi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n ho\u1eb7c t\u00e1ch t\u1eebng ph\u1ea7n c\u1ee7a bi\u1ec3u \u0111\u1ed3\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-exploded-pie-chart.png\" alt=\"T\u00e1ch r\u1eddi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n ho\u1eb7c t\u00e1ch t\u1eebng ph\u1ea7n c\u1ee7a bi\u1ec3u \u0111\u1ed3\" width=\"600\" height=\"181\"><figcaption id=\"caption-attachment-4836\" class=\"wp-caption-text\">T\u00e1ch r\u1eddi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n ho\u1eb7c t\u00e1ch t\u1eebng ph\u1ea7n c\u1ee7a bi\u1ec3u \u0111\u1ed3<\/figcaption><\/figure>\n<p><strong>T\u00e1ch r\u1eddi to\u00e0n b\u1ed9 bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 t\u00e1ch l\u00e0 nh\u1ea5p v\u00e0o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n \u0111\u1ec3 t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n \u0111\u01b0\u1ee3c ch\u1ecdn, k\u00e9o ch\u00fang ra kh\u1ecfi trung t\u00e2m bi\u1ec3u \u0111\u1ed3 b\u1eb1ng chu\u1ed9t.<\/p>\n<figure id=\"attachment_4841\" aria-describedby=\"caption-attachment-4841\" style=\"width: 467px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-114.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4841\" title=\"T\u00e1ch r\u1eddi to\u00e0n b\u1ed9 bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-114.bmp\" alt=\"T\u00e1ch r\u1eddi to\u00e0n b\u1ed9 bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" width=\"467\" height=\"318\"><\/a><figcaption id=\"caption-attachment-4841\" class=\"wp-caption-text\">T\u00e1ch r\u1eddi to\u00e0n b\u1ed9 bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Ho\u1eb7c l\u00e0m theo nh\u1eefng b\u01b0\u1edbc sau:<\/p>\n<p style=\"text-align: justify\">1. Nh\u1ea5p ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 mi\u1ebfng n\u00e0o, ch\u1ecdn\u00a0<em><strong>Format Data Series<\/strong>.<\/em><\/p>\n<p style=\"text-align: justify\">2. Trong b\u1ea3ng\u00a0<em><strong>Format Data Series<\/strong><\/em>, m\u1edf th\u1ebb\u00a0<em><strong>Series Options<\/strong><\/em>, k\u00e9o thanh tr\u01b0\u1ee3t\u00a0<em><strong>Pie Explosion\u00a0<\/strong><\/em>\u0111\u1ec3 t\u0103ng ho\u1eb7c gi\u1ea3m kho\u1ea3ng c\u00e1ch gi\u1eefa hai mi\u1ebfng bi\u1ec3u \u0111\u1ed3. Ho\u1eb7c, g\u00f5 kho\u1ea3ng c\u00e1ch tr\u1ef1c ti\u1ebfp v\u00e0o h\u1ed9p ph\u1ea7n tr\u0103m.<\/p>\n<figure style=\"width: 256px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"T\u00e1ch r\u1eddi to\u00e0n b\u1ed9 bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-pie-chart-explosions.png\" alt=\"Configuring the pie chart explosion\" width=\"256\" height=\"313\"><figcaption class=\"wp-caption-text\">T\u00e1ch r\u1eddi to\u00e0n b\u1ed9 bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Keo_mot_mieng_rieng_le_ra_khoi_bieu_do_hinh_tron\"><\/span><strong>K\u00e9o m\u1ed9t mi\u1ebfng ri\u00eang l\u1ebb ra kh\u1ecfi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span lang=\"vi\">\u0110\u1ec3 thu h\u00fat s\u1ef1 ch\u00fa \u00fd c\u1ee7a ng\u01b0\u1eddi d\u00f9ng \u0111\u1ebfn m\u1ed9t ph\u1ea7n bi\u1ec3u \u0111\u1ed3 c\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 di chuy\u1ec3n n\u00f3 ra kh\u1ecfi ph\u1ea7n c\u00f2n l\u1ea1i c\u1ee7a bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n.<\/span><\/p>\n<p style=\"text-align: justify\"><span lang=\"vi\">C\u00e1ch nhanh nh\u1ea5t l\u00e0 ch\u1ecdn n\u00f3 v\u00e0 k\u00e9o ra xa b\u1eb1ng chu\u1ed9t. \u0110\u1ec3 ch\u1ecdn m\u1ed9t ph\u1ea7n bi\u1ec3u \u0111\u1ed3\u0111\u01a1n l\u1ebb, nh\u1ea5p v\u00e0o n\u00f3, v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o n\u00f3 m\u1ed9t l\u1ea7n n\u1eefa \u0111\u1ec3 ch\u1ec9 ph\u1ea7n n\u00e0y \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/p>\n<p style=\"text-align: justify\"><span lang=\"vi\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn ph\u1ea7n bi\u1ec3u \u0111\u1ed3 m\u00e0 b\u1ea1n mu\u1ed1n di chuy\u1ec3n ra, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o n\u00f3, ch\u1ecdn <em><strong>Format Data Series<\/strong><\/em>. Sau \u0111\u00f3, \u0111i \u0111\u1ebfn <em><strong>Series Options\u00a0<\/strong><\/em>t\u1eeb b\u1ea3ng\u00a0<em><strong>Format Data Series<\/strong><\/em>,\u00a0thi\u1ebft l\u1eadp <em><strong>Point Explosion<\/strong><\/em>:<\/span><\/p>\n<figure style=\"width: 530px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"K\u00e9o m\u1ed9t mi\u1ebfng ri\u00eang l\u1ebb ra kh\u1ecfi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pull-out-pie-slice.png\" alt=\"Pulling out a single slice of a pie chart\" width=\"530\" height=\"295\"><figcaption class=\"wp-caption-text\">K\u00e9o m\u1ed9t mi\u1ebfng ri\u00eang l\u1ebb ra kh\u1ecfi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span lang=\"vi\"><strong>Ch\u00fa \u00fd.<\/strong> N\u1ebfu b\u1ea1n mu\u1ed1n t\u00e1ch ra nhi\u1ec1u ph\u1ea7n, b\u1ea1n s\u1ebd ph\u1ea3i l\u1eb7p l\u1ea1i qu\u00e1 tr\u00ecnh cho t\u1eebng ph\u1ea7n m\u1ed9t. Kh\u00f4ng th\u1ec3 k\u00e9o m\u1ed9t nh\u00f3m c\u00e1c\u00a0c\u00e1c ph\u1ea7n c\u1eaft kh\u00e1c nhau ra kh\u1ecfi bi\u1ec3u \u0111\u1ed3, \u00a0b\u1ea1n c\u00f3 th\u1ec3 \u201cExplode\u201d to\u00e0n b\u1ed9 ch\u00fang<\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Xoay_bieu_do_hinh_tron\"><\/span><strong><span lang=\"vi\">Xoay bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span lang=\"vi\">Khi t\u1ea1o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel, th\u1ee9 t\u1ef1 c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi th\u1ee9 t\u1ef1 d\u1eef li\u1ec7u tr\u00ean b\u1ea3ng t\u00ednh. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 xoay \u0111\u1ed3 th\u1ecb 360 \u0111\u1ed9 \u0111\u1ec3 quan s\u00e1t t\u1eeb nhi\u1ec1u g\u00f3c \u0111\u1ed9 kh\u00e1c nhau.<\/span><\/p>\n<figure style=\"width: 588px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" title=\"Xoay bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/rotate-pie-chart-excel.png\" alt=\"Rotating pie charts for different perspectives\" width=\"588\" height=\"181\"><figcaption class=\"wp-caption-text\">Xoay bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Ta th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p style=\"text-align: justify\">1. Nh\u1ea5p ph\u1ea3i v\u00e0o b\u1ea5t c\u1ee9 ph\u1ea7n n\u00e0o c\u1ee7a bi\u1ec3u \u0111\u1ed3 v\u00e0 ch\u1ecdn\u00a0<em><strong>Format Data Series<\/strong><\/em>.<\/p>\n<figure id=\"attachment_4838\" aria-describedby=\"caption-attachment-4838\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4838 size-full\" title=\"Xoay bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/angle-first-slice.png\" alt=\"Xoay bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 1\" width=\"600\" height=\"343\"><figcaption id=\"caption-attachment-4838\" class=\"wp-caption-text\">Xoay bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 1<\/figcaption><\/figure>\n<p style=\"text-align: justify\">2. Trong b\u1ea3ng\u00a0<em><strong>Format Data Series<\/strong><\/em>, d\u01b0\u1edbi\u00a0<em><strong>Series Options<\/strong><\/em>, k\u00e9o thanh tr\u01b0\u1ee3t\u00a0<em><strong>Angle of First Slice\u00a0<\/strong><\/em>t\u1eeb 0 t\u1edbi xoay theo chi\u1ec1u kim \u0111\u1ed3ng h\u1ed3. Ho\u1eb7c, g\u00f5 con s\u1ed1 c\u1ee5 th\u1ec3 v\u00e0o \u00f4.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"3D_Rotation_cho_bieu_do_hinh_tron_3D\"><\/span><strong>3D Rotation cho bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D, ch\u00fang ta c\u00f3 nhi\u1ec1u s\u1ef1 l\u1ef1a ch\u1ecdn h\u01a1n. \u0110\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh n\u0103ng\u00a0<strong>3D-rotation,\u00a0<\/strong>nh\u1ea5p ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 ph\u1ea7n n\u00e0o trong bi\u1ec3u \u0111\u1ed3 v\u00e0 ch\u1ecdn\u00a0<strong>3D-rotation.<\/strong><\/p>\n<figure style=\"width: 374px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"3D Rotation cho bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-charts-3d-rotation.png\" alt=\"3-D Rotation options\" width=\"374\" height=\"254\"><figcaption class=\"wp-caption-text\">3D Rotation cho bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D<\/figcaption><\/figure>\n<p style=\"text-align: left\">H\u1ed9p tho\u1ea1i\u00a0<em><strong>Format Chart Area\u00a0<\/strong><\/em>v\u1edbi c\u00e1c t\u00f9y ch\u1ecdn\u00a0<em><strong>3D Rotations\u00a0<\/strong><\/em>sau:<\/p>\n<ul>\n<li style=\"text-align: left\">Xoay quanh theo tr\u1ee5c ngang trong\u00a0<strong>X Rotation<\/strong><\/li>\n<li style=\"text-align: left\">Xoay quanh theo tr\u1ee5c d\u1ecdc trong\u00a0<strong>Y Rotation<\/strong><\/li>\n<li style=\"text-align: left\">\u0110\u1ed9 nghi\u00eang (l\u0129nh v\u1ef1c xem tr\u00ean bi\u1ec3u \u0111\u1ed3) trong <strong>Perspective<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: left\"><strong> Ch\u00fa th\u00edch<\/strong>. C\u00e1c bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n Excel c\u00f3 th\u1ec3 xoay quanh c\u00e1c tr\u1ee5c ngang v\u00e0 d\u1ecdc, nh\u01b0ng kh\u00f4ng g\u1ed3m tr\u1ee5c s\u00e2u (tr\u1ee5c Z). V\u00ec v\u1eady, b\u1ea1n kh\u00f4ng th\u1ec3 ch\u1ecdn \u0111\u1ed9 xoay trong h\u1ed9p <strong>Z Rotation<\/strong>.<\/p>\n<figure id=\"attachment_4854\" aria-describedby=\"caption-attachment-4854\" style=\"width: 518px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-115.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4854 size-full\" title=\"3D Rotation cho bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-115.bmp\" alt=\"3D Rotation cho bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D 1\" width=\"518\" height=\"414\"><\/a><figcaption id=\"caption-attachment-4854\" class=\"wp-caption-text\">3D Rotation cho bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n 3D 1<\/figcaption><\/figure>\n<p style=\"text-align: left\">Khi b\u1ea1n nh\u1ea5p v\u00e0o m\u0169i t\u00ean l\u00ean v\u00e0 xu\u1ed1ng trong h\u1ed9p xoay, bi\u1ec3u \u0111\u1ed3 trong Excel s\u1ebd xoay ngay l\u1eadp t\u1ee9c \u0111\u1ec3 ph\u1ea3n \u00e1nh nh\u1eefng thay \u0111\u1ed5i. V\u00ec v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c nh\u1ea5p v\u00e0o c\u00e1c m\u0169i t\u00ean \u0111\u1ec3 di xoay bi\u1ec3u \u0111\u1ed3 theo cho \u0111\u1ebfn khi n\u00f3 \u1edf \u0111\u00fang v\u1ecb tr\u00ed.<\/p>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Sap_xep_bieu_do_hinh_tron_theo_kich_thuoc\"><\/span><strong>S\u1eafp x\u1ebfp bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n theo k\u00edch th\u01b0\u1edbc:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left\">Theo nguy\u00ean t\u1eafc chung, bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n d\u1ec5 hi\u1ec3u h\u01a1n khi c\u00e1c ph\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf. C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y l\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u ngu\u1ed3n tr\u00ean b\u1ea3ng t\u00ednh. N\u1ebfu ch\u01b0a s\u1eafp x\u1ebfp d\u1eef li\u1ec7u ngu\u1ed3n, b\u1ea1n c\u00f3 th\u1ec3 x\u1ebfp l\u1ea1i c\u00e1ch sau.<\/p>\n<p style=\"text-align: left\">1. T\u1ea1o m\u1ed9t PivoteTable t\u1eeb b\u1ea3ng ngu\u1ed3n c\u1ee7a b\u1ea1n. C\u00e1c b\u01b0\u1edbc chi ti\u1ebft \u0111\u01b0\u1ee3c gi\u1ea3i th\u00edch trong h\u01b0\u1edbng d\u1eabn B\u1ea3ng Excel Pivot d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u.<\/p>\n<p style=\"text-align: left\">2. \u0110\u1eb7t t\u00ean c\u00e1c lo\u1ea1i trong <strong>Row field<\/strong>\u00a0v\u00e0 d\u1eef li\u1ec7u s\u1ed1 trong <strong>Values field<\/strong>. K\u1ebft qu\u1ea3 c\u1ee7a PivotTable s\u1ebd gi\u1ed1ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<figure id=\"attachment_4855\" aria-describedby=\"caption-attachment-4855\" style=\"width: 593px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-116.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4855 size-full\" title=\"S\u1eafp x\u1ebfp bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n theo k\u00edch th\u01b0\u1edbc\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-116.bmp\" alt=\"S\u1eafp x\u1ebfp bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n theo k\u00edch th\u01b0\u1edbc\" width=\"593\" height=\"141\"><\/a><figcaption id=\"caption-attachment-4855\" class=\"wp-caption-text\">S\u1eafp x\u1ebfp bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n theo k\u00edch th\u01b0\u1edbc<\/figcaption><\/figure>\n<p style=\"text-align: left\">3. Nh\u1ea5p v\u00e0o AutoSort b\u00ean c\u1ea1nh Row Labels, sau \u0111\u00f3 nh\u1ea5p v\u00e0o <strong>More Sort Options\u2026<\/strong><\/p>\n<p style=\"text-align: left\">4. Trong h\u1ed9p tho\u1ea1i <strong>Sort<\/strong>, ch\u1ecdn s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo <strong>Value <\/strong>theo<strong>\u00a0<\/strong>th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n:<\/p>\n<figure id=\"attachment_4857\" aria-describedby=\"caption-attachment-4857\" style=\"width: 326px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-117.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4857 size-full\" title=\"Sort\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-117.bmp\" alt=\"Sort\" width=\"326\" height=\"312\"><\/a><figcaption id=\"caption-attachment-4857\" class=\"wp-caption-text\">Sort<\/figcaption><\/figure>\n<p style=\"text-align: left\"><span lang=\"vi\">5. T\u1ea1o bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n t\u1eeb PivotTable v\u00e0 l\u00e0m m\u1edbi n\u00f3 b\u1ea5t c\u1ee9 khi n\u00e0o c\u1ea7n.<\/span><\/p>\n<figure id=\"attachment_4858\" aria-describedby=\"caption-attachment-4858\" style=\"width: 570px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-118.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4858 size-full\" title=\"PivotTable\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-118.bmp\" alt=\"PivotTable\" width=\"570\" height=\"393\"><\/a><figcaption id=\"caption-attachment-4858\" class=\"wp-caption-text\">PivotTable<\/figcaption><\/figure>\n<blockquote>\n<p style=\"text-align: left\">Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">H\u1ecdc l\u1eadp tr\u00ecnh VBA trong Excel \u1edf \u0111\u00e2u<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Thay_doi_mau_bieu_do_hinh_tron\"><\/span><span lang=\"vi\"><strong>Thay \u0111\u1ed5i m\u00e0u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left\"><span lang=\"vi\">N\u1ebfu b\u1ea1n kh\u00f4ng h\u00e0i l\u00f2ng v\u1edbi m\u00e0u m\u1eb7c \u0111\u1ecbnh c\u1ee7a bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n Excel, b\u1ea1n c\u00f3 th\u1ec3: <\/span><\/p>\n<p style=\"text-align: left\"><strong><span lang=\"vi\">Thay \u0111\u1ed5i m\u00e0u s\u1eafc c\u1ee7a bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel <\/span><\/strong><\/p>\n<p style=\"text-align: left\"><span lang=\"vi\">\u0110\u1ec3 ch\u1ecdn m\u1ed9t m\u00e0u kh\u00e1c cho bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat Chart Styles <a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-119.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4859\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-119.bmp\" width=\"38\" height=\"32\" title=\"new-bitmap-image-2-119\"><\/a>,\u00a0t\u1edbi tab <strong>Color v\u00e0\u00a0<\/strong>ch\u1ecdn m\u00e0u b\u1ea1n mu\u1ed1n. <\/span><\/p>\n<p style=\"text-align: left\"><span lang=\"vi\">C\u00e1ch kh\u00e1c, nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 v\u1ecb tr\u00ed n\u00e0o b\u00ean trong bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n \u0111\u1ec3 k\u00edch ho\u1ea1t tab <strong>Chart Tools<\/strong> tr\u00ean ribbon, \u0111\u1ebfn tab <strong>Design&gt;Chart Styles<\/strong> v\u00e0 nh\u1ea5p v\u00e0o n\u00fat <strong>Change Colors<\/strong>:<br \/>\n<\/span><\/p>\n<figure id=\"attachment_4860\" aria-describedby=\"caption-attachment-4860\" style=\"width: 214px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-120.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4860 size-full\" title=\"Thay \u0111\u1ed5i m\u00e0u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-120.bmp\" alt=\"Thay \u0111\u1ed5i m\u00e0u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n\" width=\"214\" height=\"225\"><\/a><figcaption id=\"caption-attachment-4860\" class=\"wp-caption-text\">Thay \u0111\u1ed5i m\u00e0u bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/figcaption><\/figure>\n<p style=\"text-align: left\"><strong><span lang=\"vi\">Ch\u1ecdn m\u00e0u s\u1eafc cho t\u1eebng ph\u1ea7n ri\u00eang bi\u1ec7t<\/span><\/strong><\/p>\n<p style=\"text-align: left\"><span lang=\"vi\">Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh \u1edf tr\u00ean, vi\u1ec7c l\u1ef1a ch\u1ecdn m\u00e0u cho bi\u1ec3u \u0111\u1ed3 trong Excel kh\u00e1 h\u1ea1n ch\u1ebf, v\u00e0 n\u1ebfu b\u1ea1n \u0111\u1ecbnh t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 h\u1ee3p th\u1eddi trang v\u00e0 l\u00f4i cu\u1ed1n, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn t\u1eebng ph\u1ea7n ri\u00eang l\u1ebb. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n \u0111\u00e3 ch\u1ecdn \u0111\u1eb7t nh\u00e3n d\u1eef li\u1ec7u b\u00ean trong c\u00e1c ph\u1ea7n, ch\u1eef \u0111en c\u00f3 th\u1ec3 kh\u00f3 \u0111\u1ecdc tr\u00ean c\u00e1c m\u00e0u t\u1ed1i. <\/span><\/p>\n<p style=\"text-align: left\"><span lang=\"vi\">\u0110\u1ec3 thay \u0111\u1ed5i m\u00e0u s\u1eafc c\u1ee7a m\u1ed9t mi\u1ebfng n\u00e0o \u0111\u00f3, h\u00e3y nh\u1ea5p v\u00e0o ph\u1ea7n \u0111\u00f3 v\u00e0 sau \u0111\u00f3 nh\u1ea5p l\u1ea1i v\u00e0o \u0111\u00f3 \u0111\u1ec3 ch\u1ec9 ch\u1ecdn m\u1ed9t mi\u1ebfng c\u1eaft n\u00e0y. Chuy\u1ec3n t\u1edbi tab <strong>Format<\/strong>, nh\u1ea5p v\u00e0o <strong>Shape Fill\u00a0<\/strong>v\u00e0 ch\u1ecdn m\u00e0u b\u1ea1n mu\u1ed1n:<\/span><\/p>\n<figure id=\"attachment_4864\" aria-describedby=\"caption-attachment-4864\" style=\"width: 469px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-121.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4864 size-full\" title=\"Ch\u1ecdn m\u00e0u s\u1eafc cho t\u1eebng ph\u1ea7n ri\u00eang bi\u1ec7t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-121.bmp\" alt=\"Ch\u1ecdn m\u00e0u s\u1eafc cho t\u1eebng ph\u1ea7n ri\u00eang bi\u1ec7t\" width=\"469\" height=\"508\"><\/a><figcaption id=\"caption-attachment-4864\" class=\"wp-caption-text\">Ch\u1ecdn m\u00e0u s\u1eafc cho t\u1eebng ph\u1ea7n ri\u00eang bi\u1ec7t<\/figcaption><\/figure>\n<p style=\"text-align: left\"><span lang=\"vi\"><strong>M\u1eb9o:<\/strong> <\/span><\/p>\n<p style=\"text-align: left\"><span lang=\"vi\">N\u1ebfu bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n c\u00f3 nhi\u1ec1u l\u00e1t nh\u1ecf, b\u1ea1n c\u00f3 th\u1ec3 \u201cl\u00e0m x\u00e1m ch\u00fang\u201d b\u1eb1ng c\u00e1ch ch\u1ecdn m\u00e0u x\u00e1m cho nh\u1eefng l\u00e1t nh\u1ecf kh\u00f4ng li\u00ean quan n\u00e0y. <\/span><\/p>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Dinh_dang_mot_bieu_do_hinh_tron_trong_Excel\"><\/span><span lang=\"vi\"><strong>\u0110\u1ecbnh d\u1ea1ng m\u1ed9t bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left\"><span lang=\"vi\"> Khi b\u1ea1n t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 tr\u00f2n trong Excel \u0111\u1ec3 tr\u00ecnh b\u00e0y ho\u1eb7c xu\u1ea5t sang c\u00e1c \u1ee9ng d\u1ee5ng kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n mang l\u1ea1i cho n\u00f3 m\u1ed9t c\u00e1i nh\u00ecn b\u1eaft m\u1eaft. <\/span><\/p>\n<p style=\"text-align: left\"><span lang=\"vi\">\u0110\u1ec3 truy c\u1eadp v\u00e0o t\u00ednh n\u0103ng \u0111\u1ecbnh d\u1ea1ng, h\u00e3y nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 ph\u1ea7n n\u00e0o c\u1ee7a bi\u1ec3u \u0111\u1ed3 v\u00e0 ch\u1ecdn <strong>Format Data Series<\/strong> t\u1eeb tr\u00ecnh \u0111\u01a1n. <strong>Format Data Series<\/strong> s\u1ebd xu\u1ea5t hi\u1ec7n \u1edf b\u00ean ph\u1ea3i b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n, b\u1ea1n chuy\u1ec3n sang tab <strong>Effects<\/strong> (ph\u1ea7n th\u1ee9 hai) v\u00e0 th\u1eed c\u00e1c t\u00f9y ch\u1ecdn <strong>Shadow, Glow<\/strong> v\u00e0<strong> Soft Edges<\/strong>.<br \/>\n<\/span><\/p>\n<figure id=\"attachment_4865\" aria-describedby=\"caption-attachment-4865\" style=\"width: 254px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-122.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4865 size-full\" title=\"\u0110\u1ecbnh d\u1ea1ng m\u1ed9t bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-122.bmp\" alt=\"\u0110\u1ecbnh d\u1ea1ng m\u1ed9t bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong Excel\" width=\"254\" height=\"549\"><\/a><figcaption id=\"caption-attachment-4865\" class=\"wp-caption-text\">\u0110\u1ecbnh d\u1ea1ng m\u1ed9t bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n<\/figcaption><\/figure>\n<ul>\n<li style=\"text-align: left\"><span lang=\"vi\">C\u00f3 nhi\u1ec1u t\u00f9y ch\u1ecdn c\u00f3 s\u1eb5n tr\u00ean tab <strong>Format<\/strong>\u00a0ch\u1eb3ng h\u1ea1n nh\u01b0: <\/span><\/li>\n<li style=\"text-align: left\"><span lang=\"vi\">Thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc bi\u1ec3u \u0111\u1ed3 tr\u00f2n (chi\u1ec1u cao v\u00e0 chi\u1ec1u r\u1ed9ng) <\/span><\/li>\n<li style=\"text-align: left\"><span lang=\"vi\">Thay \u0111\u1ed5i h\u00ecnh d\u1ea1ng v\u00e0 m\u00e0u <\/span><\/li>\n<li style=\"text-align: left\"><span lang=\"vi\">S\u1eed d\u1ee5ng c\u00e1c hi\u1ec7u \u1ee9ng h\u00ecnh d\u1ea1ng kh\u00e1c nhau <\/span><\/li>\n<li style=\"text-align: left\"><span lang=\"vi\">S\u1eed d\u1ee5ng c\u00e1c ki\u1ec3u WordArt cho c\u00e1c ph\u1ea7n ch\u00fa th\u00edch <\/span><\/li>\n<li style=\"text-align: left\"><span lang=\"vi\">V\u00e0 h\u01a1n th\u1ebf n\u1eefa<\/span><\/li>\n<\/ul>\n<p style=\"text-align: left\"><span lang=\"vi\">\u0110\u1ec3 s\u1eed d\u1ee5ng c\u00e1c t\u00ednh n\u0103ng \u0111\u1ecbnh d\u1ea1ng n\u00e0y, h\u00e3y ch\u1ecdn ph\u1ea7n bi\u1ec3u \u0111\u1ed3 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng (v\u00ed d\u1ee5: ch\u00fa th\u00edch bi\u1ec3u \u0111\u1ed3 tr\u00f2n, nh\u00e3n d\u1eef li\u1ec7u, l\u00e1t ho\u1eb7c ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3) v\u00e0 chuy\u1ec3n sang tab Format tr\u00ean ribbon. C\u00e1c t\u00ednh n\u0103ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 li\u00ean quan s\u1ebd \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t, v\u00e0 nh\u1eefng t\u00ednh n\u0103ng kh\u00f4ng li\u00ean quan s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u x\u00e1m.<\/span><\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-123.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4871\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-123.bmp\" width=\"600\" height=\"142\" title=\"new-bitmap-image-2-123\"><\/a><\/p>\n<p style=\"text-align: left\">Xem th\u00eam:<\/p>\n<p style=\"text-align: left;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-hinh-tron-thuc-hien-ke-hoach-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n % th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch tr\u00ean Excel<\/a><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3\u00a0c\u00f3 th\u00eam \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c h\u1eefu \u00edch li\u00ean quan t\u1edbi v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n tr\u00ean Excel r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o? Trong Excel c\u00f2n r\u1ea5t nhi\u1ec1u d\u1ea1ng bi\u1ec3u \u0111\u1ed3 kh\u00e1c n\u1eefa nh\u01b0 h\u00ecnh c\u1ed9t, \u0111\u01b0\u1eddng Line, combo gi\u1eefa c\u1ed9t v\u00e0 \u0111\u01b0\u1eddng, bi\u1ec3u \u0111\u1ed3 KPI, bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng\u2026 \u0110\u1ec3 c\u00f3 th\u1ec3 n\u00e2ng cao ki\u1ebfn th\u1ee9c v\u1ec1 bi\u1ec3u \u0111\u1ed3 tr\u00ean Excel, b\u1ea1n c\u00f3 th\u1ec3 tham gia ngay\u00a0kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2wauPZX\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia\u00a0<\/a>c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap cung c\u1ea5p ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, b\u00e0i b\u1ea3n, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Th\u00f4ng qua kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd bi\u1ebft c\u00e1ch \u0111\u1ec3 l\u00e0m ra 1 b\u1ea3ng b\u00e1o c\u00e1o ch\u00ednh x\u00e1c, \u0111\u00fang chu\u1ea9n, t\u1eeb \u0111\u00f3 c\u00f3 th\u1ec3 v\u1ebd ra nh\u1eefng bi\u1ec3u \u0111\u1ed3 theo \u00fd mu\u1ed1n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn d\u00e0nh cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-342.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4258,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4257","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\/4257","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=4257"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4257\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4258"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}