{"id":7258,"date":"2024-12-21T17:12:15","date_gmt":"2024-12-21T17:12:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tao-bieu-do-do-toc-do-trong-excel\/"},"modified":"2024-12-21T17:12:15","modified_gmt":"2024-12-21T17:12:15","slug":"cach-tao-bieu-do-do-toc-do-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tao-bieu-do-do-toc-do-trong-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 \u0111o t\u1ed1c \u0111\u1ed9 trong Excel"},"content":{"rendered":"
\n

B\u1ea1n c\u00f3 bao gi\u1edd t\u01b0\u1edfng t\u01b0\u1ee3ng r\u1eb1ng trong Excel c\u00f3 bi\u1ec3u \u0111\u1ed3 t\u1ed1c \u0111\u1ed9. N\u1ebfu b\u1ea1n th\u1ea5y n\u00f3 th\u00fa v\u1ecb th\u00ec h\u00e3y l\u00e0m theo h\u01b0\u1edbng d\u1eabn sau:<\/p>\n

\"doc-speedometer-1\"<\/p>\n

\u0110\u1ec3 t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 t\u1ed1c \u0111\u1ed9, \u0111\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u.<\/p>\n

1. H\u00e3y c\u1ee5 th\u1ec3 h\u00f3a v\u00f9ng d\u1eef li\u1ec7u v\u00e0 nh\u1eefng ph\u1ea7n th\u1ec3 hi\u1ec7n b\u1edfi bi\u1ec3u \u0111\u1ed3 t\u1ed1c \u0111\u1ed9. \u1ede \u0111\u00e2y, t\u00f4i s\u1ebd t\u00e1ch c\u00e1ch bi\u1ec3u \u0111\u1ed3 th\u00e0nh 3 ph\u1ea7n, v\u1eady n\u00ean t\u00f4i nh\u1eadp 30, 60, 90 trong 3 \u00f4, v\u00e0 t\u1ed5ng s\u1ed1 \u1edf cu\u1ed1i.<\/p>\n

\"doc-speedometer-2\"<\/p>\n

2. Chuy\u1ec3n qua ph\u1ea7n \u00f4 tr\u1ed1ng b\u00ean c\u1ea1nh, v\u00e0 nh\u1eadp d\u1eef li\u1ec7u sau:<\/p>\n

M\u1eb9o: Trong \u00f4 D4, nh\u1eadp c\u00f4ng th\u1ee9c =360-(D2+D3)<\/p>\n

\"doc-speedometer-3\"<\/p>\n

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

3. Ch\u1ecdn d\u1eef li\u1ec7u trong c\u1ed9t Value v\u00e0 v\u00e0o Insert<\/strong> > Other Charts<\/strong> > Doughnut<\/strong>.<\/p>\n

\"doc-speedometer-4\"<\/p>\n

Trong Excel 2013, v\u00e0o Insert<\/strong> > Insert Pie<\/strong> ho\u1eb7c Doughnut Chart<\/strong>.<\/p>\n

4. Nh\u1ea5p ph\u1ea3i v\u00e0o bi\u1ec3u \u0111\u1ed3, ch\u1ecdn Format Data Series, <\/strong>h\u1ed9p tho\u1ea1i Format Data Series<\/strong> xu\u1ea5t hi\u1ec7n, nh\u1eadp 271 v\u00e0o h\u1ed9p Angle of first slice<\/strong><\/p>\n

\"doc-speedometer-5\"<\/p>\n

5. \u0110\u00f3ng h\u1ed9p tho\u1ea1i, nh\u1ea5p ph\u1ea3i t\u1ea1i ph\u1ea7n l\u1edbn nh\u1ea5t, ch\u1ecdn Format Data Point<\/strong><\/p>\n

\"doc-speedometer-6\"<\/p>\n

6. Trong h\u1ed9p tho\u1ea1i Format Data Point<\/strong>, ch\u1ecdn Fill<\/strong> > No fill<\/strong>, v\u00e0 \u0111\u00f3ng h\u1ed9p tho\u1ea1i<\/p>\n

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

Tronng Excel 2013, nh\u1ea5p Fill & Line<\/strong> > No fill<\/strong> trong h\u1ed9p tho\u1ea1i Format Data Point.<\/strong><\/p>\n

7. Nh\u1ea5p ph\u1ea3i t\u1ea1i bi\u1ec3u \u0111\u1ed3 v\u00e0 ch\u1ecdn Select Data. <\/strong>Ch\u1ecdn n\u00fat Add khi xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i.<\/p>\n

\"doc-speedometer-8\"<\/p>\n

8. Trong h\u1ed9p tho\u1ea1i Edit Series<\/strong>, \u0111\u1eb7t t\u00ean cho v\u00f9ng d\u1eef li\u1ec7u nh\u01b0 h\u00ecnh<\/p>\n

\"doc-speedometer-9\"<\/p>\n

9. Nh\u1ea5p OK \u0111\u1ebfn khi \u0111\u00f3ng h\u1ed9p tho\u1ea1i. Nh\u1ea5p ph\u1ea3i t\u1ea1i bi\u1ec3u \u0111\u1ed3 th\u1ee9 2 (c\u00e1i ph\u00eda ngo\u00e0i), nh\u1ea5p Change Series Chart Type, <\/strong>trong h\u1ed9p tho\u1ea1i Change Chart Type <\/strong>, nh\u1ea5p Pie>Pie<\/strong>, b\u1ea5m OK<\/strong> \u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i.<\/p>\n

\"doc-speedometer-10\"<\/p>\n

Trong Excel 2013, t\u1ea1i tab All Charts<\/strong> trong ph\u1ea7n Combo,<\/strong> trong Pointer<\/strong> ch\u1ecdn Pie<\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn, nh\u1ea5p ch\u1ecdn\u00a0 Secondary Axis<\/strong> r\u1ed3i nh\u1ea5p OK \u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i.<\/p>\n

<\/p>\n

10. Sau \u0111\u00f3 b\u1ea5m v\u00e0o bi\u1ec3u \u0111\u1ed3, nh\u1ea5p ph\u1ea3i ch\u1ecdn\u00a0Format Data Series<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Format Data Series<\/strong>, ch\u1ecdn Secondary Axis<\/strong>, nh\u1eadp 270 v\u00e0o \u00f4 Agle of first slice<\/strong>, \u0111\u00f3ng h\u1ed9p tho\u1ea1i.<\/p>\n

\"doc-speedometer-12\"<\/p>\n

Trong Excel 2013, nh\u1eadp 270 v\u00e0o \u00f4 Agle of first slice <\/strong>trong h\u1ed9p tho\u1ea1i Format Data Series<\/strong>.<\/p>\n

11. Ch\u1ecdn ph\u1ea7n l\u1edbn nh\u1ea5t c\u1ee7a bi\u1ec3u \u0111\u1ed3, nh\u1ea5p ph\u1ea3i ch\u1ecdn Format Data Point<\/strong>.<\/p>\n

\"doc-speedometer-13\"<\/p>\n

12. Trong h\u1ed9p tho\u1ea1i, ch\u1ecdn Fill<\/strong> > No fill<\/strong>, \u0111\u00f3ng h\u1ed9p tho\u1ea1i.<\/p>\n

\"doc-speedometer-14\"<\/p>\n

Trong Excel 2013, ch\u1ecdn Fill & Line<\/strong> > Fill<\/strong> > No fill<\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn<\/p>\n

Sau \u0111\u00f3 l\u1eb7p l\u1ea1i b\u01b0\u1edbc n\u00e0y \u0111\u1ec3 b\u1ecf m\u00e0u c\u1ee7a ph\u1ea7n bi\u1ec3u \u0111\u1ed3 l\u1edbn nh\u1ea5t. V\u00e0 b\u1ea1n c\u00f3 bi\u1ec3u \u0111\u1ed3 sau<\/p>\n

\"doc-speedometer-15\"<\/p>\n

13. Nh\u1ea5p v\u00e0o kim ch\u1ec9, nh\u1ea5p ph\u1ea3i ch\u1ecdn Add Data Labels<\/strong>, nh\u1ea5p v\u00e0o nh\u00e3n xu\u1ea5t hi\u1ec7n, ch\u1ecdn n\u00f3 v\u00e0 ch\u1ec9nh s\u1eeda n\u00f3. Nh\u1eadp = v\u00e0o thanh c\u00f4ng th\u1ee9c, sau \u0111\u00f3 ch\u1ecdn \u00f4 b\u1ea1n nh\u1eadp 10 \u1edf b\u01b0\u1edbc 2.<\/p>\n

\"doc-speedometer-16\"<\/p>\n

14. Nh\u1ea5n Enter. B\u00e2y gi\u1edd b\u1ea1n thay \u0111\u1ed5i n\u1ed9i dung \u00f4 D2, kim ch\u1ec9 s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i.<\/p>\n

\"doc-speedometer-17\"<\/p>\n

v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3 theo \u00fd mu\u1ed1n<\/p>\n

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