{"id":3728,"date":"2024-12-03T03:50:21","date_gmt":"2024-12-03T03:50:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/gioi-thieu-bieu-do-dang-cot-chong-100-trong-excel\/"},"modified":"2024-12-03T03:50:21","modified_gmt":"2024-12-03T03:50:21","slug":"gioi-thieu-bieu-do-dang-cot-chong-100-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/gioi-thieu-bieu-do-dang-cot-chong-100-trong-excel\/","title":{"rendered":"Gi\u1edbi thi\u1ec7u bi\u1ec3u \u0111\u1ed3 d\u1ea1ng c\u1ed9t ch\u1ed3ng 100% trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00f4m nay, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> mu\u1ed1n gi\u1edbi thi\u1ec7u v\u1edbi b\u1ea1n v\u1ec1 <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>c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3c\u1ed9t<\/strong><\/a> ch\u1ed3ng 100% trong Excel. \u0110\u00e2y l\u00e0 m\u1ed9t d\u1ea1ng bi\u1ec3u \u0111\u1ed3 so s\u00e1nh ph\u1ea7n tr\u0103m gi\u1eefa c\u00e1c chu\u1ed7i s\u1ed1 li\u1ec7u theo h\u00ecnh d\u1ea1ng c\u00e1c c\u1ed9t ch\u1ed3ng l\u00ean nhau, mi\u1ec5n l\u00e0 t\u1ed5ng s\u1ed1 c\u1ee7a to\u00e0n b\u1ed9 c\u00e1c c\u1ed9t \u0111\u1ea1t m\u1ee9c 100%.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9106 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/100-stacked-bar-chart.png\" width=\"600\" height=\"338\" title=\"100-stacked-bar-chart\"><\/p>\n<p style=\"text-align: justify\">Gi\u1ed1ng v\u1edbi bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n, bi\u1ec3u \u0111\u1ed3 d\u1ea1ng c\u1ed9t ch\u1ed3ng c\u0169ng th\u1ec3 hi\u1ec7n m\u1ed1i quan h\u1ec7 c\u00e1 nh\u00e2n-t\u1eadp th\u1ec3 gi\u1eefa c\u00e1c th\u00e0nh ph\u1ea7n v\u1edbi nhau. Tuy v\u1eady, \u0111i\u1ec3m kh\u00e1c bi\u1ec7t n\u1eb1m \u1edf ch\u1ed7 trong bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng ta c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y di\u1ec5n bi\u1ebfn thay \u0111\u1ed5i theo th\u1eddi gian c\u1ee7a t\u1eebng th\u00e0nh ph\u1ea7n, ch\u1eb3ng h\u1ea1n nh\u01b0 th\u1ecb ph\u1ea7n c\u1ee7a s\u1ea3n ph\u1ea9m theo t\u1eebng n\u0103m.<\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec3m chung gi\u1eefa t\u1ea5t c\u1ea3 c\u00e1c bi\u1ec3u \u0111\u1ed3 d\u1ea1ng c\u1ed9t ch\u1ed3ng \u0111\u00f3 l\u00e0 ta d\u1ec5 d\u00e0ng so s\u00e1nh \u0111\u01b0\u1ee3c chu\u1ed7i s\u1ed1 li\u1ec7u \u0111\u1ea7u ti\u00ean (n\u1eb1m \u1edf g\u1ea7n tr\u1ee5c tung\u00a0nh\u1ea5t) nh\u01b0ng vi\u1ec7c so s\u00e1nh s\u1ebd tr\u1edf n\u00ean kh\u00f3 kh\u0103n h\u01a1n \u0111\u1ed1i v\u1edbi c\u00e1c chu\u1ed7i c\u00f2n l\u1ea1i do ch\u00fang kh\u00f4ng \u0111\u01b0\u1ee3c c\u0103n l\u1ec1 \u0111\u1ec1u nhau.<\/p>\n<p style=\"text-align: justify\"><strong>\u0110i\u1ec3m c\u1ed9ng:<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>Th\u1ec3 hi\u1ec7n r\u00f5 s\u1ef1 thay \u0111\u1ed5i t\u1ec9 l\u1ec7 th\u00e0nh ph\u1ea7n theo th\u1eddi gian c\u1ee7a c\u00e1c y\u1ebfu t\u1ed1 trong b\u1ea3ng<\/li>\n<li>C\u00e1c lo\u1ea1i s\u1ed1 li\u1ec7u v\u00e0 chu\u1ed7i s\u1ed1 li\u1ec7u \u0111\u01b0\u1ee3c x\u1ebfp g\u1ecdn g\u00e0ng trong m\u1ed9t kh\u00f4ng gian v\u1eeba ph\u1ea3i<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>\u0110i\u1ec3m tr\u1eeb:<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>Kh\u00f3 kh\u0103n khi so s\u00e1nh c\u00e1c chu\u1ed7i s\u1ed1 li\u1ec7u v\u1edbi nhau, ngo\u1ea1i tr\u1eeb chu\u1ed7i s\u1ed1 li\u1ec7u \u0111\u1ea7u ti\u00ean<\/li>\n<li>C\u00e1c c\u1ed9t ch\u1ed3ng lu\u00f4n c\u00f3 t\u1ed5ng ph\u1ea7n tr\u0103m l\u00e0 100%, \u0111i\u1ec1u n\u00e0y l\u00e0m m\u1ea5t \u0111i mi\u1ec1n gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i c\u1ee7a s\u1ed1 li\u1ec7u<\/li>\n<li>Bi\u1ec3u \u0111\u1ed3 tr\u1edf n\u00ean r\u1ed1i m\u1eaft h\u01a1n n\u1ebfu nh\u01b0 th\u00eam v\u00e0o qu\u00e1 nhi\u1ec1u s\u1ed1 li\u1ec7u ho\u1eb7c lo\u1ea1i d\u1eef li\u1ec7u<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>L\u1eddi khuy\u00ean:<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>H\u1ea1n ch\u1ebf l\u01b0\u1ee3ng s\u1ed1 li\u1ec7u s\u1eed d\u1ee5ng<\/li>\n<li>Tr\u00e1nh s\u1eed d\u1ee5ng c\u00e1c bi\u1ebfn s\u1ed1 d\u1ea1ng ba chi\u1ec1u<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 tham kh\u1ea3o:<\/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-291.gif\" title=\"ex101_92019-nho-291\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol>\n<li style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 ph\u00e2n t\u00edch b\u1eb1ng \u0111\u1ea1i h\u1ecdc chuy\u00ean ng\u00e0nh n\u00e0o \u0111\u01b0\u1ee3c n\u1eef sinh \u01b0a chu\u1ed9ng nh\u1ea5t<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9111\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/popular-degrees-for-women.png\" width=\"600\" height=\"338\" title=\"popular-degrees-for-women\"><\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 m\u1ed9t b\u00e0i b\u00e1o tr\u00ean trang web forbes.com v\u1ec1 m\u1ed9t nghi\u00ean c\u1ee9u ph\u00e2n t\u00edch v\u1ec1 b\u1eb1ng \u0111\u1ea1i h\u1ecdc chuy\u00ean ng\u00e0nh n\u00e0o \u0111\u01b0\u1ee3c sinh vi\u00ean \u01b0a chu\u1ed9ng nh\u1ea5t. Danh s\u00e1ch bao g\u1ed3m 9 b\u1eb1ng c\u1ea5p kh\u00e1c nhau d\u00e0nh cho c\u1ea3 sinh vi\u00ean nam v\u00e0 n\u1eef (\u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y qua r\u1ea5t nhi\u1ec1u trang) v\u00e0 b\u1ea3ng s\u1ed1 li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y ch\u1ec9 l\u00e0 t\u00f3m t\u1eaft l\u1ea1i d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u00edch d\u1eabn, \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i theo nh\u00f3m nh\u1eefng b\u1eb1ng c\u1ea5p \u0111\u01b0\u1ee3c sinh vi\u00ean n\u1eef \u01b0u chu\u1ed9ng nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">Lo\u1ea1i b\u1ea3ng bi\u1ec3u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0 bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng 100% v\u00e0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y th\u1ec3 hi\u1ec7n v\u00ec sao bi\u1ec3u \u0111\u1ed3 d\u1ea1ng c\u1ed9t c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng tr\u00ecnh b\u00e0y t\u00ean c\u00e1c th\u00e0nh ph\u1ea7n c\u00f3 \u0111\u1ed9 d\u00e0i t\u01b0\u01a1ng \u0111\u1ed1i l\u1edbn. B\u1ea3ng s\u1ed1 li\u1ec7u s\u1ebd c\u00f3 h\u00ecnh d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9112\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/popular-degrees-for-women-data.png\" width=\"600\" height=\"320\" title=\"popular-degrees-for-women-data\"><\/p>\n<p style=\"text-align: justify\">C\u00e1ch th\u1ee9c l\u1eadp bi\u1ec3u \u0111\u1ed3 \u2013 <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016.html\">v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/a><\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>B\u1ea5m tab Data v\u00e0 l\u1ef1a ch\u1ecdn ch\u00e8n bi\u1ec3u \u0111\u1ed3 d\u1ea1ng c\u1ed9t tr\u00ean thanh Ribbon<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/popular20degrees20for20women20ribbon20insert20bar.png\" alt=\"Insert bar \/ column chart on ribbon\" width=\"446\" height=\"161\" title=\"popular20degrees20for20women20ribbon20insert20bar\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng 100% \u1edf m\u1ee5c bi\u1ec3u \u0111\u1ed3 c\u1ed9t 2D<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/popular20degrees20for20women20ribbon20select2010020bar.png\" alt=\"Select 100% stacked bar option under 2d bar charts\" title=\"popular20degrees20for20women20ribbon20select2010020bar\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1ee3c ch\u00e8n s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/popular20degrees20for20women20chart20as20inserted.png\" alt=\"100% stacked bar chart as inserted\" title=\"popular20degrees20for20women20chart20as20inserted\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn chu\u1ed7i s\u1ed1 li\u1ec7u c\u1ea7n s\u1eed d\u1ee5ng v\u00e0 \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/popular20degrees20for20women20set20bar20width.png\" alt=\"Select data series and decrease gap width\" title=\"popular20degrees20for20women20set20bar20width\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn m\u00e0u s\u1eafc t\u01b0\u01a1ng \u1ee9ng cho t\u1eebng chu\u1ed7i s\u1ed1 li\u1ec7u<\/li>\n<\/ul>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn chu\u1ed7i s\u1ed1 li\u1ec7u v\u1ec1 sinh vi\u00ean n\u1eef v\u00e0 click ch\u1ecdn v\u00e0o m\u1ee5c \u0111\u1ea3o ng\u01b0\u1ee3c th\u1ee9 t\u1ef1<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/popular20degrees20for20women20reverse20cat.png\" alt=\"Reverse category order, set horizontal axis to cross at max category\" title=\"popular20degrees20for20women20reverse20cat\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Th\u00eam ti\u00eau \u0111\u1ec1 s\u1ed1 li\u1ec7u<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/popular20degrees20for20women20chart20add20data20labels.png\" alt=\"Select chart and add data labels\" title=\"popular20degrees20for20women20chart20add20data20labels\"><\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u01b0a ph\u1ea7n ch\u00fa th\u00edch l\u00ean tr\u00ean c\u00f9ng<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/popular20degrees20for20women20move20legend20to20top.png\" alt=\"Select legend and move to top\" title=\"popular20degrees20for20women20move20legend20to20top\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c \u0111\u01b0\u1eddng k\u1ebb c\u0103n l\u1ec1<\/li>\n<\/ul>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1eb7t ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 m\u00e0 b\u1ea1n th\u00edch<\/li>\n<\/ul>\n<ul style=\"text-align: justify\">\n<li>Cu\u1ed1i c\u00f9ng \u0111\u00e2y l\u00e0 th\u00e0nh qu\u1ea3 tr\u01b0\u1edbc khi c\u0103n ch\u1ec9nh l\u1ea1i v\u1ec1 k\u00edch c\u1ee1 v\u00e0 ph\u00f4ng ch\u1eef<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/popular20degrees20for20women20chart20final.png\" alt=\"Final 100% stacked bar before resizing and adjusting font size\" title=\"popular20degrees20for20women20chart20final\"><\/p>\n<p style=\"text-align: justify\">2. Bi\u1ec3u \u0111\u1ed3 m\u00f4 t\u1ea3 m\u1ee9c \u0111\u1ed9 ho\u00e0n th\u00e0nh m\u1ee5c ti\u00eau d\u1ef1 \u00e1n<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9116\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project-goal-attainment.png\" width=\"600\" height=\"337\" title=\"project-goal-attainment\"><\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 minh h\u1ecda \u0111i\u1ec3n h\u00ecnh nh\u1ea5t c\u1ee7a bi\u1ec3u \u0111\u1ed3 d\u1ea1ng c\u1ed9t ch\u1ed3ng 100%. S\u1ed1 li\u1ec7u trong b\u1ea3ng m\u00f4 t\u1ea3 c\u00e1c d\u1ef1 \u00e1n \u0111\u00e3 th\u1ef1c hi\u1ec7n trong v\u00f2ng 3 n\u0103m tr\u1edf l\u1ea1i \u0111\u00e2y, \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i th\u00e0nh c\u00e1c m\u1ee5c ti\u00eau \u0111\u1ea1t \u0111\u01b0\u1ee3c, m\u1ee5c ti\u00eau ch\u01b0a \u0111\u1ea1t v\u00e0 m\u1ee5c ti\u00eau ho\u00e0n th\u00e0nh v\u01b0\u1ee3t k\u1ebf ho\u1ea1ch.\u00a0V\u00ed d\u1ee5 n\u00e0y cho th\u1ea5y c\u00e1ch bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng c\u00f3 th\u1ec3 th\u1ec3 hi\u1ec7n \u0111\u01b0\u1ee3c di\u1ec5n bi\u1ebfn thay \u0111\u1ed5i theo th\u1eddi gian c\u1ee7a s\u1ed1 li\u1ec7u, m\u00e0 c\u1ee5 th\u1ec3 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ta quan t\u00e2m \u0111\u1ebfn xu h\u01b0\u1edbng ng\u00e0y c\u00e0ng c\u00f3 nhi\u1ec1u d\u1ef1 \u00e1n kh\u00f4ng \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ee5c ti\u00eau \u0111\u1ec1 ra.<\/p>\n<p style=\"text-align: justify\">B\u1ea3ng s\u1ed1 li\u1ec7u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 d\u1ef1ng bi\u1ec3u \u0111\u1ed3 tr\u00ean s\u1ebd c\u00f3 h\u00ecnh d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9115\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project-goal-attainment-data-1.png\" width=\"600\" height=\"311\" title=\"project-goal-attainment-data-1\"><\/p>\n<p>C\u00e1ch th\u1ee9c l\u1eadp bi\u1ec3u \u0111\u1ed3<\/p>\n<ul>\n<li>B\u1ea5m tab Data v\u00e0 l\u1ef1a ch\u1ecdn ch\u00e8n bi\u1ec3u \u0111\u1ed3 d\u1ea1ng c\u1ed9t tr\u00ean thanh Ribbon<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project20goal20attainment20ribbon20insert20bar.png\" alt=\"Insert &gt; column chart via ribbon\" title=\"project20goal20attainment20ribbon20insert20bar\"><\/p>\n<ul>\n<li>Ch\u1ecdn bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng 100% \u1edf m\u1ee5c bi\u1ec3u \u0111\u1ed3 c\u1ed9t 2D<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project20goal20attainment20ribbon2010020column.png\" alt=\"Select 100% stacked column option under 2d bar charts\" title=\"project20goal20attainment20ribbon2010020column\"><\/p>\n<ul>\n<li>Bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1ee3c ch\u00e8n s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" title=\"Chart as inserted\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project20goal20attainment20chart20as20inserted.png\" alt=\"Chart as inserted\" width=\"480\" height=\"288\"><\/p>\n<ul>\n<li>\u0110\u01b0a ph\u1ea7n ch\u00fa th\u00edch l\u00ean tr\u00ean c\u00f9ng<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" title=\"Chart as inserted\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project20goal20attainment20move20legend.png\" alt=\"Move legend to top\" width=\"298\" height=\"338\"><\/p>\n<ul>\n<li>Ch\u1ecdn tab Data tr\u00ean th\u00e0nh Ribbon (ho\u1eb7c click chu\u1ed9t ph\u1ea3i \u0111\u1ec3 l\u1ef1a ch\u1ecdn)<\/li>\n<\/ul>\n<ul>\n<li>S\u1eafp x\u1ebfp l\u1ea1i chu\u1ed7i s\u1ed1 li\u1ec7u theo h\u01b0\u1edbng s\u1ed1 li\u1ec7u v\u1ec1 m\u1ee5c ti\u00eau ch\u01b0a \u0111\u1ea1t tr\u01b0\u1edbc.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" title=\"Reorder series to plot missed data first\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project20goal20attainment20reorder20series.png\" alt=\"Reorder series to plot missed data first\" width=\"582\" height=\"291\"><\/p>\n<ul>\n<li>S\u1eafp x\u1ebfp l\u1ea1i chu\u1ed7i s\u1ed1 li\u1ec7u theo h\u01b0\u1edbng s\u1ed1 li\u1ec7u v\u1ec1 m\u1ee5c ti\u00eau ch\u01b0a \u0111\u1ea1t tr\u01b0\u1edbc<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" title=\"Reorder series to plot missed data first\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project20goal20attainment20set20series20gap20width.png\" alt=\"Set series overlap and gap width\" width=\"291\" height=\"297\"><\/p>\n<ul>\n<li>Thi\u1ebft l\u1eadp d\u1ea5u ghi nh\u1edb\u00a0tr\u00ean tr\u1ee5c ho\u00e0nh c\u1ee7a bi\u1ec3u \u0111\u1ed3<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" title=\"Set tick marks on vertical axis\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project20goal20attainment20vertical20axis20ticks.png\" alt=\"Set tick marks on vertical axis\" width=\"291\" height=\"309\"><\/p>\n<ul>\n<li>L\u1ef1a ch\u1ecdn v\u00e0 x\u00f3a b\u1ecf n\u00e9t c\u0103n l\u1ec1 chi\u1ec1u ngang<\/li>\n<\/ul>\n<ul>\n<li>\u0110\u1ebfn \u0111\u00e2y bi\u1ec3u \u0111\u1ed3 s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" title=\"Chart in progress\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project20goal20attainment20chart20in20progress.png\" alt=\"Chart in progress\" width=\"480\" height=\"288\"><\/p>\n<ul>\n<li>Click chu\u1ed9t ph\u1ea3i v\u00e0o t\u1eebng chu\u1ed7i s\u1ed1 li\u1ec7u v\u00e0 l\u1ef1a ch\u1ecdn m\u00e0u s\u1eafc ph\u00f9 h\u1ee3p<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" title=\"Right-click and set fill color for each series\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project20goal20attainment20set20color.png\" alt=\"Right-click and set fill color for each series\" width=\"546\" height=\"319\"><\/p>\n<ul>\n<li>Cu\u1ed1i c\u00f9ng \u0111\u00e2y l\u00e0 th\u00e0nh qu\u1ea3 tr\u01b0\u1edbc khi c\u0103n ch\u1ec9nh l\u1ea1i v\u1ec1 k\u00edch c\u1ee1 v\u00e0 ph\u00f4ng ch\u1eef<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" title=\"Final 100% stacked column chart\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/project20goal20attainment20chart20final.png\" alt=\"Final 100% stacked column chart\" width=\"480\" height=\"288\"><\/p>\n<p style=\"text-align: justify\">Blog Ho\u0323c Excel online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">ho\u0323c Excel c\u01a1 ba\u0309n<\/a>\u00a0cho \u0111\u00ea\u0301n n\u00e2ng cao v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u00ea\u0309u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u01b0\u0300ng tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. 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-291.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3729,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3728","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\/3728","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=3728"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3728\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3729"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}