{"id":11303,"date":"2025-01-15T02:29:24","date_gmt":"2025-01-15T02:29:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-lam-noi-bat-1-cot-trong-bieu-do-bar-chart-excel\/"},"modified":"2025-01-15T02:29:24","modified_gmt":"2025-01-15T02:29:24","slug":"cach-lam-noi-bat-1-cot-trong-bieu-do-bar-chart-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-lam-noi-bat-1-cot-trong-bieu-do-bar-chart-excel\/","title":{"rendered":"C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt 1 c\u1ed9t trong bi\u1ec3u \u0111\u1ed3 bar chart Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong khi v\u1ebd \u0111\u1ed3 th\u1ecb tr\u00ean Excel \u0111\u1ec3 di\u1ec5n t\u1ea3 \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u t\u1ed1t h\u01a1n, ch\u00fang ta s\u1ebd h\u01b0\u1edbng s\u1ef1 ch\u00fa \u00fd c\u1ee7a kh\u00e1n gi\u1ea3 v\u00e0o m\u1ed9t c\u1ed9t nh\u1ea5t \u0111\u1ecbnh. \u0110i\u1ec1u n\u00e0y ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c trong Excel v\u1edbi m\u1ed9t v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y khi b\u1ea1n tham kh\u1ea3o b\u00e0i vi\u1ebft sau \u0111\u00e2y t\u1eeb <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> nh\u00e9<\/p>\n<p>\u0110\u1ea7u ti\u00ean l\u00e0 k\u1ebft qu\u1ea3 sau b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9123\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ve-do-thi-excel-01-1024x361-1.png\" alt=\"ve-do-thi-excel-01\" width=\"1024\" height=\"361\" title=\"ve-do-thi-excel-01-1024x361-1\"><\/p>\n<p>Khi <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> ho\u1eb7c l\u00e0m nh\u1eefng th\u1ee9 ph\u1ee9c t\u1ea1p h\u01a1n nh\u01b0 Dashboard, Report, l\u1eddi khuy\u00ean cho c\u00e1c b\u1ea1n \u1edf \u0111\u00e2y l\u00e0 kh\u00f4ng thay \u0111\u1ed5i d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o (Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y: A1:B8)<\/p>\n<p>V\u00ed v\u1eady b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean: Copy d\u1eef li\u1ec7u ra 1 v\u00f9ng kh\u00e1c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9124\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ve-do-thi-excel-02-1024x420-1.png\" alt=\"ve-do-thi-excel-02\" width=\"1024\" height=\"420\" title=\"ve-do-thi-excel-02-1024x420-1\"><\/p>\n<p>B\u01b0\u1edbc 3: S\u1eafp x\u1ebfp d\u1eef li\u1ec7u t\u1eeb l\u1edbn t\u1edbi nh\u1ecf<\/p>\n<ul>\n<li>Ch\u1ecdn v\u00f9ng E1:F8, b\u1ea5m ph\u00edm t\u1eaft CTRL + SHIFT + L r\u1ed3i s\u1eafp x\u1ebfp th\u1ecb ph\u1ea7n t\u1eeb l\u1edbn nh\u1ea5t t\u1edbi nh\u1ecf nh\u1ea5t<\/li>\n<\/ul>\n<p>B\u01b0\u1edbc 4: Th\u00eam 1 s\u1ed1 c\u00f4ng th\u1ee9c \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho vi\u1ec7c v\u1ebd \u0111\u1ed3 th\u1ecb<\/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\/2025\/01\/ex101_92019-nho-282.gif\" title=\"ex101_92019-nho-282\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta mu\u1ed1n c\u1ed9t bi\u1ec3u th\u1ecb d\u1eef li\u1ec7u c\u1ee7a c\u00f4ng ty D\u01b0a H\u1ea5u kh\u00e1c \u0111i th\u00ec ch\u00fang ta s\u1ebd \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o G2 v\u00e0 H2 nh\u01b0 h\u00ecnh minh ho\u1ea1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9125\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cong-thuc-trong-do-thi-1024x585-1.png\" alt=\"cong-thuc-trong-do-thi\" width=\"1024\" height=\"585\" title=\"cong-thuc-trong-do-thi-1024x585-1\"><\/p>\n<p>B\u01b0\u1edbc 5: V\u1ebd \u0111\u1ed3 th\u1ecb<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9126\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ve-do-thi-1024x714-1.png\" alt=\"ve-do-thi\" width=\"1024\" height=\"714\" title=\"ve-do-thi-1024x714-1\"><\/p>\n<p>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o \u0111\u1ed3 th\u1ecb v\u00e0 ch\u1ecdn <strong>Select Data \u2026<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9127\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/select-data-chart-1024x787-1.png\" alt=\"select-data-chart\" width=\"1024\" height=\"787\" title=\"select-data-chart-1024x787-1\"><\/p>\n<p>\u00a0<\/p>\n<p>Ch\u1ecdn d\u1eef li\u1ec7u nh\u01b0 h\u00ecnh m\u00ecnh ho\u1ea1<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9128\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/select-data-final-1024x596-1.png\" alt=\"select-data-final\" width=\"1024\" height=\"596\" title=\"select-data-final-1024x596-1\"><\/p>\n<p>K\u1ebft qu\u1ea3 \u0111\u1ea1t \u0111\u01b0\u1ee3c sau b\u01b0\u1edbc n\u00e0y l\u00e0:<\/p>\n<p>\u00a0<\/p>\n<figure id=\"attachment_9129\" aria-describedby=\"caption-attachment-9129\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9129\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chart_result_1-1024x725-1.png\" alt=\"chart_result_1\" width=\"1024\" height=\"725\" title=\"chart_result_1-1024x725-1\"><figcaption id=\"caption-attachment-9129\" class=\"wp-caption-text\">Sau \u0111\u00f3 ch\u00fang ta click ch\u1ecdn r\u1ed3i xo\u00e1 nh\u1eefng th\u00e0nh ph\u1ea7n kh\u00f4ng c\u1ea7n thi\u1ebft v\u00e0 ch\u1ec9nh l\u1ea1i m\u00e0u s\u1eafc:<\/figcaption><\/figure>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-9130\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chinh-mau-sac-cho-chart-1024x489-1.png\" alt=\"chinh-mau-sac-cho-chart\" width=\"1024\" height=\"489\" title=\"chinh-mau-sac-cho-chart-1024x489-1\"><\/p>\n<p>Sau \u0111\u00f3 b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o tr\u1ee5c c\u00f3 t\u00ean c\u00e1c c\u00f4ng ty r\u1ed3i l\u00e0m nh\u01b0 h\u00ecnh minh ho\u1ea1<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9131\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/categories-in-reverse-order.png\" alt=\"categories-in-reverse-order\" width=\"745\" height=\"481\" title=\"categories-in-reverse-order\"><\/p>\n<p>Sau \u0111\u00f3 ch\u1ecdn Series data m\u00e0u ghi (m\u00e0u xanh l\u00e0m t\u01b0\u01a1ng t\u1ef1):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9132\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/format-data-series.png\" alt=\"format-data-series\" width=\"643\" height=\"329\" title=\"format-data-series\"><\/p>\n<p>Th\u00eam Data Labels: ch\u1ecdn series, b\u1ea5m chu\u1ed9t ph\u1ea3i, ch\u1ecdn Add Data Labels<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9133\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/them-data-labels.png\" alt=\"them-data-labels\" width=\"998\" height=\"760\" title=\"them-data-labels\"><\/p>\n<p>K\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9134\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-chart.png\" alt=\"ket-qua-chart\" width=\"970\" height=\"644\" title=\"ket-qua-chart\"><\/p>\n<p>L\u00e0m sao \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c s\u1ed1 0 th\u1eeba ra?<\/p>\n<p>\u00a0<\/p>\n<p>B\u1ea5m ch\u1ecdn data labels r\u1ed3i sau \u0111\u00f3 b\u1ea5m Format Data Labels v\u1edbi code nh\u01b0 sau:\u00a0<strong>#,##0;-#,##0;;<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9135\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/format-data-labels.png\" alt=\"format-data-labels\" width=\"805\" height=\"509\" title=\"format-data-labels\"><\/p>\n<p>Th\u00eam ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3, ta \u0111\u01b0\u1ee3c bi\u1ec3u \u0111\u1ed3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9136\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/final-chart.png\" alt=\"final-chart\" width=\"952\" height=\"638\" title=\"final-chart\"><\/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\/2025\/01\/ex101_92019-nho-282.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11304,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11303","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\/11303","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=11303"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11303\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11304"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}