{"id":8308,"date":"2024-12-22T06:33:58","date_gmt":"2024-12-22T06:33:58","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-ve-thermometer-goal-chart-bieu-do-nhiet-ke-trong-excel\/"},"modified":"2024-12-22T06:33:58","modified_gmt":"2024-12-22T06:33:58","slug":"huong-dan-ve-thermometer-goal-chart-bieu-do-nhiet-ke-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-ve-thermometer-goal-chart-bieu-do-nhiet-ke-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn v\u1ebd Thermometer Goal Chart (bi\u1ec3u \u0111\u1ed3 nhi\u1ec7t k\u1ebf) trong Excel"},"content":{"rendered":"
\n

Thermometer Goal Chart (bi\u1ec3u \u0111\u1ed3 nhi\u1ec7t k\u1ebf) l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu d\u1ee5ng \u0111\u1ec3 b\u1ea1n bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u th\u1ef1c t\u1ebf so v\u1edbi m\u1ee9c ch\u1ec9 ti\u00eau. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 nhi\u1ec7t k\u1ebf trong Excel.<\/em><\/p>\n

T\u1ea1o\u00a0Thermometer Goal Chart (bi\u1ec3u \u0111\u1ed3 nhi\u1ec7t k\u1ebf) trong Excel<\/h3>\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u sau, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/strong><\/a> th\u00f4ng th\u01b0\u1eddng<\/p>\n

<\/p>\n

Ch\u1ecdn v\u00f9ng t\u1ed5ng, sau \u0111\u00f3 v\u00e0o\u00a0Insert > Chart > Clustered Column Chart<\/strong><\/p>\n

<\/p>\n

\u00a0<\/p>\n

Sau \u0111\u00f3 t\u1ea1i th\u1ebb Chart Design, ch\u1ecdn\u00a0Switch Row\/Column<\/strong><\/p>\n

<\/p>\n

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

Ti\u1ebfp \u0111\u00f3, click chu\u1ed9t ph\u1ea3i v\u00e0o c\u1ed9t d\u1eef li\u1ec7u m\u1ee5c ti\u00eau (m\u1eb7c \u0111\u1ecbnh s\u1ebd c\u00f3 m\u00e0u cam) v\u00e0 ch\u1ecdn\u00a0Format Data Series\u2026<\/strong><\/p>\n

<\/p>\n

\u00a0<\/p>\n

T\u1ea1i\u00a0khung ch\u1ecdn v\u1eeba hi\u1ec7n ra, \u0111\u01b0a d\u1eef li\u1ec7u v\u1ec1\u00a0Secondary Axis<\/strong><\/p>\n

<\/p>\n

B\u01b0\u1edbc k\u1ebf ti\u1ebfp \u0111\u1ec3 t\u1ea1o\u00a0Thermometer Goal Chart \u0111\u00f3 l\u00e0 click chu\u1ed9t ph\u1ea3i v\u00e0o tr\u1ee5c d\u1ecdc b\u00ean tr\u00e1i (left V-Axis) v\u00e0 ti\u1ebfp t\u1ee5c ch\u1ecdn\u00a0Format Axis\u2026<\/strong><\/p>\n

<\/p>\n

Trong khung Format Axis, ta \u0111\u01b0a gi\u00e1 tr\u1ecb Maximum b\u1eb1ng v\u1edbi gi\u00e1 tr\u1ecb m\u1ee5c ti\u00eau (20000):<\/p>\n

<\/p>\n

\u00a0<\/p>\n

Ti\u1ebfn h\u00e0nh x\u00f3a tr\u1ee5c d\u1ecdc b\u00ean ph\u1ea3i b\u1eb1ng c\u00e1ch click v\u00e0o v\u00e0 \u1ea5n ph\u00edm\u00a0Delete:<\/strong><\/p>\n

<\/p>\n

\u00a0<\/p>\n

Format Data Series\u00a0<\/strong>th\u00eam m\u1ed9t l\u1ea7n n\u1eefa:<\/p>\n

<\/p>\n

\u00a0<\/p>\n

Ti\u1ebfn h\u00e0nh c\u00e1c thao t\u00e1c sau:<\/p>\n

Fill:<\/strong> no Fill<\/p>\n

Border<\/strong>: Solid Line c\u00f9ng m\u00e0u v\u1edbi c\u1ed9t doanh thu th\u1ef1c<\/p>\n

<\/p>\n

\u00a0<\/p>\n

Ti\u1ebfn h\u00e0nh lo\u1ea1i b\u1ecf ti\u00eau \u0111\u1ec1 (Chart Title),\u00a0ch\u00fa gi\u1ea3i gi\u00e1 tr\u1ecb (Legend), tr\u1ee5c ngang (Horizontal axis) sau \u0111\u00f3 \u0111i\u1ec1u ch\u1ec9nh l\u1ea1i k\u00edch c\u1ee1 b\u1ea3ng t\u00ednh. Cu\u1ed1i c\u00f9ng thay \u0111\u1ed5i\u00a0Tick Marks<\/strong> cho tr\u1ee5c d\u1ecdc v\u00e0 ta \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c bi\u1ec3u \u0111\u1ed3 nhi\u1ec7t k\u1ebf trong Excel:<\/p>\n

<\/p>\n

\n

Xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n

T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u00e2y (Treemap chart) trong Excel<\/strong><\/a><\/p>\n

Bi\u1ec3u \u0111\u1ed3 b\u00e1nh Doughnut trong Excel<\/strong><\/a><\/p>\n

Bi\u1ec3u \u0111\u1ed3 Sunburst bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u theo c\u1ea5p b\u1eadc trong Excel<\/a><\/strong><\/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":8309,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8308","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\/8308","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=8308"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8308\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8309"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}