{"id":5037,"date":"2024-12-09T01:50:38","date_gmt":"2024-12-09T01:50:38","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-cach-ve-bieu-do-ke-hoach-thuc-te-dang-cot-long-nhau-tren-excel\/"},"modified":"2024-12-09T01:50:38","modified_gmt":"2024-12-09T01:50:38","slug":"huong-dan-cach-ve-bieu-do-ke-hoach-thuc-te-dang-cot-long-nhau-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-cach-ve-bieu-do-ke-hoach-thuc-te-dang-cot-long-nhau-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 k\u1ebf ho\u1ea1ch th\u1ef1c t\u1ebf d\u1ea1ng c\u1ed9t l\u1ed3ng nhau tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Bi\u1ec3u \u0111\u1ed3 bi\u1ec3u di\u1ec5n t\u00ecnh h\u00ecnh th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch l\u00e0 m\u1ed9t d\u1ea1ng bi\u1ec3u \u0111\u1ed3 th\u01b0\u1eddng g\u1eb7p ph\u1ea3i trong c\u00f4ng vi\u1ec7c, \u0111\u1eb7c bi\u1ec7t khi ph\u01b0\u01a1ng ph\u00e1p \u0111\u00e1nh gi\u00e1 hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c d\u1ef1a theo KPIs nh\u01b0 hi\u1ec7n nay. Vi\u1ec7c bi\u1ec3u di\u1ec5n lo\u1ea1i bi\u1ec3u \u0111\u1ed3 n\u00e0y c\u0169ng ph\u1ee9c t\u1ea1p h\u01a1n so v\u1edbi c\u00e1c bi\u1ec3u \u0111\u1ed3 kh\u00e1c. C\u00f3 nhi\u1ec1u lo\u1ea1i bi\u1ec3u \u0111\u1ed3 \u0111\u00e1p \u1ee9ng c\u00e1c y\u00eau c\u1ea7u n\u00e0y: <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html\"><strong>bi\u1ec3u \u0111\u1ed3 c\u1ed9t<\/strong><\/a> l\u1ed3ng v\u00e0o nhau bi\u1ec3u di\u1ec5n s\u1ed1 li\u1ec7u d\u1ea1ng con s\u1ed1 \u0111\u1ea1t, kh\u00f4ng \u0111\u1ea1t, v\u01b0\u1ee3t k\u1ebf ho\u1ea1ch\u2026, bi\u1ec3u \u0111\u1ed3 d\u1ea1ng h\u00ecnh tr\u00f2n l\u1ed3ng v\u00e0o nhau bi\u1ec3u di\u1ec5n theo s\u1ed1 li\u1ec7u %\u2026\u00a0 Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta h\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 k\u1ebf ho\u1ea1ch th\u1ef1c t\u1ebf d\u1ea1ng c\u1ed9t l\u1ed3ng nhau tr\u00ean Excel nh\u00e9.<\/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-67564cededbb3\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-ke-hoach-thuc-te-dang-cot-long-nhau-tren-excel.html#Dac_diem_bao_cao_tinh_hinh_thuc_hien_ke_hoach\" title=\"\u0110\u1eb7c\u00a0\u0111i\u1ec3m b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch\">\u0110\u1eb7c\u00a0\u0111i\u1ec3m b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-ke-hoach-thuc-te-dang-cot-long-nhau-tren-excel.html#Ve_bieu_do_ke_hoach_thuc_te_dang_cot_long_nhau\" title=\"V\u1ebd bi\u1ec3u \u0111\u1ed3 k\u1ebf ho\u1ea1ch th\u1ef1c t\u1ebf d\u1ea1ng c\u1ed9t l\u1ed3ng nhau\">V\u1ebd bi\u1ec3u \u0111\u1ed3 k\u1ebf ho\u1ea1ch th\u1ef1c t\u1ebf d\u1ea1ng c\u1ed9t l\u1ed3ng nhau<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-ke-hoach-thuc-te-dang-cot-long-nhau-tren-excel.html#Chen_bieu_do_va_gan_du_lieu_vao_bieu_do\" title=\"Ch\u00e8n bi\u1ec3u\u00a0\u0111\u1ed3 v\u00e0 g\u00e1n d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3\">Ch\u00e8n bi\u1ec3u\u00a0\u0111\u1ed3 v\u00e0 g\u00e1n d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-bieu-ke-hoach-thuc-te-dang-cot-long-nhau-tren-excel.html#Thay_doi_cach_bieu_dien_cua_bieu_do\" title=\"Thay\u00a0\u0111\u1ed5i c\u00e1ch bi\u1ec3u di\u1ec5n c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3\">Thay\u00a0\u0111\u1ed5i c\u00e1ch bi\u1ec3u di\u1ec5n c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dac_diem_bao_cao_tinh_hinh_thuc_hien_ke_hoach\"><\/span>\u0110\u1eb7c\u00a0\u0111i\u1ec3m b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 <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\u00ec ch\u00fang ta c\u1ea7n c\u00f3 1 b\u1ea3ng d\u1eef li\u1ec7u. B\u1ea3ng d\u1eef li\u1ec7u n\u00e0y ch\u00ednh l\u00e0 b\u1ea3ng b\u00e1o c\u00e1o v\u1ec1 t\u00ecnh h\u00ecnh th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch. Trong d\u1ea1ng b\u00e1o c\u00e1o n\u00e0y th\u01b0\u1eddng c\u00f3 c\u1ea5u tr\u00fac nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>Ch\u1ec9 ti\u00eau,\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng, c\u00f4ng vi\u1ec7c<\/strong>:\u00a0\u0111\u00e1nh gi\u00e1 t\u00ecnh h\u00ecnh th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch cho\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng n\u00e0o?<\/li>\n<li><strong>S\u1ed1 k\u1ebf ho\u1ea1ch<\/strong>: s\u1ed1 li\u1ec7u n\u00e0y th\u01b0\u1eddng c\u00f3 s\u1eb5n t\u1eeb\u00a0khi l\u1eadp k\u1ebf ho\u1ea1ch, kh\u00f4ng c\u1ea7n ph\u1ea3i t\u00ednh to\u00e1n l\u1ea1i.<\/li>\n<li><strong>S\u1ed1 th\u1ef1c t\u1ebf<\/strong>: S\u1ed1 li\u1ec7u n\u00e0y c\u1ea7n\u00a0\u0111\u01b0\u1ee3c t\u00ednh to\u00e1n, t\u1ed5ng h\u1ee3p l\u1ea1i t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u theo d\u00f5i chi ti\u1ebft t\u1eebng ng\u00e0y, t\u1eebng l\u1ea7n ph\u00e1t sinh s\u1ed1 li\u1ec7u c\u00f3 li\u00ean quan.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 k\u1ebf ho\u1ea1ch nh\u01b0 sau:<\/p>\n<p>(C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file\u00a0\u0111\u00ednh k\u00e8m t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2QlLVLZ\">http:\/\/bit.ly\/2QlLVLZ<\/a>)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22610\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-lap-bao-cao-thuc-hien-ke-hoach.png\" width=\"920\" height=\"677\" title=\"data-lap-bao-cao-thuc-hien-ke-hoach\"><\/p>\n<p>Trong b\u1ea3ng d\u1eef li\u1ec7u ph\u00e1t sinh (t\u1edbi d\u00f2ng 102) th\u1ec3 hi\u1ec7n t\u1eebng l\u1ea7n ph\u00e1t sinh c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m theo ng\u00e0y.\u00a0\u0110\u00e2y l\u00e0 s\u1ed1 th\u1ef1c hi\u1ec7n.<\/p>\n<p>Y\u00eau c\u1ea7u c\u1ee7a ch\u00fang ta l\u00e0 ph\u1ea3i t\u00ednh\u00a0\u0111\u01b0\u1ee3c t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m v\u00e0o b\u1ea3ng b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch. T\u1eeb\u00a0\u0111\u00f3 c\u0103n c\u1ee9 v\u00e0o s\u1ed1 k\u1ebf ho\u1ea1ch, s\u1ed1 th\u1ef1c hi\u1ec7n th\u00ec ch\u00fang ta m\u1edbi v\u1ebd\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u\u00a0\u0111\u1ed3.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-422.gif\" title=\"ex101_92019-nho-422\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>C\u00e1ch t\u00ednh nh\u01b0 sau:<\/p>\n<p>Y\u00eau c\u1ea7u t\u00ednh to\u00e1n l\u00e0 t\u00ednh t\u1ed5ng, c\u00f3 bao g\u1ed3m\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 t\u1eebng\u00a0s\u1ea3n ph\u1ea9m c\u00f3 trong c\u1ed9t S\u1ea3n ph\u1ea9m, k\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh l\u00e0 S\u1ed1 l\u01b0\u1ee3ng.<\/p>\n<p>=&gt;\u00a0\u0110\u00e2y l\u00e0 y\u00eau c\u1ea7u t\u00ednh t\u1ed5ng theo 1\u00a0\u0111i\u1ec1u ki\u1ec7n, v\u00ec v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\">h\u00e0m SUMIF\u00a0<\/a>\u0111\u1ec3 t\u00ednh.<\/p>\n<p>C\u00e1ch t\u00ednh nh\u01b0 sau:<\/p>\n<p>T\u1ea1i\u00a0\u00f4 G3 (t\u00ednh cho s\u1ea3n ph\u1ea9m 1)\u00a0\u0111\u1eb7t h\u00e0m SUMIF, trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Range: l\u00e0 v\u00f9ng ch\u1ee9a c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n, ch\u00ednh l\u00e0 c\u1ed9t S\u1ea3n ph\u1ea9m trong b\u1ea3ng d\u1eef li\u1ec7u ph\u00e1t sinh, t\u1eeb A3:A102<\/li>\n<li>Criteria: l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n, c\u1ee5 th\u1ec3 l\u00e0 s\u1ea3n ph\u1ea9m t\u01b0\u01a1ng\u00a0\u1ee9ng t\u1ea1i d\u00f2ng 3 trong b\u00e1o c\u00e1o, l\u00e0\u00a0\u00f4 E3<\/li>\n<li>Sum_range: l\u00e0 v\u00f9ng t\u00ednh t\u1ed5ng, ch\u00ednh l\u00e0 c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng, t\u1eeb C3:C102<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">G3=SUMIF($A$3:$A$102,E3,$C$3:$C$102)<\/p>\n<p>Ch\u00fa\u00a0\u00fd: C\u00e1c v\u00f9ng Range v\u00e0 Sum_range c\u1ea7n ph\u1ea3i c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 kh\u00f4ng b\u1ecb thay\u00a0\u0111\u1ed5i khi\u00a0\u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c s\u1ea3n ph\u1ea9m kh\u00e1c trong b\u00e1o c\u00e1o.<\/p>\n<p>Sau\u00a0\u0111\u00f3 ch\u00fang ta filldown (ph\u00edm t\u1eaft <strong>Ctrl+D<\/strong>)\u00a0c\u00f4ng th\u1ee9c t\u1eeb G3 t\u1edbi G12 cho c\u00e1c s\u1ea3n ph\u1ea9m c\u00f2n l\u1ea1i.<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22612\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-bao-cao-tinh-hinh-thuc-hien-ke-hoach.png\" width=\"581\" height=\"228\" title=\"ket-qua-bao-cao-tinh-hinh-thuc-hien-ke-hoach\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ve_bieu_do_ke_hoach_thuc_te_dang_cot_long_nhau\"><\/span>V\u1ebd bi\u1ec3u \u0111\u1ed3 k\u1ebf ho\u1ea1ch th\u1ef1c t\u1ebf d\u1ea1ng c\u1ed9t l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Chen_bieu_do_va_gan_du_lieu_vao_bieu_do\"><\/span>Ch\u00e8n bi\u1ec3u\u00a0\u0111\u1ed3 v\u00e0 g\u00e1n d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3, ch\u00fang ta v\u00e0o th\u1ebb\u00a0Insert v\u00e0 ch\u1ecdn bi\u1ec3u\u00a0\u0111\u1ed3 h\u00ecnh c\u1ed9t, d\u1ea1ng <strong>2D-Column\/ Clustered Column<\/strong> (c\u00f3 th\u1ec3 kh\u00f4ng c\u1ea7n ph\u1ea3i ch\u1ecdn tr\u01b0\u1edbc b\u1ea3ng d\u1eef li\u1ec7u, m\u00e0 th\u1ef1c hi\u1ec7n ngay thao t\u00e1c\u00a0insert\/chart)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22613\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-bieu-do-2d-column-clustered-column.png\" width=\"591\" height=\"495\" title=\"insert-bieu-do-2d-column-clustered-column\"><\/p>\n<p>Sau khi th\u00eam bi\u1ec3u\u00a0\u0111\u1ed3, ch\u00fang ta s\u1ebd l\u1ef1a ch\u1ecdn l\u1ea1i d\u1eef li\u1ec7u\u00a0\u0111\u01b0a v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3 t\u1ea1i th\u1ebb <strong>Chart Tools\/ Design\/ Select Data<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22614\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chart-tools-design-select-data-1.png\" width=\"1401\" height=\"201\" title=\"chart-tools-design-select-data-1\"><\/p>\n<p>T\u1ea1i\u00a0\u0111\u00e2y ch\u00fang ta s\u1ebd th\u00eam c\u00e1c d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u\u00a0\u0111\u1ed3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22615\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-data-into-chart.png\" width=\"1120\" height=\"426\" title=\"add-data-into-chart\"><\/p>\n<p>M\u1ee5c <strong>Legend Entires (series)<\/strong> b\u1ea5m <strong>Add<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22616\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-data-into-legend-entires-series.png\" width=\"799\" height=\"317\" title=\"add-data-into-legend-entires-series\"><\/p>\n<ul>\n<li><strong>Ph\u1ea7n k\u1ebf ho\u1ea1ch:<\/strong> g\u1ed3m Series name l\u00e0\u00a0\u00f4 F2 (t\u00ean ti\u00eau \u0111\u1ec1 c\u1ed9t\u00a0K\u1ebf ho\u1ea1ch), Series values l\u00e0 v\u00f9ng d\u1eef li\u1ec7u c\u1ee7a b\u00e1o c\u00e1o cho c\u1ed9t k\u1ebf ho\u1ea1ch\u00a0t\u1eeb F3:F12<\/li>\n<li><strong>Ph\u1ea7n th\u1ef1c hi\u1ec7n:<\/strong> g\u1ed3m\u00a0Series name l\u00e0\u00a0\u00f4 G2 (t\u00ean ti\u00eau\u00a0\u0111\u1ec1 c\u1ed9t Th\u1ef1c hi\u1ec7n), Series values l\u00e0 v\u00f9ng d\u1eef li\u1ec7u c\u1ee7a b\u00e1o c\u00e1o cho c\u1ed9t\u00a0th\u1ef1c hi\u1ec7n\u00a0t\u1eeb G3:G12<\/li>\n<\/ul>\n<p>M\u1ee5c <strong>Horizontal (category)\u00a0Axis Labels<\/strong> b\u1ea5m <strong>Edit<\/strong>, ch\u1ecdn t\u1edbi v\u00f9ng t\u00ean c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m, t\u1eeb E3:E12<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22618\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-data-into-horizontal-axis-labels.png\" width=\"806\" height=\"289\" title=\"add-data-into-horizontal-axis-labels\"><\/p>\n<p>K\u1ebft qu\u1ea3 sau khi ch\u1ecdn c\u00e1c v\u00f9ng d\u1eef li\u1ec7u c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22619\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-chon-data-cho-bieu-do-clustered-column.png\" width=\"1324\" height=\"410\" title=\"ket-qua-chon-data-cho-bieu-do-clustered-column\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_cach_bieu_dien_cua_bieu_do\"><\/span>Thay\u00a0\u0111\u1ed5i c\u00e1ch bi\u1ec3u di\u1ec5n c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a ch\u00fang ta l\u00e0 bi\u1ec3u di\u1ec5n 2 c\u1ed9t K\u1ebf ho\u1ea1ch (m\u00e0u xanh) v\u00e0 Th\u1ef1c hi\u1ec7n (m\u00e0u cam) ph\u1ea3i l\u1ed3ng v\u00e0o b\u00ean trong nhau. V\u00ec v\u1eady t\u1edbi\u00a0\u0111\u00e2y ch\u00fang ta c\u1ea7n ph\u1ea3i l\u00e0m ti\u1ebfp thao t\u00e1c thay\u00a0\u0111\u1ed5i c\u00e1ch bi\u1ec3u di\u1ec5n c\u00e1c tr\u1ee5c c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3.<\/p>\n<p>B\u1ea5m ch\u1ecdn v\u00e0o 1 c\u1ed9t b\u1ea5t k\u1ef3, b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn <strong>Change Series Chart Type\u2026<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22621\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-series-chart-type-cho-bieu-do-kh-thuc-hien.png\" width=\"748\" height=\"376\" title=\"change-series-chart-type-cho-bieu-do-kh-thuc-hien\"><\/p>\n<p>Trong c\u1eeda s\u1ed5 Change Chart Type, ch\u00fang ta\u00a0\u0111\u00e1nh d\u1ea5u ch\u1ecdn cho m\u1ee5c <strong>Secondary Axis Label<\/strong> cho nh\u00f3m c\u1ed9t <strong>Th\u1ee5c hi\u1ec7n<\/strong> (l\u01b0u\u00a0\u00fd khi l\u00e0m b\u01b0\u1edbc n\u00e0y c\u1ea7n gi\u1eef nguy\u00ean Chart Type c\u1ee7a 2 nh\u00f3m n\u00e0y l\u00e0 d\u1ea1ng <strong>Clustered Column<\/strong>)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22622\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/secondary-axis-labels-cot-thuc-hien.png\" width=\"794\" height=\"751\" title=\"secondary-axis-labels-cot-thuc-hien\"><\/p>\n<p>Khi\u00a0\u0111\u00f3 ch\u00fang ta s\u1ebd th\u1ea5y k\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0 3 c\u1ed9t l\u1ed3ng v\u00e0o nhau tr\u00ean c\u00f9ng 1 g\u1ed1c t\u1ecda\u00a0\u0111\u1ed9. Bi\u1ec3u\u00a0\u0111\u1ed3 c\u00f3 th\u00eam 1 tr\u1ee5c tung th\u1ee9 2 b\u00ean tay ph\u1ea3i.<\/p>\n<p>Tuy nhi\u00ean\u00a0\u0111\u1ed9 l\u1edbn c\u1ee7a 2 tr\u1ee5c tung l\u1ea1i kh\u00f4ng b\u1eb1ng nhau:<\/p>\n<ul>\n<li>Tr\u1ee5c b\u00ean tr\u00e1i t\u1eeb 0\u00a0\u0111\u1ebfn 350<\/li>\n<li>Tr\u1ee5c b\u00ean ph\u1ea3i t\u1eeb 0\u00a0\u0111\u1ebfn 250<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 c\u1ea7n ph\u1ea3i\u00a0\u0111\u01b0a\u00a0\u0111\u1ed9 l\u1edbn c\u1ee7a 2 tr\u1ee5c v\u1ec1 b\u1eb1ng nhau\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o 2 bi\u1ec3u\u00a0\u0111\u1ed3 th\u1ec3 hi\u1ec7n gi\u1ed1ng nh\u01b0 tr\u00ean c\u00f9ng 1 tr\u1ee5c t\u1ecda\u00a0\u0111\u1ed9. Khi l\u00e0m\u00a0\u0111\u1ebfn\u00a0\u0111\u00e2y ch\u00fang ta s\u1ebd tu\u00e2n theo nguy\u00ean t\u1eafc:\u00a0<strong>\u0110i\u1ec1u ch\u1ec9nh\u00a0\u1edf tr\u1ee5c\u00a0\u0111ang c\u00f3 s\u1ed1 nh\u1ecf h\u01a1n<\/strong>. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m chu\u1ed9t tr\u00e1i ch\u1ecdn tr\u1ee5c nh\u1ecf h\u01a1n (tr\u1ee5c b\u00ean ph\u1ea3i)<\/li>\n<li>T\u1ea1i tr\u1ee5c n\u00e0y, b\u1ea5m chu\u1ed9t ph\u1ea3i ch\u1ecdn Format\u00a0Axis<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22623\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-axis-thay-doi-do-lon-truc-tung-thu-2.png\" width=\"382\" height=\"478\" title=\"format-axis-thay-doi-do-lon-truc-tung-thu-2\"><\/p>\n<ul>\n<li>Thay\u00a0\u0111\u1ed5i\u00a0\u0111\u1ed9 l\u1edbn c\u1ee7a tr\u1ee5c t\u1ecda\u00a0\u0111\u1ed9 n\u00e0y t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi tr\u1ee5c c\u00f2n l\u1ea1i (minimum = 0 v\u00e0 maximum = 350)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22624\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/thay-doi-do-lon-truc-toa-do.png\" width=\"349\" height=\"346\" title=\"thay-doi-do-lon-truc-toa-do\"><\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22625\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-bieu-do-cot-long-nhau-cap-01.png\" width=\"602\" height=\"362\" title=\"ket-qua-bieu-do-cot-long-nhau-cap-01\"><\/p>\n<p>T\u1edbi\u00a0\u0111\u00e2y ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m ti\u1ebfp 1 b\u01b0\u1edbc n\u1eefa\u00a0\u0111\u00f3 l\u00e0\u00a0\u0111i\u1ec1u ch\u1ec9nh ph\u1ea7n th\u00e2n bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u1ec3 khi\u1ebfn c\u1ed9t Th\u1ef1c hi\u1ec7n nh\u1ecf h\u01a1n c\u1ed9t K\u1ebf ho\u1ea1ch, n\u1eb1m g\u1ecdn b\u00ean trong th\u00e2n c\u1ed9t K\u1ebf ho\u1ea1ch. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m ch\u1ecdn c\u1ed9t K\u1ebf ho\u1ea1ch (ph\u1ea7n c\u1ed9t m\u00e0u xanh) ch\u1ecdn Format\u00a0Data Series<\/li>\n<li>Trong c\u1eeda s\u1ed5 Format Data Series, m\u1ee5c Series options\/ Plot Series On\/ Gap\u00a0Width thi\u1ebft l\u1eadp\u00a0\u1edf m\u1ee9c kho\u1ea3ng 40% (S\u1ed1 c\u00e0ng nh\u1ecf th\u00ec th\u00e2n bi\u1ec3u\u00a0\u0111\u1ed3 c\u00e0ng r\u1ed9ng ra)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22626\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dieu-chinh-do-rong-cot-voi-gap-width.png\" width=\"960\" height=\"413\" title=\"dieu-chinh-do-rong-cot-voi-gap-width\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta th\u1ea5y ph\u1ea7n c\u1ed9t K\u1ebf ho\u1ea1ch\u00a0\u0111\u00e3 n\u1eb1m bao quanh b\u00ean ngo\u00e0i ph\u1ea7n c\u1ed9t Th\u1ef1c hi\u1ec7n.<\/p>\n<ul>\n<li>Nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f3 ph\u1ea7n c\u1ed9t Th\u1ef1c hi\u1ec7n v\u01b0\u1ee3t ra ngo\u00e0i ph\u1ea1m vi c\u1ed9t K\u1ebf ho\u1ea1ch t\u1ee9c l\u00e0 V\u01b0\u1ee3t k\u1ebf ho\u1ea1ch.<\/li>\n<li>Nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f3 ph\u1ea7n c\u1ed9t Th\u1ef1c hi\u1ec7n\u00a0n\u1eb1m b\u00ean trong\u00a0ph\u1ea1m vi c\u1ed9t K\u1ebf ho\u1ea1ch t\u1ee9c l\u00e0\u00a0Ch\u01b0a\u00a0\u0111\u1ea1t k\u1ebf ho\u1ea1ch.<\/li>\n<\/ul>\n<p>Bi\u1ec3u\u00a0\u0111\u1ed3 c\u1ee7a ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh xong ph\u1ea7n n\u1ed9i dung ch\u00ednh r\u1ed3i. Vi\u1ec7c c\u00f2n l\u1ea1i l\u00e0 trang tr\u00ed,\u00a0\u0111\u1ecbnh d\u1ea1ng l\u1ea1i bi\u1ec3u\u00a0\u0111\u1ed3 cho\u00a0\u0111\u1eb9p n\u1eefa l\u00e0 xong. Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u00e1p d\u1ee5ng t\u1ed1t n\u1ed9i dung n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c nh\u00e9.<\/p>\n<p>B\u00e0i ti\u1ebfp theo:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dieu-khien-bieu-do-tu-dong-thay-doi-theo-nut-tuy-chon-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111i\u1ec1u khi\u1ec3n bi\u1ec3u \u0111\u1ed3 t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i theo n\u00fat t\u00f9y ch\u1ecdn tr\u00ean Excel<\/a><\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/8-cach-de-bieu-do-dep.html\">8 C\u00e1ch \u0111\u1ec3 t\u00fat l\u1ea1i bi\u1ec3u \u0111\u1ed3 t\u00e0i ch\u00ednh \u0111\u1eb9p trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ve-bieu-thuc-te-vs-ke-hoach.html\">V\u1ebd bi\u1ec3u \u0111\u1ed3 th\u1ef1c t\u1ebf vs k\u1ebf ho\u1ea1ch d\u1ea1ng\u00a0 c\u1ed9t n\u1eb1m ngang (bar)<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-422.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5038,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5037","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\/5037","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=5037"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5037\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5038"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}