{"id":6298,"date":"2024-12-21T15:02:16","date_gmt":"2024-12-21T15:02:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tao-do-thi-tuong-tac-trong-excel\/"},"modified":"2024-12-21T15:02:16","modified_gmt":"2024-12-21T15:02:16","slug":"cach-tao-do-thi-tuong-tac-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tao-do-thi-tuong-tac-trong-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o \u0111\u1ed3 th\u1ecb t\u01b0\u01a1ng t\u00e1c trong Excel"},"content":{"rendered":"
\n

Trong Excel, b\u1ea1n \u0111\u00e3 t\u1ea1o nhi\u1ec1u \u0111\u1ed3 th\u1ecb d\u1ef1a tr\u00ean s\u1ed1 li\u1ec7u c\u1ee7a m\u00ecnh v\u00e0 b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c bi\u1ec3u \u0111\u1ed3 t\u01b0\u01a1ng t\u00e1c trong b\u1ea3ng t\u00ednh, ngh\u0129a l\u00e0 khi b\u1ea1n ch\u1ecdn m\u1ed9t t\u00f9y ch\u1ecdn, s\u1ebd hi\u1ec3n th\u1ecb bi\u1ec3u \u0111\u1ed3 t\u01b0\u01a1ng \u1ee9ng. \u1ede \u0111\u00e2y, t\u00f4i s\u1ebd gi\u1edbi thi\u1ec7u hai lo\u1ea1i bi\u1ec3u \u0111\u1ed3 t\u01b0\u01a1ng t\u00e1c: Bi\u1ec3u \u0111\u1ed3 t\u01b0\u01a1ng t\u00e1c s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ecdn v\u00e0 c\u00e1c bi\u1ec3u \u0111\u1ed3 t\u01b0\u01a1ng t\u00e1c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng n\u00fat t\u00f9y ch\u1ecdn.<\/p>\n

\"doc-interactive-charts2-2-2\"<\/p>\n

\"doc-interactive-charts23-23\"
\nT\u1ea1o bi\u1ec3u \u0111\u1ed3 t\u01b0\u01a1ng t\u00e1c s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ecdn<\/strong><\/h1>\n

N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ec3u \u0111\u1ed3 thay \u0111\u1ed5i khi ch\u1ecdn m\u1ee5c hi\u1ec3n th\u1ecb t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

\u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n t\u1ea1o v\u00e0i bi\u1ec3u \u0111\u1ed3 ri\u00eang bi\u1ec7t<\/strong><\/p>\n

1. T\u1ea1o t\u1ea5t c\u1ea3 c\u00e1c bi\u1ec3u \u0111\u1ed3 m\u00e0 b\u1ea1n mu\u1ed1n v\u00e0 \u0111\u1eb7t ch\u00fang trong m\u1ed9t trang t\u00ednh nh\u01b0 h\u00ecnh sau:<\/p>\n

<\/p>\n

2. Ch\u1ecdn v\u00f9ng c\u00f3 bi\u1ec3u \u0111\u1ed3 th\u1ee9 nh\u1ea5t, ch\u1ecdn \u00a0Formulas<\/strong> > Define Name<\/strong>,\u00a0nh\u01b0 h\u00ecnh:<\/p>\n

<\/p>\n

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

3. Trong h\u1ed9p tho\u1ea1i New Name,\u00a0<\/strong>k\u1ec3 c\u1ee5 th\u1ec3 t\u1eebng t\u00ean bi\u1ec3u \u0111\u1ed3. v\u00e0 ch\u1ecdn Workbook t\u1ea1i Scope trong danh s\u00e1ch t\u00f9y ch\u1ecdn, nh\u01b0 h\u00ecnh sau:<\/p>\n

\"doc-interactive-charts3\"<\/p>\n

4. Nh\u1ea5p OK. L\u1eb7p l\u1ea1i b\u01b0\u1edbc 2, b\u01b0\u1edbc 3 \u0111\u1ec3 th\u00eam t\u00ean cho m\u1ed7i bi\u1ec3u \u0111\u1ed3.<\/p>\n

Th\u1ee9 hai, t\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn cho bi\u1ec3u \u0111\u1ed3 t\u01b0\u01a1ng t\u00e1c c\u1ee7a b\u1ea1n.<\/strong><\/p>\n

5. Trong \u00f4 tr\u1ed1ng, nh\u1eadp t\u00ean c\u00e1c bi\u1ec3u \u0111\u1ed3 nh\u01b0 sau:<\/p>\n

\"doc-interactive-charts3\"<\/p>\n

6. Ch\u00e8n danh s\u00e1ch t\u00f9y ch\u1ecdn v\u00e0o trang t\u00ednh b\u1eb1ng c\u00e1ch ch\u1ecdn\u00a0Developer<\/strong> > Insert<\/strong> > Combo Box\u00a0<\/strong>(n\u1ebfu tab Developer\u00a0<\/strong>ch\u01b0a hi\u1ec3n th\u1ecb tr\u00ean thanh c\u00f4ng c\u1ee5, h\u00e3y v\u00e0o\u00a0File<\/strong> > Option<\/strong> > Customize Ribbon\u00a0<\/strong>\u0111\u1ec3 ch\u1ecdn hi\u1ec3n th\u1ecb\u00a0Developer)\u00a0<\/strong>v\u00e0 k\u00e9o chu\u1ed9t \u0111\u1ec3 t\u1ea1o Combo Box\u00a0<\/strong> nh\u01b0 h\u00ecnh:<\/p>\n

<\/p>\n

7. Nh\u1ea5p ph\u1ea3i Combo Box,\u00a0<\/strong> ch\u1ecdn\u00a0Format Control<\/strong><\/p>\n

\"doc-interactive-charts3\"<\/p>\n

8. Trong h\u1ed9p tho\u1ea1i\u00a0Format Object,\u00a0<\/strong>ch\u1ecdn tab Control\u00a0<\/strong>nh\u1ea5p n\u00fat\u00a0\"doc-button-1\"\u00a0t\u1eeb\u00a0 Cell link\u00a0<\/strong>\u0111\u1ec3 ch\u1ecdn 1 \u00f4 tr\u1ed1ng b\u00ean c\u1ea1nh Combo Box.<\/strong><\/p>\n

<\/p>\n

9. Nh\u1ea5p OK, v\u00e0 b\u00e2y gi\u1edd, khi ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 trong Combo Box, \u00f4 ch\u1ee9a \u0111\u01b0\u1eddng d\u1eabn s\u1ebd th\u1ec3 hi\u1ec7n th\u1ee9 t\u1ef1 \u0111\u01b0\u1eddng d\u1eabn.<\/p>\n

\"doc-interactive-charts3\"<\/p>\n

10. Khi ch\u1ecdn linked cell, v\u00ed d\u1ee5 \u1edf \u0111\u00e2y l\u00e0 N2. nh\u1ea5p\u00a0Formulas<\/strong> > Define Name, <\/strong>trong h\u1ed9p tho\u1ea1i\u00a0New Name,\u00a0<\/strong>nh\u1eadp v\u00e0o d\u00e3y t\u00ean cho linked cell v\u00e0 c\u00f4ng th\u1ee9c\u00a0=Choose($N$2,Chart1,Chart2,Chart3)\u00a0<\/strong>v\u00e0o \u00f4\u00a0 Refers to (<\/strong>N2 l\u00e0 linked cell, Chart1, Chart2, Chart3 l\u00e0 t\u00ean bi\u1ec3u \u0111\u1ed3), nh\u1ea5p OK \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/p>\n

\"doc-interactive-charts3\"<\/p>\n

11. Ch\u1ecdn Chart1, nh\u1ea5n Ctrl+C\u00a0<\/strong>\u0111\u1ec3 sao ch\u00e9p v\u00f9ng d\u1eef li\u1ec7u, ch\u1ecdn m\u1ed9t \u00f4 v\u00e0 nh\u1ea5p ph\u1ea3i, ch\u1ecdn\u00a0Paste Special<\/strong> > Linked Picture<\/strong><\/p>\n

\"doc-interactive-charts3\"<\/p>\n

12. B\u00e2y gi\u1edd Chart1 \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o v\u00f9ng ch\u1ec9 \u0111\u1ecbnh, nh\u1ea5p v\u00e0o h\u00ecnh c\u1ee7a bi\u1ec3u \u0111\u1ed3 n\u00e0y, nh\u1eadp c\u00f4ng th\u1ee9c\u00a0=Selectedchart\u00a0<\/strong>(\u0111\u00e2y l\u00e0 t\u00ean c\u1ee7a linked cell \u0111\u00e3 t\u1ea1o \u1edf b\u01b0\u1edbc 10) v\u00e0o thanh c\u00f4ng th\u1ee9c, nh\u1ea5n Enter.<\/strong><\/p>\n

\"doc-interactive-charts3\"<\/p>\n

<\/span>T\u1ea1o bi\u1ec3u \u0111\u1ed3 t\u01b0\u01a1ng t\u00e1c b\u1eb1ng c\u00e1ch d\u00f9ng n\u00fat t\u00f9y ch\u1ecdn<\/strong><\/span><\/h2>\n

Th\u1ec9nh tho\u1ea3ng b\u1ea1n mu\u1ed1n d\u00f9ng n\u00fat t\u00f9y ch\u1ecdn \u0111\u1ec3 ch\u1ecdn c\u00e1c bi\u1ec3u \u0111\u1ed3 li\u00ean quan, nh\u1eefng b\u01b0\u1edbc sau c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n:<\/p>\n

1. T\u1ea1o d\u00e3y t\u00ean c\u1ee7a bi\u1ec3u \u0111\u1ed3 nh\u01b0 b\u01b0\u1edbc 1 \u0111\u1ebfn b\u01b0\u1edbc 4 \u1edf tr\u00ean<\/p>\n

2. Ch\u00e8n n\u00fat t\u00f9y ch\u1ecdn v\u00e0 t\u1ea1o bi\u1ec3u \u0111\u1ed3 t\u01b0\u01a1ng t\u00e1c nh\u01b0 sau:<\/p>\n

(1.) Nh\u1ea5p\u00a0Developer<\/strong> > Insert<\/strong> > Option Button <\/strong>v\u00e0 k\u00e9o chu\u1ed9t \u0111\u1ec3 v\u1ebd n\u00fat t\u00f9y ch\u1ecdn, nh\u1ea5p ph\u1ea3i v\u00e0 ch\u1ecdn Edit Text, nh\u01b0 h\u00ecnh<\/p>\n

<\/p>\n

(2.) Nh\u1eadp nh\u00e3n c\u1ee7a n\u00fat t\u00f9y ch\u1ecdn<\/p>\n

\"doc-interactive-charts3\"<\/p>\n

(3.) V\u1ebd n\u00fat t\u00f9y ch\u1ecdn kh\u00e1c v\u00e0 thay \u0111\u1ed5i t\u00ean nh\u00e3n (l\u1eb7p l\u1ea1i b\u01b0\u1edbc 1 v\u00e0 b\u01b0\u1edbc 2 ph\u00eda tr\u00ean)<\/p>\n

\"doc-interactive-charts3\"<\/p>\n

(4.) Nh\u1ea5p ph\u1ea3i t\u1ea1i n\u00fat t\u00f9y ch\u1ecdn, ch\u1ecdn Format Control<\/strong><\/p>\n

\"doc-interactive-charts3\"<\/p>\n

(5.) Trong h\u1ed9p tho\u1ea1i Format Object,\u00a0<\/strong>v\u00e0o tab Control\u00a0<\/strong>ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng c\u1ea1nh n\u00fat t\u00f9y ch\u1ecdn trong \u00f4 Cell link<\/strong><\/p>\n

\"doc-interactive-charts3\"<\/p>\n

(6.) Nh\u1ea5p OK, b\u00e2y gi\u1edd khi nh\u1ea5p 1 trong nh\u1eefng n\u00fat t\u00f9y ch\u1ecdn \u0111\u00e3 t\u1ea1o th\u00ec s\u1ed1 th\u1ee9 t\u1ef1 li\u00ean k\u1ebft s\u1ebd hi\u1ec7n ra trong \u00f4 tr\u00ean<\/p>\n

(7.) Nh\u1ea5p v\u00e0o Cell link M19, t\u1ea1o t\u00ean cho n\u00f3 b\u1eb1ng c\u00e1ch\u00a0Formulas<\/strong> > Define Name,\u00a0<\/strong>trong h\u1ed9p tho\u1ea1i New Name<\/strong> ch\u1ecdn t\u00ean v\u00e0 g\u00f5 c\u00f4ng th\u1ee9c\u00a0=Choose($M$19,Chart1,Chart2,Chart3)<\/strong> v\u00e0o \u00f4 Refer to\u00a0(M19\u00a0<\/strong>l\u00e0 linked cell, Chart1, Chart2, Chart3 l\u00e0 t\u00ean bi\u1ec3u \u0111\u1ed3), nh\u1ea5p OK \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/strong><\/p>\n

\"doc-interactive-charts3\"<\/p>\n

(8.) Sao ch\u00e9p v\u00f9ng bi\u1ec3u \u0111\u1ed3 v\u00e0 d\u00e1n v\u1edbi \u0111\u1ecbnh d\u1ea1ng linked picture v\u00e0o v\u1ecb tr\u00ed t\u00f9y ch\u1ecdn, sau \u0111\u00f3 ch\u1ecdn h\u00ecnh bi\u1ec3u \u0111\u1ed3, nh\u1eadp c\u00f4ng th\u1ee9c\u00a0=Selectedchart<\/strong> (Selectedchart\u00a0<\/strong>l\u00e0 t\u00ean c\u1ee7a cell link), nh\u1ea5n Enter.<\/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":6299,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6298","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\/6298","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=6298"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6298\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6299"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}