{"id":925,"date":"2023-08-27T23:43:00","date_gmt":"2023-08-27T16:43:00","guid":{"rendered":"https:\/\/trannghiait.com\/?p=925"},"modified":"2023-08-27T23:43:00","modified_gmt":"2023-08-27T16:43:00","slug":"cach-tao-thanh-tien-trinh-progress-bar-trong-excel-3-phuong-phap-de-dang","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/08\/27\/cach-tao-thanh-tien-trinh-progress-bar-trong-excel-3-phuong-phap-de-dang\/","title":{"rendered":"C\u00e1ch t\u1ea1o thanh ti\u1ebfn tr\u00ecnh (Progress bar) trong Excel (3 ph\u01b0\u01a1ng ph\u00e1p d\u1ec5 d\u00e0ng)"},"content":{"rendered":"\n<p>Khi l\u00e0m vi\u1ec7c trong&nbsp;<strong>Microsoft Excel<\/strong>&nbsp;, ch\u00fang ta c\u00f3 th\u1ec3 c\u1ea7n tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u d\u01b0\u1edbi d\u1ea1ng bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 d\u1ec5 hi\u1ec3u.&nbsp;Ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng s\u1eed d\u1ee5ng bi\u1ec3u \u0111\u1ed3 thanh ti\u1ebfn tr\u00ecnh \u0111\u1ec3 l\u00e0m cho t\u1eadp d\u1eef li\u1ec7u tr\u00f4ng h\u1ea5p d\u1eabn h\u01a1n.&nbsp;Trong b\u00e0i vi\u1ebft n\u00e0y m\u00ecnh chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n c\u00e1ch t\u1ea1o thanh ti\u1ebfn tr\u00ecnh trong excel.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_64 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/27\/cach-tao-thanh-tien-trinh-progress-bar-trong-excel-3-phuong-phap-de-dang\/#Tai_xuong_Sach_bai_tap_thuc_hanh\" title=\"T\u1ea3i xu\u1ed1ng S\u00e1ch b\u00e0i t\u1eadp th\u1ef1c h\u00e0nh\">T\u1ea3i xu\u1ed1ng S\u00e1ch b\u00e0i t\u1eadp th\u1ef1c h\u00e0nh<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/27\/cach-tao-thanh-tien-trinh-progress-bar-trong-excel-3-phuong-phap-de-dang\/#3_phuong_phap_de_dang_de_tao_thanh_tien_trinh_trong_Excel\" title=\"3 ph\u01b0\u01a1ng ph\u00e1p d\u1ec5 d\u00e0ng \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh trong Excel\">3 ph\u01b0\u01a1ng ph\u00e1p d\u1ec5 d\u00e0ng \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/27\/cach-tao-thanh-tien-trinh-progress-bar-trong-excel-3-phuong-phap-de-dang\/#1_Chen_bieu_do_thanh_de_tao_thanh_tien_trinh\" title=\"1. Ch\u00e8n bi\u1ec3u \u0111\u1ed3 thanh \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh\">1. Ch\u00e8n bi\u1ec3u \u0111\u1ed3 thanh \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/27\/cach-tao-thanh-tien-trinh-progress-bar-trong-excel-3-phuong-phap-de-dang\/#2_Su_dung_dinh_dang_co_dieu_kien_de_tao_thanh_tien_trinh\" title=\"2. S\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh\">2. S\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/27\/cach-tao-thanh-tien-trinh-progress-bar-trong-excel-3-phuong-phap-de-dang\/#3_Chay_ma_VBA_de_tao_thanh_tien_trinh\" title=\"3. Ch\u1ea1y m\u00e3 VBA \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh\">3. Ch\u1ea1y m\u00e3 VBA \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/27\/cach-tao-thanh-tien-trinh-progress-bar-trong-excel-3-phuong-phap-de-dang\/#Nhung_dieu_can_ghi_nho\" title=\"Nh\u1eefng \u0111i\u1ec1u c\u1ea7n ghi nh\u1edb\">Nh\u1eefng \u0111i\u1ec1u c\u1ea7n ghi nh\u1edb<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/27\/cach-tao-thanh-tien-trinh-progress-bar-trong-excel-3-phuong-phap-de-dang\/#Phan_ket_luan\" title=\"Ph\u1ea7n k\u1ebft lu\u1eadn\">Ph\u1ea7n k\u1ebft lu\u1eadn<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tai_xuong_Sach_bai_tap_thuc_hanh\"><\/span>T\u1ea3i xu\u1ed1ng S\u00e1ch b\u00e0i t\u1eadp th\u1ef1c h\u00e0nh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>T\u1ea3i xu\u1ed1ng b\u00e0i t\u1eadp th\u1ef1c h\u00e0nh n\u00e0y \u0111\u1ec3 t\u1eadp th\u1ec3 d\u1ee5c trong khi b\u1ea1n \u0111ang \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y.<\/p>\n\n\n\n<p><strong><a rel=\"noreferrer noopener\" href=\"https:\/\/www.exceldemy.com\/wp-content\/uploads\/2022\/07\/Create_a_Progress_Bar_in_excel.xlsm\" target=\"_blank\">T\u1ea1o Thanh ti\u1ebfn tr\u00ecnh.xlsm<\/a><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_phuong_phap_de_dang_de_tao_thanh_tien_trinh_trong_Excel\"><\/span>3 ph\u01b0\u01a1ng ph\u00e1p d\u1ec5 d\u00e0ng \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong b\u00e0i vi\u1ebft sau, t\u00f4i \u0111\u00e3 chia s\u1ebb 3 ph\u01b0\u01a1ng ph\u00e1p d\u1ec5 d\u00e0ng \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh trong excel.<\/p>\n\n\n\n<p><strong>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 t\u1eadp d\u1eef li\u1ec7u v\u1ec1 Doanh s\u1ed1 d\u1ef1 b\u00e1o<\/strong>&nbsp;v\u00e0&nbsp;<strong>Doanh s\u1ed1 th\u1ef1c t\u1ebf<\/strong>&nbsp;theo n\u0103m c\u1ee7a c\u00f4ng ty&nbsp;.&nbsp;B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd t\u1ea1o m\u1ed9t thanh ti\u1ebfn tr\u00ecnh bi\u1ec3u \u0111\u1ed3 c\u1ea3&nbsp;<strong>Doanh s\u1ed1 d\u1ef1 b\u00e1o<\/strong>&nbsp;v\u00e0&nbsp;<strong>Doanh s\u1ed1 th\u1ef1c t\u1ebf<\/strong>&nbsp;.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"463\" height=\"268\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-88.png\" alt=\"\" class=\"wp-image-926\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-88.png 463w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-88-300x174.png 300w\" sizes=\"(max-width: 463px) 100vw, 463px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Chen_bieu_do_thanh_de_tao_thanh_tien_trinh\"><\/span>1. Ch\u00e8n bi\u1ec3u \u0111\u1ed3 thanh \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Bi\u1ec3u \u0111\u1ed3 thanh ti\u1ebfn tr\u00ecnh ch\u1ee7 y\u1ebfu \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o t\u00e0i ch\u00ednh c\u1ee7a c\u00f4ng ty.\u00a0B\u1ea1n c\u00f3 th\u1ec3 v\u1ebd nhi\u1ec1u gi\u00e1 tr\u1ecb kh\u00e1c nhau trong c\u00f9ng m\u1ed9t bi\u1ec3u \u0111\u1ed3.\u00a0Ch\u1ecdn d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n v\u00e0 t\u1ea1o s\u01a1 \u0111\u1ed3 t\u1eeb t\u00f9y ch\u1ecdn \u201c\u00a0<strong>Ch\u00e8n<\/strong>\u00a0\u201d.\u00a0Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u1ea1o bi\u1ec3u \u0111\u1ed3 thanh.\u00a0\u0110\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng?\u00a0Trong ph\u01b0\u01a1ng ph\u00e1p n\u00e0y, t\u00f4i \u0111ang gi\u1ea3i th\u00edch vi\u1ec7c t\u1ea1o thanh ti\u1ebfn tr\u00ecnh b\u1eb1ng c\u00e1ch ch\u00e8n bi\u1ec3u \u0111\u1ed3 thanh v\u00e0o b\u1ea3ng excel.<\/p>\n\n\n\n<p><strong>B\u01b0\u1edbc 1:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ch\u1ecdn d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n v\u1edbi ti\u00eau \u0111\u1ec1 m\u00e0 b\u1ea1n mu\u1ed1n v\u1ebd trong bi\u1ec3u \u0111\u1ed3 thanh ti\u1ebfn tr\u00ecnh.<\/li>\n\n\n\n<li>\u1ede \u0111\u00e2y t\u00f4i \u0111\u00e3 ch\u1ecdn&nbsp;<strong>c\u00e1c \u00f4<\/strong>&nbsp;(&nbsp;<strong>C4:E11<\/strong>&nbsp;).<\/li>\n\n\n\n<li>Trong khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn, h\u00e3y chuy\u1ec3n \u0111\u1ebfn danh s\u00e1ch \u201c\u00a0<strong>Bi\u1ec3u \u0111\u1ed3<\/strong>\u00a0\u201d t\u1eeb t\u00f9y ch\u1ecdn \u201c\u00a0<strong>Ch\u00e8n<\/strong>\u00a0\u201d.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"461\" height=\"489\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-89.png\" alt=\"\" class=\"wp-image-927\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-89.png 461w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-89-283x300.png 283w\" sizes=\"(max-width: 461px) 100vw, 461px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Ch\u1ecdn m\u1ed9t \u201c\u00a0<strong>Thanh c\u1ee5m<\/strong>\u00a0\u201d t\u1eeb \u201c\u00a0<strong>Thanh 2-D<\/strong>\u00a0\u201d.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"228\" height=\"342\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-90.png\" alt=\"\" class=\"wp-image-928\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-90.png 228w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-90-200x300.png 200w\" sizes=\"(max-width: 228px) 100vw, 228px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, m\u1ed9t bi\u1ec3u \u0111\u1ed3 s\u1ebd \u0111\u01b0\u1ee3c t\u1ea1o \u0111\u1ec3 th\u1ec3 hi\u1ec7n t\u1ea5t c\u1ea3 doanh s\u1ed1 b\u00e1n h\u00e0ng trong n\u0103m.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"403\" height=\"294\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-91.png\" alt=\"\" class=\"wp-image-929\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-91.png 403w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-91-300x219.png 300w\" sizes=\"(max-width: 403px) 100vw, 403px\" \/><\/figure><\/div>\n\n\n<p><strong>B\u01b0\u1edbc 2:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd ch\u1ec9nh s\u1eeda bi\u1ec3u \u0111\u1ed3.<\/li>\n\n\n\n<li>\u0110\u1ec3 ch\u1ec9nh s\u1eeda bi\u1ec3u \u0111\u1ed3, h\u00e3y ch\u1ecdn c\u00e1c thanh t\u1eeb s\u01a1 \u0111\u1ed3 v\u00e0 nh\u1ea5p chu\u1ed9t ph\u1ea3i \u0111\u1ec3 xu\u1ea5t hi\u1ec7n c\u00e1c t\u00f9y ch\u1ecdn.<\/li>\n\n\n\n<li>T\u1eeb c\u00e1c t\u00f9y ch\u1ecdn, ch\u1ecdn \u201c&nbsp;<strong>\u0110\u1ecbnh d\u1ea1ng chu\u1ed7i d\u1eef li\u1ec7u<\/strong>&nbsp;\u201d.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"479\" height=\"338\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-92.png\" alt=\"\" class=\"wp-image-930\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-92.png 479w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-92-300x212.png 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>\u0110i t\u1edbi t\u00f9y ch\u1ecdn \u201c&nbsp;<strong>Fill<\/strong>&nbsp;\u201d v\u00e0 nh\u1ea5p v\u00e0o \u201c&nbsp;<strong>Solid Fill<\/strong>&nbsp;\u201d.<\/li>\n\n\n\n<li>Ch\u1ecdn m\u1ed9t m\u00e0u t\u1eeb h\u00e0ng \u201c&nbsp;<strong>M\u00e0u<\/strong>&nbsp;\u201d v\u00e0 c\u0169ng ch\u1ecdn m\u00e0u \u0111\u01b0\u1eddng vi\u1ec1n t\u1eeb c\u00e1c t\u00f9y ch\u1ecdn \u201c&nbsp;<strong>\u0110\u01b0\u1eddng vi\u1ec1n<\/strong><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-93.png\" alt=\"\" class=\"wp-image-931\" style=\"width:279px;height:540px\" width=\"279\" height=\"540\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-93.png 279w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-93-155x300.png 155w\" sizes=\"(max-width: 279px) 100vw, 279px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>X\u00f3a d\u1eef li\u1ec7u kh\u00f4ng c\u1ea7n thi\u1ebft v\u00e0 \u1edf \u0111\u00e2y ch\u00fang ta \u0111\u00e3 t\u1ea1o th\u00e0nh c\u00f4ng thanh ti\u1ebfn tr\u00ecnh.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"642\" height=\"376\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-94.png\" alt=\"\" class=\"wp-image-932\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-94.png 642w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-94-300x176.png 300w\" sizes=\"(max-width: 642px) 100vw, 642px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Su_dung_dinh_dang_co_dieu_kien_de_tao_thanh_tien_trinh\"><\/span>2. S\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n ch\u1ee7 y\u1ebfu \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng trong c\u00e1c \u00f4 kh\u00e1c nhau.\u00a0Nh\u01b0ng c\u00f2n nhi\u1ec1u \u0111i\u1ec1u h\u01a1n th\u1ebf n\u1eefa.\u00a0B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o\u00a0<strong>thanh ti\u1ebfn tr\u00ecnh b\u00ean trong m\u1ed9t \u00f4 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong>\u00a0c\u1ee7a Excel.\u00a0Trong ph\u01b0\u01a1ng ph\u00e1p n\u00e0y, t\u00f4i s\u1ebd ch\u1ec9 cho b\u1ea1n c\u00e1ch t\u1ea1o thanh ti\u1ebfn tr\u00ecnh b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n\n\n\n<p><strong>B\u01b0\u1edbc 1:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0110\u1ea7u ti\u00ean, h\u00e3y t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m th\u00e0nh t\u00edch b\u1eb1ng c\u00e1ch chia&nbsp;<strong>doanh s\u1ed1 th\u1ef1c t\u1ebf<\/strong>&nbsp;cho&nbsp;<strong>doanh s\u1ed1 d\u1ef1 ki\u1ebfn<\/strong>&nbsp;.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"576\" height=\"342\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-95.png\" alt=\"\" class=\"wp-image-933\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-95.png 576w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-95-300x178.png 300w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>B\u00e2y gi\u1edd, ch\u1ecdn gi\u00e1 tr\u1ecb ph\u1ea7n tr\u0103m, nh\u1ea5p v\u00e0o \u201c\u00a0<strong>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong>\u00a0\u201d t\u1eeb ruy-b\u0103ng.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"586\" height=\"523\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-96.png\" alt=\"\" class=\"wp-image-934\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-96.png 586w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-96-300x268.png 300w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>\u0110i t\u1edbi \u201c\u00a0<strong>Quy t\u1eafc kh\u00e1c<\/strong>\u00a0\u201d t\u1eeb \u201c\u00a0<strong>Thanh d\u1eef li\u1ec7u<\/strong>\u00a0\u201d.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>M\u1ed9t c\u1eeda s\u1ed5 m\u1edbi s\u1ebd b\u1eadt l\u00ean c\u00f3 t\u00ean \u201c&nbsp;<strong>Quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng m\u1edbi<\/strong>&nbsp;\u201d.<\/li>\n\n\n\n<li>Trong \u201c&nbsp;<strong>Ch\u1ecdn lo\u1ea1i quy t\u1eafc<\/strong>&nbsp;\u201d nh\u1ea5p v\u00e0o \u201c&nbsp;<strong>\u0110\u1ecbnh d\u1ea1ng t\u1ea5t c\u1ea3 c\u00e1c \u00f4 d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang<\/strong>&nbsp;\u201d.<\/li>\n\n\n\n<li>Thay \u0111\u1ed5i lo\u1ea1i th\u00e0nh \u201c&nbsp;<strong>S\u1ed1<\/strong>&nbsp;\u201d trong c\u1ea3 hai ph\u1ea7n \u201c&nbsp;<strong>T\u1ed1i thi\u1ec3u<\/strong>&nbsp;\u201d v\u00e0 \u201c&nbsp;<strong>T\u1ed1i \u0111a<\/strong>&nbsp;\u201d.<\/li>\n\n\n\n<li>Sau \u0111\u00f3, nh\u1eadp gi\u00e1 tr\u1ecb s\u1ed1 \u201c&nbsp;<strong>0<\/strong>&nbsp;\u201d v\u00e0o ph\u1ea7n \u201c&nbsp;<strong>t\u1ed1i thi\u1ec3u<\/strong>&nbsp;\u201d v\u00e0 nh\u1eadp \u201c&nbsp;<strong>1<\/strong>&nbsp;\u201d v\u00e0o ph\u1ea7n \u201c&nbsp;<strong>t\u1ed1i \u0111a<\/strong>&nbsp;\u201d.<\/li>\n\n\n\n<li>B\u00e2y gi\u1edd ch\u1ecdn m\u1ed9t m\u00e0u theo s\u1ef1 l\u1ef1a ch\u1ecdn c\u1ee7a b\u1ea1n v\u00e0 nh\u1ea5n&nbsp;<strong>OK<\/strong>&nbsp;\u0111\u1ec3 ti\u1ebfp t\u1ee5c.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"381\" height=\"499\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-98.png\" alt=\"\" class=\"wp-image-936\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-98.png 381w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-98-229x300.png 229w\" sizes=\"(max-width: 381px) 100vw, 381px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>h\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y \u1edf \u0111\u00e2y, ch\u00fang t\u00f4i \u0111\u00e3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh trong excel.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"608\" height=\"340\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-99.png\" alt=\"\" class=\"wp-image-937\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-99.png 608w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-99-300x168.png 300w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Chay_ma_VBA_de_tao_thanh_tien_trinh\"><\/span>3. Ch\u1ea1y m\u00e3 VBA \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ea1y\u00a0<strong>m\u00e3 VBA \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh trong excel<\/strong>\u00a0.<\/p>\n\n\n\n<p><strong>C\u00e1c b\u01b0\u1edbc:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ch\u1ecdn&nbsp;<strong>c\u00e1c \u00f4<\/strong>&nbsp;(&nbsp;<strong>F5:F11<\/strong>&nbsp;) \u0111\u1ec3 \u00e1p d\u1ee5ng m\u00e3 cho c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn \u0111\u00f3.<\/li>\n\n\n\n<li>Nh\u1ea5n&nbsp;<strong>Alt+F11<\/strong>&nbsp;\u0111\u1ec3 m\u1edf \u201c&nbsp;<strong>Microsoft Visual Basic for Application<\/strong>&nbsp;\u201d.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"577\" height=\"317\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-100.png\" alt=\"\" class=\"wp-image-938\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-100.png 577w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-100-300x165.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>T\u1ea1o m\u1ed9t m\u00f4-\u0111un m\u1edbi t\u1eeb t\u00f9y ch\u1ecdn ch\u00e8n.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"484\" height=\"270\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-101.png\" alt=\"\" class=\"wp-image-939\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-101.png 484w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-101-300x167.png 300w\" sizes=\"(max-width: 484px) 100vw, 484px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Trong m\u00f4-\u0111un \u00e1p d\u1ee5ng \u0111o\u1ea1n m\u00e3 sau-<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>Sub Progress_Bar()\nRange(\"F5:F11\").Select\nSelection.FormatConditions.AddDatabar\nSelection.FormatConditions(Selection.FormatConditions.Count).ShowValue = True\nSelection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority\nWith Selection.FormatConditions(1)\n.MinPoint.Modify newtype:=xlConditionValueNumber, newvalue:=0\n.MaxPoint.Modify newtype:=xlConditionValueNumber, newvalue:=1\nEnd With\nWith Selection.FormatConditions(1).BarColor\n.ThemeColor = xlThemeColorAccent1\n.TintAndShade = 0\nEnd With\nSelection.FormatConditions(1).BarFillType = xlDataBarFillSolid\nSelection.FormatConditions(1).Direction = xlContext\nSelection.FormatConditions(1).NegativeBarFormat.ColorType = xlDataBarColor\nSelection.FormatConditions(1).BarBorder.Type = xlDataBarBorderNone\nSelection.FormatConditions(1).AxisPosition = xlDataBarAxisAutomatic\nWith Selection.FormatConditions(1).AxisColor\n.Color = 0\n.TintAndShade = 0\nEnd With\nWith Selection.FormatConditions(1).NegativeBarFormat.Color\n.Color = 255\n.TintAndShade = 0\nEnd With\nEnd Sub<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nh\u1ea5n \u201c\u00a0<strong>Ch\u1ea1y<\/strong>\u00a0\u201d.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"604\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-102.png\" alt=\"\" class=\"wp-image-940\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-102.png 724w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-102-300x250.png 300w\" sizes=\"(max-width: 724px) 100vw, 724px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>\u1ede \u0111\u00f3, ch\u00fang ta \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 qu\u00fd gi\u00e1 l\u00e0 t\u1ea1o ra thanh ti\u1ebfn tr\u00ecnh trong s\u1ed5 l\u00e0m vi\u1ec7c excel.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"582\" height=\"316\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-103.png\" alt=\"\" class=\"wp-image-941\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-103.png 582w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-103-300x163.png 300w\" sizes=\"(max-width: 582px) 100vw, 582px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Nhung_dieu_can_ghi_nho\"><\/span>Nh\u1eefng \u0111i\u1ec1u c\u1ea7n ghi nh\u1edb<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Trong&nbsp;<strong>ph\u01b0\u01a1ng ph\u00e1p 2<\/strong>&nbsp;, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c lo\u1ea1i bi\u1ec3u \u0111\u1ed3 thanh kh\u00e1c nhau t\u1eeb c\u1eeda s\u1ed5 \u201c&nbsp;<strong>Quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng m\u1edbi<\/strong>&nbsp;\u201d.&nbsp;Ch\u1ec9 c\u1ea7n m\u1edf danh s\u00e1ch th\u1ea3 xu\u1ed1ng c\u1ee7a \u201c&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/change-the-format-of-a-cell-0a45ff85-ee24-4276-94e8-aed6083e8050\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Format&nbsp;<\/strong><strong>Style<\/strong><\/a>&nbsp;\u201d \u0111\u1ec3 t\u1ea1o c\u00e1c lo\u1ea1i \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau b\u00ean trong m\u1ed9t \u00f4.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Phan_ket_luan\"><\/span>Ph\u1ea7n k\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, t\u00f4i \u0111\u00e3 c\u1ed1 g\u1eafng \u0111\u1ec1 c\u1eadp \u0111\u1ebfn t\u1ea5t c\u1ea3 c\u00e1c ph\u01b0\u01a1ng ph\u00e1p \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 t\u1ea1o thanh ti\u1ebfn tr\u00ecnh trong excel.\u00a0H\u00e3y tham kh\u1ea3o s\u00e1ch b\u00e0i t\u1eadp th\u1ef1c h\u00e0nh v\u00e0 t\u1ea3i file v\u1ec1 \u0111\u1ec3 t\u1ef1 luy\u1ec7n t\u1eadp.\u00a0Hi v\u1ecdng b\u1ea1n t\u00ecm \u0111\u01b0\u1ee3c th\u1ee9 h\u1eefu d\u1ee5ng.\u00a0H\u00e3y th\u00f4ng b\u00e1o cho ch\u00fang t\u00f4i trong ph\u1ea7n b\u00ecnh lu\u1eadn v\u1ec1 tr\u1ea3i nghi\u1ec7m c\u1ee7a b\u1ea1n.\u00a0Ch\u00fang t\u00f4i lu\u00f4n \u0111\u00e1p \u1ee9ng c\u00e1c th\u1eafc m\u1eafc c\u1ee7a b\u1ea1n.\u00a0H\u00e3y theo d\u00f5i v\u00e0 ti\u1ebfp t\u1ee5c h\u1ecdc h\u1ecfi.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Khi l\u00e0m vi\u1ec7c trong&nbsp;Microsoft Excel&nbsp;, ch\u00fang ta c\u00f3 th\u1ec3 c\u1ea7n tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u d\u01b0\u1edbi d\u1ea1ng bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 d\u1ec5 hi\u1ec3u.&nbsp;Ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng s\u1eed <a class=\"mh-excerpt-more\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/27\/cach-tao-thanh-tien-trinh-progress-bar-trong-excel-3-phuong-phap-de-dang\/\" title=\"C\u00e1ch t\u1ea1o thanh ti\u1ebfn tr\u00ecnh (Progress bar) trong Excel (3 ph\u01b0\u01a1ng ph\u00e1p d\u1ec5 d\u00e0ng)\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-925","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/925","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=925"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/925\/revisions"}],"predecessor-version":[{"id":942,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/925\/revisions\/942"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=925"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}