{"id":12424,"date":"2025-01-15T08:40:47","date_gmt":"2025-01-15T08:40:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-sparkline-tools-trong-excel-2010\/"},"modified":"2025-01-15T08:40:47","modified_gmt":"2025-01-15T08:40:47","slug":"huong-dan-su-dung-sparkline-tools-trong-excel-2010","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-sparkline-tools-trong-excel-2010\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Sparkline Tools trong EXCEL 2010"},"content":{"rendered":"
\n

T\u1eeb EXCEL 2010 tr\u1edf l\u00ean,\u00a0Sparkline Tools l\u00e0 c\u00f4ng c\u1ee5 m\u1edbi xu\u1ea5t hi\u1ec7n h\u1ed7 tr\u1ee3 v\u0103n b\u1ea3n th\u1ed1ng k\u00ea \u0111\u1ea1t hi\u1ec7u qu\u1ea3 t\u1ed1t h\u01a1n. Bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng\u00a0Sparkline Tools \u0111\u1ec3 t\u1eadn d\u1ee5ng t\u1ed1i \u0111a ch\u1ee9c n\u0103ng c\u1ee7a EXCEL 2010.<\/p>\n

Sparkline Tools l\u00e0 g\u00ec?\u00a0<\/strong><\/em><\/p>\n

Trong c\u00e1c b\u1ea3ng th\u1ed1ng k\u00ea t\u1eeb v\u00e0i th\u00e1ng \u0111\u1ebfn m\u1ed9t n\u0103m, nh\u1eefng con s\u1ed1 xu\u1ea5t hi\u1ec7n tr\u00e0n lan, ch\u1eafc ch\u1eafn khi\u1ebfn ng\u01b0\u1eddi qu\u1ea3n l\u00fd m\u1ec7t m\u1ecfi, kh\u00f3 kh\u0103n kh\u00e1i qu\u00e1t t\u00ecnh h\u00ecnh chung. D\u01b0\u1eddng nh\u01b0 n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c t\u00e2m l\u00fd n\u00e0y, c\u1ea3i thi\u1ec7n m\u1edbi t\u1eeb EXCEL 2010 h\u1ed7 tr\u1ee3 t\u01b0\u1ee3ng h\u00ecnh h\u00f3a c\u00e1c d\u00e3y s\u1ed1 , hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0\u00a0m\u00f4 t\u1ea3 d\u1eef li\u1ec7u b\u1eb1ng bi\u1ec3u \u0111\u1ed3v\u00e0 \u0111\u1ed3 th\u1ecb, th\u1ec3 hi\u1ec7n r\u00f5 c\u00e1c xu h\u01b0\u1edbng qua th\u1eddi gian. \u0110\u00f3 ch\u00ednh l\u00e0 c\u00f4ng c\u1ee5 Sparkline Tools, c\u00f4ng c\u1ee5 n\u00e0y s\u1ebd hi\u1ec3n th\u1ecb m\u1ecdi con s\u1ed1 th\u1ed1ng k\u00ea qua m\u1ed9t \u0111\u1ed3 th\u1ecb c\u1ee1 nh\u1ecf (mini) n\u1eb1m g\u1ecdn trong 1 \u00f4 (cell).<\/p>\n

H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Sparkline Tools trong Excel:<\/strong><\/em><\/p>\n

B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn 1 h\u00e0ng ch\u1ee9a c\u00e1c con s\u1ed1 b\u1ea1n mu\u1ed1n th\u1ed1ng k\u00ea v\u1eafn t\u1eaft<\/p>\n

<\/p>\n

B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn m\u1ee5c Insert. T\u00ecm v\u00e0o nh\u00f3m Sparklines.<\/p>\n

Ch\u1ecdn m\u1ee5c Insert<\/figcaption><\/figure>\n

<\/p>\n

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

B\u01b0\u1edbc 3:<\/strong> L\u1ef1a ch\u1ecdn lo\u1ea1i h\u00ecnh b\u1ea1n mu\u1ed1n Sparkline Tools bi\u1ec3u th\u1ecb. G\u1ed3m 2 lo\u1ea1i ch\u00ednh: d\u1ea1ng \u0111\u01b0\u1eddng, d\u1ea1ng c\u1ed9t; trong \u0111\u00f3 d\u1ea1ng c\u1ed9t c\u00f3 2 lo\u1ea1i (lo\u1ea1i th\u01b0\u1eddng v\u00e0 lo\u1ea1i hi\u1ec3n th\u1ecb l\u1ed7 l\u00e3i). T\u1ea1i v\u00ed d\u1ee5 n\u00e0y s\u1eed d\u1ee5ng d\u1ea1ng \u0111\u01b0\u1eddng.<\/p>\n

B\u01b0\u1edbc 4:<\/strong> Nh\u1eadp v\u1ecb tr\u00ed \u00f4 (cell) b\u1ea1n mu\u1ed1n Sparkline Tools hi\u1ec3n th\u1ecb. T\u1ea1i \u0111\u00e2y c\u00f3 hai c\u00e1ch: th\u1ee9 nh\u1ea5t b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 \u0111\u00e1nh v\u1ecb tr\u00ed \u00f4 ho\u1eb7c t\u1ef1 di chu\u1ed9t \u0111\u1ebfn \u00f4 \u0111\u00f3 r\u1ed3i click chu\u1ed9t tr\u00e1i.<\/p>\n

C\u00e1ch 1: Nh\u1eadp v\u1ecb tr\u00ed \u00f4 trong Location Range<\/figcaption><\/figure>\n

\n

C\u00e1ch 2: T\u1ef1 click v\u00e0o \u00f4 mu\u1ed1n Sparkline Tool hi\u1ec3n th\u1ecb \u0111\u1ed3 th\u1ecb. \u0110\u1ea7u ti\u00ean click v\u00e0o \u00f4 trong v\u1ea1ch \u0111\u1ecf<\/figcaption><\/figure>\n<\/p>\n

<\/p>\n

Sau khi click v\u00e0o \u00f4, \u00f4 \u0111\u00f3 s\u1ebd bao quanh \u0111\u01b0\u1eddng v\u1ea1ch c\u1eaft nh\u01b0 tr\u00ean<\/figcaption><\/figure>\n

\n

Enter v\u00e0 Okay<\/figcaption><\/figure>\n<\/p>\n

<\/p>\n

\n

Cu\u1ed1i c\u00f9ng ta c\u00f3 \u0111\u01b0\u1ee3c \u0111\u1ed3 th\u1ecb mini t\u1eeb Sparkline Tools:<\/p>\n

<\/p>\n

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