{"id":11140,"date":"2025-01-15T01:49:12","date_gmt":"2025-01-15T01:49:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/do-thi-du-kien-va-do-thi-thuc-te-trong-excel\/"},"modified":"2025-01-15T01:49:12","modified_gmt":"2025-01-15T01:49:12","slug":"do-thi-du-kien-va-do-thi-thuc-te-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/do-thi-du-kien-va-do-thi-thuc-te-trong-excel\/","title":{"rendered":"\u0110\u1ed3 th\u1ecb d\u1ef1 ki\u1ebfn v\u00e0 \u0111\u1ed3 th\u1ecb th\u1ef1c t\u1ebf trong Excel"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n kh\u00e1i ni\u1ec7m \u0111\u1ed3 th\u1ecb d\u1ef1 ki\u1ebfn v\u00e0 \u0111\u1ed3 th\u1ecb th\u1ef1c t\u1ebf<\/a> c\u0169ng nh\u01b0 c\u00e1ch \u0111\u1ec3 tr\u00ecnh b\u00e0y ch\u00fang trong Excel<\/a>.<\/p>\n

<\/p>\n

B\u01b0\u1edbc 1:<\/strong> S\u1eafp x\u1ebfp d\u1eef li\u1ec7u th\u00e0nh d\u1ea1ng b\u1ea3ng nh\u01b0 sau:<\/p>\n

<\/p>\n

B\u01b0\u1edbc 2:<\/strong> B\u00f4i \u0111en v\u00e0 ch\u1ecdn d\u1ea3i \u00f4 A2:C6 -> Ch\u1ecdn Insert -> Bar Chart -> Bi\u1ec3u \u0111\u1ed3 c\u1ed9t 2D d\u1ea1ng ch\u00f9m<\/p>\n

<\/p>\n

B\u01b0\u1edbc 3:<\/strong> X\u00f3a b\u1ecf c\u00e1c \u0111\u01b0\u1eddng k\u1ebb c\u0103n d\u00f2ng \u1edf gi\u1eefa bi\u1ec3u \u0111\u1ed3<\/p>\n

B\u01b0\u1edbc 4:<\/strong> Click chu\u1ed9t ph\u1ea3i v\u00e0o \u0111\u1ed3 th\u1ecb d\u1ef1 ki\u1ebfn \u201cPlan\u201d v\u00e0 ch\u1ecdn \u201cFormat Data Series\u201d, sau \u0111\u00f3 l\u1ef1a ch\u1ecdn \u201cSecondary Axis\u201d nh\u01b0 h\u00ecnh d\u01b0\u1edbi<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

<\/p>\n

B\u01b0\u1edbc 5:<\/strong> Click chu\u1ed9t ph\u1ea3i v\u00e0o \u0111\u1ed3 th\u1ecb th\u1ef1c t\u1ebf \u201cActual\u201d v\u00e0 ch\u1ecdn \u201cFormat Data Series\u201d, sau \u0111\u00f3 trong ph\u1ea7n \u201cGap Width\u201d b\u1ea1n \u0111\u1ec3 \u0111\u1ed9 r\u1ed9ng l\u00e0 106%. Thay \u0111\u1ed5i m\u00e0u n\u1ec1n c\u1ee7a \u0111\u1ed3 th\u1ecb theo s\u1edf th\u00edch<\/p>\n

B\u01b0\u1edbc 6:<\/strong> Click chu\u1ed9t ph\u1ea3i v\u00e0o \u0111\u1ed3 th\u1ecb d\u1ef1 ki\u1ebfn \u201cPlan\u201d v\u00e0 ch\u1ecdn \u201cFormat Data Series\u201d, sau \u0111\u00f3 trong ph\u1ea7n \u201cGap Width\u201d b\u1ea1n \u0111\u1ec3 \u0111\u1ed9 r\u1ed9ng l\u00e0 314%. Thay \u0111\u1ed5i m\u00e0u n\u1ec1n c\u1ee7a \u0111\u1ed3 th\u1ecb theo s\u1edf th\u00edch<\/p>\n

B\u01b0\u1edbc 7:<\/strong> L\u1ef1a ch\u1ecdn tr\u1ee5c ho\u00e0nh ph\u1ee5 \u1edf ph\u00eda tr\u00ean c\u00f9ng c\u1ee7a bi\u1ec3u \u0111\u1ed3 v\u00e0 x\u00f3a b\u1ecf tr\u1ee5c \u0111\u00f3 \u0111i. \u0110\u1ed3ng th\u1eddi x\u00f3a \u0111i ph\u1ea7n l\u1ec1 c\u1ee7a bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 t\u1ea1o th\u00eam kho\u1ea3ng tr\u1eafng.<\/p>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 th\u00e0nh qu\u1ea3:<\/p>\n

<\/p>\n

Ph\u00e2n t\u00edch bi\u1ec3u \u0111\u1ed3<\/strong><\/p>\n

B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y trong bi\u1ec3u \u0111\u1ed3 tr\u00ean, m\u00e0u cam bi\u1ec3u th\u1ecb \u201c\u0111\u1ed3 th\u1ecb d\u1ef1 ki\u1ebfn\u201d v\u00e0 m\u00e0u x\u00e1m bi\u1ec3u th\u1ecb \u201c\u0111\u1ed3 th\u1ecb th\u1ef1c t\u1ebf\u201d. N\u1ebfu nh\u00ecn v\u00e0o c\u1ed9t Q116 (Q\u00fay 1 n\u0103m 2016), ta c\u00f3 th\u1ec3 r\u00fat ra k\u1ebft lu\u1eadn r\u1eb1ng doanh thu th\u1ef1c t\u1ebf ch\u01b0a \u0111\u1ea1t \u0111\u01b0\u1ee3c \u0111\u1ebfn m\u1ee9c d\u1ef1 b\u00e1o tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n

Ng\u01b0\u1ee3c l\u1ea1i, theo c\u1ed9t Q416 (Q\u00fay 4 n\u0103m 2016) th\u00ec ta \u0111\u00e3 ho\u00e0n th\u00e0nh v\u01b0\u1ee3t ch\u1ec9 ti\u00eau \u0111\u1ec1 ra.<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11141,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11140","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\/11140","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=11140"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11140\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11141"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}