{"id":12484,"date":"2025-01-15T09:02:52","date_gmt":"2025-01-15T09:02:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ve-bieu-do-thuc-te-vs-ke-hoach\/"},"modified":"2025-01-15T09:02:52","modified_gmt":"2025-01-15T09:02:52","slug":"ve-bieu-do-thuc-te-vs-ke-hoach","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ve-bieu-do-thuc-te-vs-ke-hoach\/","title":{"rendered":"V\u1ebd bi\u1ec3u \u0111\u1ed3 th\u1ef1c t\u1ebf vs k\u1ebf ho\u1ea1ch"},"content":{"rendered":"
\n

Trong c\u00f4ng vi\u1ec7c b\u00e1o c\u00e1o, vi\u1ec7c so s\u00e1nh k\u1ebf ho\u1ea1ch so v\u1edbi th\u1ef1c t\u1ebf l\u00e0 lu\u00f4n c\u1ea7n thi\u1ebft \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh nh\u1eefng k\u1ebf ho\u1ea1ch \u0111\u00e3 \u0111\u1ec1 ra, vi\u1ec7c so s\u00e1nh n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n m\u1ed9t c\u00e1ch tr\u1ef1c quan nh\u1ea5t th\u00f4ng qua bi\u1ec3u \u0111\u1ed3 k\u1ebf ho\u1ea1ch so s\u00e1nh v\u1edbi th\u1ef1c t\u1ebf. H\u1ecdc Excel Online<\/a> xin chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n 1 c\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3 plan vs actual nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1: V\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel\u00a0<\/a><\/strong><\/p>\n

Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u A2:C6<\/strong><\/p>\n

<\/p>\n

B\u01b0\u1edbc 2: <\/strong>Ch\u1ecdn th\u1ebb Insert > Charts > 2-D Bar | Clustered Bar<\/p>\n

<\/p>\n

B\u01b0\u1edbc 3<\/strong>: Tr\u00ean \u0111\u1ed3 th\u1ecb, ch\u1ecdn series \u201cK\u1ebf ho\u1ea1ch\u201d, b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Format Data Series \u2026<\/strong><\/p>\n

<\/p>\n

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

B\u01b0\u1edbc 4: <\/strong>Ch\u1ecdn 100% trong Gap Width<\/strong><\/p>\n

<\/p>\n

B\u01b0\u1edbc 5:\u00a0<\/strong>Click chu\u1ed9t ph\u1ea3i v\u00e0o series \u201cTh\u1ef1c t\u1ebf\u201d, b\u1ea5m Format Data Series \u2026<\/strong><\/p>\n

<\/p>\n

B\u01b0\u1edbc 6:<\/strong> Trong m\u1ee5c Format Data Series<\/strong>, Click ch\u1ecdn Secondary Axis\u00a0<\/strong>r\u1ed3i ch\u1ecdn Gap Width<\/strong> l\u00e0 300%<\/p>\n

<\/p>\n

B\u01b0\u1edbc 7:\u00a0<\/strong>Xo\u00e1 nh\u1eefng th\u00e0nh ph\u1ea7n kh\u00f4ng c\u1ea7n thi\u1ebft<\/p>\n

<\/p>\n

B\u01b0\u1edbc 8<\/strong>: \u0110\u1ed5i t\u00ean bi\u1ec3u \u0111\u1ed3 v\u00e0 ho\u00e0n th\u00e0nh<\/p>\n

<\/p>\n

Nhi\u1ec1u k\u0129 thu\u1eadt l\u00e0m b\u00e1o c\u00e1o v\u00e0 bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong series DV101 \u2013 hi\u1ec3u v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u qua bi\u1ec3u \u0111\u1ed3 Excel<\/p>\n

https:\/\/www.hocexcel.online\/dv101<\/a><\/p>\n

V\u1ebd bi\u1ec3u \u0111\u1ed3 l\u00e0 m\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng \u0111\u1eb7c bi\u1ec7t c\u1ee7a Excel. \u0110\u1ec3 v\u1ebd m\u1ed9t bi\u1ec3u \u0111\u1ed3 th\u00ec kh\u00f4ng kh\u00f3, nh\u01b0ng v\u1ebd m\u1ed9t bi\u1ec3u \u0111\u1ed3 \u0111\u00fang m\u1ee5c \u0111\u00edch v\u00e0 y\u00eau c\u1ea7u th\u00ec kh\u00f4ng ph\u1ea3i vi\u1ec7c \u0111\u01a1n gi\u1ea3n, \u0111\u00f2i h\u1ecfi b\u1ea1n ph\u1ea3i hi\u1ec3u t\u00ednh n\u0103ng c\u1ee7a t\u1eebng lo\u1ea1i bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 c\u00f3 bi\u1ec3u \u0111\u1ed3 \u0111\u00fang v\u00e0 ph\u00f9 h\u1ee3p.<\/p>\n

To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: HocExcel.Online<\/a><\/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":12485,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12484","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\/12484","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=12484"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12484\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12485"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}