{"id":11217,"date":"2025-01-15T02:08:30","date_gmt":"2025-01-15T02:08:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tao-speedometer-hoac-gauge-chart-trong-excel\/"},"modified":"2025-01-15T02:08:30","modified_gmt":"2025-01-15T02:08:30","slug":"tao-speedometer-hoac-gauge-chart-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tao-speedometer-hoac-gauge-chart-trong-excel\/","title":{"rendered":"T\u1ea1o speedometer ho\u1eb7c Gauge Chart trong Excel"},"content":{"rendered":"
\n

Trong b\u00e0i n\u00e0y, H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n t\u1ea1o ra 1 Speedometer hay t\u00ean g\u1ecdi kh\u00e1c l\u00e0 Gauge Chart.<\/p>\n

Trong th\u1ef1c hi\u1ec7n b\u00e0i n\u00e0y, c\u00e1c b\u1ea1n chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n

\"bieu-do-speedometer-gauge-chart-excel-1\"<\/a><\/p>\n

T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/strong><\/a> th\u00f4ng th\u01b0\u1eddng,\u00a0 b\u1ea1n b\u1ea5m ch\u1ecdn th\u1ebb Insert, trong nh\u00f3m Charts, t\u00ecm ch\u1ecdn Doughnut Charts:<\/p>\n

<\/a><\/p>\n

B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o h\u00ecnh Doughnut r\u1ed3i ch\u1ecdn Format Data Series \u2026<\/p>\n

\"bieu-do-speedometer-gauge-chart-excel-4\"<\/a><\/p>\n

Ch\u1ecdn ph\u1ea7n h\u00ecnh l\u1edbn nh\u1ea5t c\u1ee7a Doughnut Chart sau \u0111\u00f3 b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Format Data Point \u2026 Sau \u0111\u00f3 ch\u1ecdn No Fill trong ph\u1ea7n Series Options \/ Fill v\u00e0 ch\u1ecdn No Line\u00a0trong ph\u1ea7n Series Options \/ Border cho c\u00e1c ph\u1ea7n c\u00f2n l\u1ea1i.<\/p>\n

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

<\/a><\/p>\n

<\/a><\/p>\n

B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o h\u00ecnh Doughnut sau \u0111\u00f3 ch\u1ecdn Select Data,\u00a0<\/strong> sau \u0111\u00f3 ch\u1ecdn n\u00fat Add v\u00e0 ch\u1ecdn d\u1eef li\u1ec7u nh\u01b0 h\u00ecnh minh ho\u1ea1:<\/p>\n

\"speedometer-step-4\"<\/a><\/p>\n

Sau \u0111\u00f3, b\u1ea5m ch\u1ecdn ph\u1ea7n doughnut chart v\u1eeba m\u1edbi \u0111\u01b0\u1ee3c t\u1ea1o ra, ch\u1ecdn Change Series Chart Type \u2026<\/p>\n

Sau \u0111\u00f3 ch\u1ecdn Chart Series \u201cPointer\u201d v\u00e0 ch\u1ecdn Pie Chart:<\/p>\n

<\/a> <\/a><\/p>\n

Ch\u1ecdn Pie chart v\u1eeba v\u1ebd r\u1ed3i click chu\u1ed9t ph\u1ea3i, ch\u1ecdn Format Data Series \u2026<\/p>\n

Sau \u0111\u00f3 ch\u1ecdn Plot Series On \u2026 Secondary Axis v\u00e0 Angle of first slice l\u00e0 270 \u0111\u1ed9<\/p>\n

\"speedometer-step-7\"<\/a><\/p>\n

Ch\u1ecdn mi\u1ebfng l\u1edbn nh\u1ea5t c\u1ee7a Pie chart v\u1eeba v\u1ebd, b\u1ea5m Format Data\u00a0Series, sau \u0111\u00f3 ch\u1ecdn No fill \u2026<\/p>\n

Sau \u0111\u00f3, t\u0103ng D4 l\u00ean 10 \u0111\u01a1n v\u1ecb \u0111\u1ec3 ch\u00fang ta d\u1ec5 d\u00e0ng ch\u1ecdn \u0111\u01b0\u1ee3c Data Points n\u00e0y, ch\u1ecdn data points, b\u1ea5m chu\u1ed9t ph\u1ea3i ch\u1ecdn Format Data Series r\u1ed3i sau \u0111\u00f3 t\u00f4 m\u00e0u tu\u1ef3 theo nhu c\u1ea7u c\u1ee7a c\u00e1c b\u1ea1n:<\/p>\n

<\/a><\/p>\n

Sau \u0111\u00f3 tr\u1ea3 d\u1eef li\u1ec7u c\u1ee7a D4 v\u1ec1 1 \u0111\u01a1n v\u1ecb. V\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh Speedometer \/ Gauge Chart trong Excel c\u1ee7a b\u1ea1n<\/p>\n

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