{"id":1216,"date":"2024-12-02T04:27:17","date_gmt":"2024-12-02T04:27:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-tao-bieu-do-waterfall-bieu-do-hinh-thac-nuoc-trong-excel\/"},"modified":"2024-12-02T04:27:17","modified_gmt":"2024-12-02T04:27:17","slug":"huong-dan-tao-bieu-do-waterfall-bieu-do-hinh-thac-nuoc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-tao-bieu-do-waterfall-bieu-do-hinh-thac-nuoc-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o bi\u1ec3u \u0111\u1ed3 Waterfall, bi\u1ec3u \u0111\u1ed3 h\u00ecnh th\u00e1c n\u01b0\u1edbc trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n l\u00e0 1 ng\u01b0\u1eddi s\u1eed d\u1ee5ng Excel th\u01b0\u1eddng xuy\u00ean, b\u1ea1n ch\u1eafc ch\u1eafn s\u1ebd bi\u1ebft l\u1ee3i \u00edch c\u1ee7a bi\u1ec3u \u0111\u1ed3. Tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u b\u1eb1ng c\u00e1c h\u00ecnh \u0111\u1ed3 h\u1ecda khi\u1ebfn ch\u00fang tr\u1edf n\u00ean h\u1eefu d\u1ee5ng trong so s\u00e1nh ho\u1eb7c \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh xu h\u01b0\u1edbng trong nh\u00e1y m\u1eaft.<\/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-674d372503a51\" 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-tao-bieu-do-waterfall-bieu-do-hinh-thac-nuoc-trong-excel.html#Bieu_do_Waterfall_trong_Excel_la_gi\" title=\"Bi\u1ec3u \u0111\u1ed3 Waterfall trong Excel l\u00e0 g\u00ec?\">Bi\u1ec3u \u0111\u1ed3 Waterfall trong Excel l\u00e0 g\u00ec?<\/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-tao-bieu-do-waterfall-bieu-do-hinh-thac-nuoc-trong-excel.html#Lam_sao_de_tao_bieu_do_Waterfall\" title=\"L\u00e0m sao \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 Waterfall\">L\u00e0m sao \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 Waterfall<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Bieu_do_Waterfall_trong_Excel_la_gi\"><\/span><strong>Bi\u1ec3u \u0111\u1ed3 Waterfall trong Excel l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ea7u ti\u00ean, h\u00e3y xem bi\u1ec3u \u0111\u1ed3 Waterfall tr\u00f4ng \u0111\u01a1n gi\u1ea3n nh\u01b0 th\u1ebf n\u00e0o v\u00e0 khi n\u00e0o n\u00f3 tr\u1edf n\u00ean c\u00f3 \u00edch.<\/p>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 Waterfall th\u1ef1c ra l\u00e0 m\u1ed9t lo\u1ea1i bi\u1ec3u \u0111\u1ed3 \u0111\u1eb7c bi\u1ec7t trong nh\u00f3m bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u1ee7a Excel. N\u00f3 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ch\u1ee9ng minh: t\u1eeb m\u1ed9t v\u1ecb tr\u00ed ban \u0111\u1ea7u \u0111\u00e3 t\u0103ng ho\u1eb7c gi\u1ea3m qua h\u00e0ng lo\u1ea1t c\u00e1c thay \u0111\u1ed5i nh\u01b0 th\u1ebf n\u00e0o.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/waterfall-chart.png\" alt=\"Use a standard Excel Stacked Column chart type to create a waterfall chart in Excel\" title=\"waterfall-chart\"><\/p>\n<p style=\"text-align: justify\">C\u1ed9t \u0111\u1ea7u ti\u00ean v\u00e0 cu\u1ed1i c\u00f9ng c\u1ee7a bi\u1ec3u \u0111\u1ed3 Waterfall \u0111i\u1ec3n h\u00ecnh \u0111\u1ea1i di\u1ec7n cho t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb. C\u00e1c c\u1ed9t trung gian xu\u1ea5t hi\u1ec7n l\u01a1 l\u1eedng, cho th\u1ea5y \u0111\u01b0\u1ee3c s\u1ef1 thay \u0111\u1ed5i t\u00edch c\u1ef1c hay ti\u00eau c\u1ef1c t\u1eeb giai \u0111o\u1ea1n n\u00e0y \u0111\u1ebfn giai \u0111o\u1ea1n kh\u00e1c, v\u00e0 k\u1ebft th\u00fac b\u1eb1ng c\u1ed9t t\u1ed5ng gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng. Theo nguy\u00ean t\u1eafc, c\u00e1c c\u1ed9t n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c m\u00e3 h\u00f3a th\u00e0nh c\u00e1c m\u00e0u \u0111\u1ec3 ph\u00e2n bi\u1ec7t c\u00e1c gi\u00e1 tr\u1ecb t\u00edch c\u1ef1c v\u00e0 ti\u00eau c\u1ef1c. V\u00e0 ngo\u00e0i ra, trong b\u00e0i n\u00e0y b\u1ea1n s\u1ebd bi\u1ebft \u0111\u01b0\u1ee3c c\u00e1ch l\u00e0m sao cho c\u00e1c c\u1ed9t trung gian l\u01a1 l\u1eedng.<\/p>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 Waterfall c\u00f2n \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 bi\u1ec3u \u0111\u1ed3 th\u00e1c n\u01b0\u1edbc\u00a0trong Excel, v\u00ec c\u00e1c c\u1ed9t l\u01a1 l\u1eedng t\u1ea1o ra h\u00ecnh d\u00e1ng nh\u01b0 nh\u1eefng th\u00e1c n\u01b0\u1edbc..<\/p>\n<p style=\"text-align: justify\">C\u00e1c bi\u1ec3u \u0111\u1ed3 n\u00e0y kh\u00e1 h\u1eefu \u00edch cho c\u00e1c m\u1ee5c \u0111\u00edch ph\u00e2n t\u00edch. N\u1ebfu b\u1ea1n ph\u1ea3i \u0111\u00e1nh gi\u00e1 l\u1ee3i nhu\u1eadn c\u1ee7a c\u00f4ng ty ho\u1eb7c doanh thu t\u1eeb c\u00e1c s\u1ea3n ph\u1ea9m, h\u00e3y l\u00e0m m\u1ed9t b\u1ea3n ki\u1ec3m k\u00ea ho\u1eb7c ph\u00e2n t\u00edch doanh s\u1ed1 b\u00e1n h\u00e0ng, ho\u1eb7c ch\u1ec9 l\u00e0 \u0111\u01b0a ra s\u1ed1 l\u01b0\u1ee3ng b\u1ea1n b\u00e8 tr\u00ean Facebook c\u1ee7a b\u1ea1n thay \u0111\u1ed5i nh\u01b0 th\u1ebf n\u00e0o trong su\u1ed1t n\u0103m \u0111\u00f3, bi\u1ec3u \u0111\u1ed3 Waterfall trong Excel ch\u00ednh l\u00e0 nh\u1eefng g\u00ec b\u1ea1n c\u1ea7n.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-29.gif\" title=\"vba101_92019-nho-29\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-85.gif\" title=\"ex101_92019-nho-85\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2013\">H\u01b0\u1edbng d\u1eabn h\u1ecdc excel 2013<\/a> th\u00e0nh th\u1ea1o<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_sao_de_tao_bieu_do_Waterfall\"><\/span><strong>L\u00e0m sao \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 Waterfall<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1eebng t\u1ed1n th\u1eddi gian c\u1ee7a b\u1ea1n v\u00e0o vi\u1ec7c t\u00ecm ki\u1ebfm bi\u1ec3u \u0111\u1ed3 Waterfall trong Excel, b\u1ea1n s\u1ebd kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c ch\u00fang \u0111\u00e2u. V\u1ea5n \u0111\u1ec1 l\u00e0 Exel kh\u00f4ng h\u1ec1 c\u00f3 m\u1eabu bi\u1ec3u \u0111\u1ed3 Waterfall \u0111\u01b0\u1ee3c t\u1ea1o s\u1eb5n n\u00e0o. Tuy nhi\u00ean b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u1ea1o cho ri\u00eang b\u1ea1n m\u1ed9t phi\u00ean b\u1ea3n b\u1eb1ng vi\u1ec7c s\u1eafp x\u1ebfp d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch c\u1ea9n th\u1eadn v\u00e0 s\u1eed d\u1ee5ng m\u1ed9t lo\u1ea1i bi\u1ec3u \u0111\u1ed3 ti\u00eau chu\u1ea9n c\u1ed9t x\u1ebfp ch\u1ed3ng trong Excel.<\/p>\n<p style=\"text-align: justify\">H\u00e3y l\u00e0m m\u1ed9t v\u00ed d\u1ee5 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb t\u00edch c\u1ef1c v\u00e0 ti\u00eau c\u1ef1c \u0111\u1ec3 hi\u1ec3u \u0111i\u1ec1u n\u00e0y t\u1ed1t h\u01a1n. T\u00f4i s\u1ebd l\u1ea5y s\u1ed1 ti\u1ec1n b\u00e1n h\u00e0ng l\u00e0m v\u00ed d\u1ee5. N\u1ebfu b\u1ea1n nh\u00ecn v\u00e0o b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n s\u1ebd th\u1ea5y r\u1eb1ng doanh s\u1ed1 b\u00e1n h\u00e0ng t\u0103ng l\u00ean trong v\u00e0i th\u00e1ng v\u00e0 ch\u00fang gi\u1ea3m xu\u1ed1ng trong nh\u1eefng th\u00e1ng kh\u00e1c so v\u1edbi v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sample-data-table.png\" alt=\"Make a simple table with positive and negative values to provide data for a waterfall chart\" title=\"sample-data-table\"><\/p>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 th\u00e1c n\u01b0\u1edbc Excel s\u1ebd l\u00e0 m\u1ed9t c\u00e1ch ho\u00e0n h\u1ea3o \u0111\u1ec3 l\u00e0m cho ch\u00fang ta th\u1ea5y s\u1ef1 bi\u1ebfn \u0111\u1ed9ng c\u1ee7a vi\u1ec7c b\u00e1n h\u00e0ng trong m\u01b0\u1eddi hai th\u00e1ng. Nh\u01b0ng n\u1ebfu b\u1ea1n \u00e1p d\u1ee5ng m\u1eabu bi\u1ec3u \u0111\u1ed3 Stacked Column l\u00ean c\u00e1c gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 l\u00fac n\u00e0y, b\u1ea1n s\u1ebd kh\u00f4ng c\u00f3 bi\u1ec3u \u0111\u1ed3 gi\u1ed1ng v\u1edbi bi\u1ec3u \u0111\u1ed3 Waterfall. V\u00ec v\u1eady, \u0111i\u1ec1u \u0111\u1ea7u ti\u00ean b\u1ea1n n\u00ean l\u00e0m l\u00e0 s\u1eafp x\u1ebfp l\u1ea1i d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch c\u1ea9n th\u1eadn.<\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 1: S\u1eafp x\u1ebfp l\u1ea1i b\u1ea3ng d\u1eef li\u1ec7u<\/strong><\/p>\n<p style=\"text-align: justify\">B\u1eaft \u0111\u1ea7u b\u1eb1ng vi\u1ec7c ch\u00e8n th\u00eam 3 c\u1ed9t trong b\u1ea3ng excel c\u1ee7a b\u1ea1n. h\u00e3y g\u1ecdi ch\u00fang l\u00e0 C\u01a1 s\u1edf (base), t\u0103ng (Rise) v\u00e0 gi\u1ea3m (fall). C\u1ed9t c\u01a1 s\u1edf s\u1ebd l\u00e0 m\u1ed9t kho\u1ea3n ti\u1ec1n \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n s\u1eed d\u1ee5ng nh\u01b0 m\u1ed9t \u0111i\u1ec3m kh\u1edfi \u0111\u1ea7u c\u1ee7a m\u1ed9t lo\u1ea1t c\u00e1c t\u0103ng gi\u1ea3m trong bi\u1ec3u \u0111\u1ed3. T\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 \u00e2m t\u1eeb c\u1ed9t bi\u1ebfn \u0111\u1ed9ng b\u00e1n h\u00e0ng s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t v\u00e0o c\u1ed9t gi\u1ea3m, v\u00e0 c\u00e1c s\u1ed1 d\u01b0\u01a1ng s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t v\u00e0o c\u1ed9t t\u0103ng.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/modify-data-table.png\" alt=\"Insert three additional columns to modify the data table\" title=\"modify-data-table\"><\/p>\n<p style=\"text-align: justify\">HEO c\u0169ng \u0111\u00e3 th\u00eam v\u00e0o h\u00e0ng\u00a0 End \u00a0v\u00e0o cu\u1ed1i c\u1ed9t Th\u00e1ng \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 ti\u1ec1n b\u00e1n h\u00e0ng c\u1ea3 n\u0103m. B\u00e2y gi\u1edd chuy\u1ec3n sang b\u01b0\u1edbc k\u1ebf ti\u1ebfp v\u00e0 \u0111i\u1ec1n v\u00e0o c\u00e1c c\u1ed9t n\u00e0y c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n thi\u1ebft.<\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 2: Ch\u00e8n c\u00f4ng th\u1ee9c<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 ho\u00e0n th\u00e0nh b\u1ea3ng l\u00e0 nh\u1eadp c\u00e1c c\u00f4ng th\u1ee9c \u0111\u1eb7c bi\u1ec7t v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean trong c\u00e1c c\u1ed9t t\u01b0\u01a1ng \u1ee9ng v\u00e0 sau \u0111\u00f3 sao ch\u00e9p ch\u00fang xu\u1ed1ng c\u00e1c \u00f4 li\u1ec1n k\u1ec1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng n\u00fat \u0111i\u1ec1n.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 C4 trong c\u1ed9t gi\u1ea3m v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c sau:<strong> =IF(E4&lt;=0, -E4,0)<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c n\u00e0y ch\u1ec9 ra r\u1eb1ng n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 C4 nh\u1ecf ho\u1eb7c b\u1eb1ng 0, s\u1ed1 \u00e2m s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec7n th\u1ecb l\u00e0 s\u1ed1 d\u01b0\u01a1ng v\u00e0 s\u1ed1 d\u01b0\u01a1ng \u0111\u01b0\u1ee3c hi\u1ec7n th\u1ecb l\u00e0 s\u1ed1 0.<\/p>\n<p style=\"text-align: justify\">Ghi ch\u00fa: n\u1ebfu b\u1ea1n mu\u1ed1n c\u00e1c gi\u00e1 tr\u1ecb trong bi\u1ec3u \u0111\u1ed3 Waterfall n\u1eb1m tr\u00ean 0, b\u1ea1n c\u1ea7n ph\u1ea3i nh\u1eadp d\u1ea5u tr\u1eeb (-) tr\u01b0\u1edbc tham chi\u1ebfu \u00f4 th\u1ee9 hai (E4) trong c\u00f4ng th\u1ee9c. V\u00e0 hai d\u1ea5u tr\u1eeb s\u1ebd t\u1ea1o ra m\u1ed9t \u0111i\u1ec3m c\u1ed9ng.<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn h\u1ebft b\u1ea3ng.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fall-column-formula.png\" alt=\"Type in the formula in the first cell of the Fall column and copy it down with the fill handle\" title=\"fall-column-formula\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Ch\u1ecdn v\u00e0 nh\u1eadp v\u00e0o \u00f4 D4 <strong>=IF(E4&gt;0, E4,0)<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u00ean ngh\u0129a l\u00e0 n\u1ebfu m\u1ecdi gi\u00e1 tr\u1ecb trong \u00f4 E4 l\u1edbn h\u01a1n 0, nh\u1eefng s\u1ed1 d\u01b0\u01a1ng \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean, nh\u1eefng s\u1ed1 \u00e2m s\u1ebd \u0111\u01b0\u1ee3c ghi l\u00e0 0.<\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>S\u1eed d\u1ee5ng Fill handle k\u00e9o \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c n\u00e0y xu\u1ed1ng c\u00e1c c\u1ed9t.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/rise-column-formula.png\" alt=\"Enter the formula in the Rise column and copy it down to the adjacent cells\" title=\"rise-column-formula\"><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>Ch\u00e8n c\u00f4ng th\u1ee9c cu\u1ed1i c\u00f9ng <strong>= B4 + D4-C5<\/strong> trong \u00f4 B5 v\u00e0 sao ch\u00e9p n\u00f3; Bao g\u1ed3m h\u00e0ng Cu\u1ed1i c\u00f9ng (end).<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/base-column-formula.png\" alt=\"Insert the formula to calculate base values\" title=\"base-column-formula\"><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c n\u00e0y t\u00ednh to\u00e1n c\u00e1c gi\u00e1 tr\u1ecb c\u01a1 s\u1edf v\u00e0 s\u1ebd t\u1ea1o ra c\u00e1c kho\u1ea3ng t\u0103ng gi\u1ea3m v\u1edbi chi\u1ec1u cao th\u00edch h\u1ee3p.<\/p>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel<\/a> Online t\u1ea1i H\u00e0 N\u1ed9i<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 3: t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 x\u1ebfp ch\u1ed3ng ti\u00eau chu\u1ea9n<\/strong><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ed5 ch\u1ee9c t\u1ed1t v\u00e0 b\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng \u0111\u1ec3 x\u00e2y d\u1ef1ng bi\u1ec3u \u0111\u1ed3 cho ch\u00ednh n\u00f3.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n bao g\u1ed3m c\u00e1c ti\u00eau \u0111\u1ec1 c\u1ed9t v\u00e0 h\u00e0ng, lo\u1ea1i tr\u1eeb c\u1ed9t l\u01b0u l\u01b0\u1ee3ng b\u00e1n h\u00e0ng.<\/li>\n<li>Chuy\u1ec3n \u0111\u1ebfn nh\u00f3m <strong>Charts<\/strong> tr\u00ean tab <strong>INSERT<\/strong>.<\/li>\n<li>Nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong>Insert Column Chart<\/strong> v\u00e0 ch\u1ecdn <strong>Stacked Column<\/strong> t\u1eeb danh s\u00e1ch.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/column-charts.png\" alt=\"Click on the Insert Column Chart icon to open the drop-down menu\" title=\"column-charts\"><\/p>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 xu\u1ea5t hi\u1ec7n trong trang t\u00ednh, nh\u01b0ng ch\u01b0a c\u00f3 d\u1ea1ng Waterfall. H\u00e3y ti\u1ebfp t\u1ee5c c\u00e1c b\u01b0\u1edbc ti\u1ebfp theo.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/standard-stacked-column.png\" alt=\"Choose Stacked Column from the drop-down menu to apply it to your data\" title=\"standard-stacked-column\"><\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 4. Chuy\u1ec3n bi\u1ec3u \u0111\u1ed3 C\u1ed9t th\u00e0nh bi\u1ec3u \u0111\u1ed3 Waterfall.<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u00e3 \u0111\u1ebfn l\u00fac bi\u1ebft \u0111\u01b0\u1ee3c b\u00ed quy\u1ebft. B\u1ea1n ch\u1ec9 c\u1ea7n l\u00e0m cho h\u00e0ng lo\u1ea1t c\u00e1c c\u1ed9t c\u01a1 s\u1edf v\u00f4 h\u00ecnh \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t bi\u1ec3u \u0111\u1ed3 Waterfall t\u1eeb Stacked Column.<\/p>\n<ol style=\"text-align: justify\">\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o chu\u1ed7i Base \u0111\u1ec3 ch\u1ecdn ch\u00fang, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn <strong>Format Data Series \u2026<\/strong> l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng ch\u1ecdn.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-data-series.png\" alt=\"Right-click on the Base series and choose the Format Data Series option from the menu\" title=\"format-data-series\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Ch\u1ecdn v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong>Fill &amp; Line.<\/strong><\/li>\n<li>Ch\u1ecdn <strong>No Fill<\/strong> trong ph\u1ea7n <strong>Fill<\/strong> v\u00e0 <strong>No Line<\/strong> trong ph\u1ea7n <strong>Border<\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/transform-column-chart.png\" alt=\"Select No fill and No line in the Format Data Series pane to transform the column graph into a waterfall chart\" title=\"transform-column-chart\"><\/p>\n<p style=\"text-align: justify\">Khi c\u00e1c c\u1ed9t m\u00e0u xanh tr\u1edf n\u00ean v\u00f4 h\u00ecnh, ch\u1ec9 c\u1ea7n x\u00f3a Base kh\u1ecfi ph\u1ea7n ch\u00fa th\u00edch c\u1ee7a bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 \u1ea9n ho\u00e0n to\u00e0n t\u1ea5t c\u1ea3 c\u00e1c d\u1ea5u v\u1ebft c\u1ee7a chu\u1ed7i Base.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/simple-waterfall-chart.png\" alt=\"Make the Base series invisible to get a waterfall chart\" title=\"simple-waterfall-chart\"><\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 5. \u0110\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3 c\u1ea7u<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e3y k\u1ebft th\u00fac b\u1eb1ng m\u1ed9t v\u00e0i \u0111\u1ecbnh d\u1ea1ng. \u0110\u1ea7u ti\u00ean t\u00f4i s\u1ebd l\u00e0m cho ph\u1ea7n l\u01a1 l\u1eedng s\u00e1ng h\u01a1n v\u00e0 l\u00e0m \u0111i\u1ec3m nh\u1ea5n cho c\u00e1c c\u1ed9t gi\u00e1 tr\u1ecb B\u1eaft \u0111\u1ea7u v\u00e0 K\u1ebft th\u00fac trong bi\u1ec3u \u0111\u1ed3:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn lo\u1ea1t c\u00e1c c\u1ed9t gi\u1ea3m trong bi\u1ec3u \u0111\u1ed3 v\u00e0 ch\u1ecdn tab FORMAT d\u01b0\u1edbi CHART TOOLS<\/li>\n<li>Nh\u1ea5p v\u00e0o SHAPE FILL trong nh\u00f3m Shape Styles.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-column-color.png\" alt=\"Click on Shape Fill in the Shape styles group on the Format tab to change the column color\" title=\"change-column-color\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Ch\u1ecdn m\u00e0u b\u1ea1n mu\u1ed1n trong b\u1ea3ng ch\u1ecdn \u0111\u01b0\u1ee3c th\u1ea3 xu\u1ed1ng.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u1ede \u0111\u00e2y b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1eed nghi\u1ec7m v\u1edbi \u0111\u01b0\u1eddng vi\u1ec1n c\u1ed9t ho\u1eb7c th\u00eam c\u00e1c hi\u1ec7u \u1ee9ng \u0111\u1eb7c bi\u1ec7t cho ch\u00fang. Ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng <strong>Shape Outline<\/strong> v\u00e0 <strong>Shape Effects<\/strong> tr\u00ean tab <strong>FORMAT<\/strong> \u0111\u1ec3 thay \u0111\u1ed5i.<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n n\u00ean l\u00e0m gi\u1ed1ng nh\u01b0 v\u1eady v\u1edbi h\u00e0ng lo\u1ea1t gi\u00e1 tr\u1ecb t\u0103ng. \u0110\u1ed1i v\u1edbi c\u00e1c c\u1ed9t B\u1eaft \u0111\u1ea7u v\u00e0 K\u1ebft th\u00fac, b\u1ea1n c\u1ea7n m\u00e3 m\u00e0u ri\u00eang l\u1ebb, nh\u01b0ng ch\u00fang ph\u1ea3i c\u00f3 c\u00f9ng m\u1ed9t m\u00e0u.<\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n \u0111\u00e3 ho\u00e0n t\u1ea5t, bi\u1ec3u \u0111\u1ed3 s\u1ebd gi\u1ed1ng nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/formatted-bridge-chart.png\" alt=\"Color-code the columns in the chart to make it more readable\" title=\"formatted-bridge-chart\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd:<\/strong>Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i m\u00e0u s\u1eafc v\u00e0 \u0111\u01b0\u1eddng vi\u1ec1n c\u1ee7a c\u00e1c c\u1ed9t trong bi\u1ec3u \u0111\u1ed3 b\u1eb1ng c\u00e1ch m\u1edf b\u1ea3ng <strong>Format Data Series<\/strong> ho\u1eb7c ch\u1ecdn c\u00e1c tu\u1ef3 ch\u1ecdn <strong>Fill<\/strong> ho\u1eb7c <strong>Outline<\/strong> trong menu chu\u1ed9t ph\u1ea3i.<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba gi\u1eefa c\u00e1c c\u1ed9t \u0111\u1ec3 l\u00e0m cho ch\u00fang \u0111\u1ee9ng g\u1ea7n nhau h\u01a1n:<\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5p \u0111\u00fap v\u00e0o m\u1ed9t trong c\u00e1c c\u1ed9t bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 m\u1edf b\u1ea3ng \u0111\u1ecbnh d\u1ea1ng Data Series.<\/li>\n<li>Thay \u0111\u1ed5i <strong>Gap Width<\/strong> nh\u1ecf h\u01a1n, nh\u01b0 15%. \u0110\u00f3ng h\u1ed9p tho\u1ea1i<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-excess-space.png\" alt=\"Double-click on any column to display the Format Data Series pane and reduce the gap width\" title=\"remove-excess-space\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c c\u1ed9t \u0111\u00e3 g\u1ea7n l\u1ea1i.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-gap-width.png\" alt=\"Change the gap width in the Format Data Series pane to remove excess space between columns\" title=\"change-gap-width\"><\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n nh\u00ecn v\u00e0o s\u01a1 \u0111\u1ed3 Waterfall \u1edf tr\u00ean, m\u1ed9t s\u1ed1 ph\u1ea7n l\u01a1 l\u1eedng d\u01b0\u1eddng nh\u01b0 c\u00f3 c\u00f9ng k\u00edch c\u1ee1. Tuy nhi\u00ean, khi b\u1ea1n tham kh\u1ea3o b\u1ea3ng d\u1eef li\u1ec7u, b\u1ea1n s\u1ebd th\u1ea5y r\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y kh\u00e1c nhau. \u0110\u1ec3 ph\u00e2n t\u00edch ch\u00ednh x\u00e1c h\u01a1n, t\u00f4i khuy\u00ean b\u1ea1n n\u00ean th\u00eam nh\u00e3n d\u1eef li\u1ec7u v\u00e0o c\u00e1c c\u1ed9t.<\/p>\n<ol style=\"text-align: justify\" start=\"6\">\n<li>Ch\u1ecdn chu\u1ed7i b\u1ea1n mu\u1ed1n g\u1eafn nh\u00e3n.<\/li>\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn <strong>Add data Labels<\/strong> t\u1eeb b\u1ea3ng ch\u1ecdn.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-data-labels.png\" alt=\"Select the series, right-click and choose the Add Data Labels option to mark columns with the values\" title=\"add-data-labels\"><\/p>\n<p style=\"text-align: justify\">L\u1eb7p l\u1ea1i quy tr\u00ecnh cho chu\u1ed7i kh\u00e1c. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh v\u1ecb tr\u00ed nh\u00e3n, ph\u00f4ng ch\u1eef v\u00e0 m\u00e0u s\u1eafc \u0111\u1ec3 l\u00e0m cho con s\u1ed1 d\u1ec5 \u0111\u1ecdc h\u01a1n.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong>:\u00a0 N\u1ebfu c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t r\u00f5 r\u00e0ng v\u1ec1 k\u00edch th\u01b0\u1edbc c\u1ed9t v\u00e0 c\u00e1c chi ti\u1ebft c\u1ee5 th\u1ec3 m\u00e0 kh\u00f4ng quan tr\u1ecdng, b\u1ea1n c\u00f3 th\u1ec3 b\u1ecf qua c\u00e1c nh\u00e3n d\u1eef li\u1ec7u, nh\u01b0ng sau \u0111\u00f3 b\u1ea1n n\u00ean th\u00eam m\u1ed9t tr\u1ee5c Y \u0111\u1ec3 gi\u1ea3i th\u00edch d\u1eef li\u1ec7u t\u1ed1t h\u01a1n.<\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh vi\u1ec7c ghi nh\u00e3n c\u00e1c c\u1ed9t, ch\u1ec9 c\u1ea7n lo\u1ea1i b\u1ecf c\u00e1c y\u1ebfu t\u1ed1 kh\u00f4ng c\u1ea7n thi\u1ebft nh\u01b0 c\u00e1c gi\u00e1 tr\u1ecb b\u1eb1ng kh\u00f4ng v\u00e0 c\u00e1c ch\u00fa gi\u1ea3i. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 thay \u0111\u1ed5i ti\u00eau \u0111\u1ec1 b\u1ea3ng x\u1ebfp h\u1ea1ng m\u1eb7c \u0111\u1ecbnh sang m\u00f4 t\u1ea3 chi ti\u1ebft h\u01a1n. Vui l\u00f2ng xem m\u1ed9t trong c\u00e1c b\u00e0i \u0111\u0103ng tr\u00ean blog tr\u01b0\u1edbc c\u1ee7a t\u00f4i v\u1ec1 c\u00e1ch th\u00eam ti\u00eau \u0111\u1ec1 v\u00e0o bi\u1ec3u \u0111\u1ed3 Excel.<\/p>\n<p style=\"text-align: justify\">Bi\u1ec3u \u0111\u1ed3 Waterfall c\u1ee7a HEO\u00a0\u0111\u00e3 xong! N\u00f3 c\u00f3 v\u1ebb ho\u00e0n to\u00e0n kh\u00e1c so v\u1edbi c\u00e1c lo\u1ea1i bi\u1ec3u \u0111\u1ed3 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u00e0 n\u00f3 r\u1ea5t d\u1ec5 \u0111\u1ecdc, ph\u1ea3i kh\u00f4ng?<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/labelled-waterfall-chart.png\" alt=\"Add data labels to the columns in the chart to make it complete\" title=\"labelled-waterfall-chart\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">Th\u00e0nh th\u1ea1o Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao trong 7 ng\u00e0y<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">T\u1ea1o bi\u1ec3u \u0111\u1ed3 l\u00e0 m\u1ed9t trong nh\u1eefng t\u00ednh n\u0103ng c\u1ee7a Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t. Tuy nhi\u00ean \u0111\u1ec3 t\u1ea1o \u0111\u01b0\u1ee3c m\u1ed9t bi\u1ec3u \u0111\u1ed3 v\u00e0 m\u1ed9t bi\u1ec3u \u0111\u1ed3 \u0111\u1eb9p th\u00ec kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch l\u00e0m. C\u00f9ng kh\u00e1m ph\u00e1 nh\u1eefng t\u00ednh n\u0103ng \u01b0u vi\u1ec7t c\u1ee7a Excel t\u1ea1i kh\u00f3a h\u1ecdc c\u1ee7a\u00a0<a href=\"http:\/\/bit.ly\/2mWmtzP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> H\u1ecdc Excel Online n\u00e0o. T\u1ea1i kh\u00f3a h\u1ecdc n\u00e0y, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ecdc Excel t\u1eeb c\u01a1 b\u1ea3n nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, t\u1edbi nh\u1eefng ki\u1ebfn th\u1ee9c kh\u00f3 h\u01a1n v\u00e0 c\u00e1c ki\u1ebfn th\u1ee9c Excel n\u00e2ng cao. Sau khi k\u1ebft th\u00fac kh\u00f3a h\u1ecdc, b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 tin x\u1eed l\u00fd c\u00f4ng vi\u1ec7c trong nh\u00e1y m\u1eaft. Th\u00f4ng tin chi ti\u1ebft kh\u00f3a h\u1ecdc, b\u1ea1n tham kh\u1ea3o t\u1ea1i \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\">\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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-29.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1217,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1216","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1216","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=1216"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1216\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1217"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}