{"id":11368,"date":"2025-01-15T02:43:28","date_gmt":"2025-01-15T02:43:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tao-bieu-do-ket-hop-va-them-cot-thu-cap-trong-excel\/"},"modified":"2025-01-15T02:43:28","modified_gmt":"2025-01-15T02:43:28","slug":"cach-tao-bieu-do-ket-hop-va-them-cot-thu-cap-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tao-bieu-do-ket-hop-va-them-cot-thu-cap-trong-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 k\u1ebft h\u1ee3p v\u00e0 th\u00eam c\u1ed9t th\u1ee9 c\u1ea5p trong Excel"},"content":{"rendered":"
\n

\"doc-combine-chart1\"<\/p>\n

\"doc-button1\"<\/p>\n

\"doc-combine-chart2\"<\/p>\n

\"doc-button2\"<\/p>\n

\"doc-combine-chart3\"<\/p>\n

C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 k\u1ebft h\u1ee3p trong Excel<\/strong><\/p>\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 hai d\u1eef li\u1ec7u ngu\u1ed3n sau, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 k\u1ebft h\u1ee3p d\u1ef1a tr\u00ean d\u1eef li\u1ec7u ngu\u1ed3n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

<\/p>\n

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

1. Tr\u01b0\u1edbc ti\u00ean, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t cho d\u1eef li\u1ec7u ngu\u1ed3n\u00a0Area, ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u, sau \u0111\u00f3 ch\u1ec9 \u0111\u1ecbnh ki\u1ec3u bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong th\u1ebb\u00a0Insert<\/strong><\/em>. Bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111\u01b0\u1ee3c t\u1ea1o nh\u01b0 sau:<\/p>\n

<\/p>\n

2. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u Total Price, nh\u1ea5n\u00a0Ctrl + C<\/strong><\/em> \u0111\u1ec3 sao ch\u00e9p n\u00f3, sau \u0111\u00f3 nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 c\u1ed9t n\u00e0o trong bi\u1ec3u \u0111\u1ed3 tr\u00ean, nh\u1ea5n\u00a0Ctrl + V<\/strong><\/em> \u0111\u1ec3 d\u00e1n d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u \u0111\u1ed3. B\u00e2y gi\u1edd ch\u00fang ta c\u00f3 m\u1ed9t bi\u1ec3u \u0111\u1ed3 c\u1ed9t v\u1edbi hai b\u1ed9 d\u1eef li\u1ec7u (Area v\u00e0 Total Price), c\u1ea3 hai \u0111\u1ec1u s\u1eed d\u1ee5ng c\u00f9ng m\u1ed9t ki\u1ec3u bi\u1ec3u \u0111\u1ed3.<\/p>\n

\"doc-combine-chart8\"<\/p>\n

3. Trong b\u01b0\u1edbc n\u00e0y, ch\u00fang ta c\u1ea7n thay \u0111\u1ed5i m\u1ed9t trong hai b\u1ed9 d\u1eef li\u1ec7u th\u00e0nh bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng th\u1eb3ng. Nh\u1ea5p v\u00e0o c\u1ed9t bi\u1ec3u \u0111\u1ed3 m\u00e0u \u0111\u1ecf Total Price, nh\u1ea5p ph\u1ea3i, ch\u1ecdn Change Series Chart Type<\/strong><\/em>\u00a0t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n

\"doc-combine-chart9\"<\/p>\n

4. Trong h\u1ed9p tho\u1ea1i \u00a0Change Chart Type<\/strong><\/em>, ch\u1ecdn m\u1ed9t ki\u1ec3u bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng k\u1ebb b\u1ea1n mu\u1ed1n.<\/p>\n

\"doc-combine-chart10\"<\/p>\n

5. Nh\u1ea5n OK.<\/p>\n

\"doc-combine-chart11\"<\/p>\n

Ch\u00fa \u00fd.\u00a0<\/strong>L\u1eb7p l\u1ea1i c\u00e1c b\u01b0\u1edbc tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p nhi\u1ec1u h\u01a1n hai lo\u1ea1i bi\u1ec3u \u0111\u1ed3, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn th\u00eam b\u1ed9 d\u1eef li\u1ec7u v\u00e0 ch\u1ecdn ki\u1ec3u bi\u1ec3u \u0111\u1ed3 kh\u00e1c nhau cho m\u1ed7i chu\u1ed7i d\u1eef li\u1ec7u.<\/p>\n

Th\u00eam c\u1ed9t th\u1ee9 c\u1ea5p cho bi\u1ec3u \u0111\u1ed3 k\u1ebft h\u1ee3p<\/strong><\/p>\n

\u0110\u00f4i khi, trong bi\u1ec3u \u0111\u1ed3 k\u1ebft h\u1ee3p, c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t b\u1ed9 d\u1eef li\u1ec7u r\u1ea5t \u0111a d\u1ea1ng, nh\u01b0 v\u1eady s\u1ebd kh\u00f3 cho ch\u00fang ta so s\u00e1nh c\u00e1c d\u1eef li\u1ec7u v\u1edbi nhau. \u0110\u1ec3 t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 \u0111\u01a1n gi\u1ea3n h\u01a1n Excel cho ph\u00e9p ch\u00fang ta th\u00eam m\u1ed9t c\u1ed9t th\u1ee9 c\u1ea5p v\u00e0o bi\u1ec3u \u0111\u1ed3.<\/p>\n

1. Trong bi\u1ec3u \u0111\u1ed3 k\u1ebft h\u1ee3p, nh\u1ea5p v\u00e0o bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng k\u1ebb, nh\u1ea5p ph\u1ea3i ho\u1eb7c nh\u1ea5p \u0111\u00fap, ch\u1ecdn Format Data Series<\/strong><\/em>\u00a0t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n

\"doc-combine-chart12\"<\/p>\n

2. Trong h\u1ed9p tho\u1ea1i Format Data Series<\/strong><\/em>, nh\u1ea5p Series Options<\/strong><\/em>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn Secondary Axis<\/strong><\/em>.<\/p>\n

\"doc-combine-chart13\"<\/p>\n

3. Nh\u1ea5n\u00a0Close<\/strong><\/em>, nh\u01b0 v\u1eady b\u1ea1n \u0111\u00e3 th\u00eam c\u1ed9t th\u1ee9 c\u1ea5p cho bi\u1ec3u \u0111\u1ed3 th\u00e0nh c\u00f4ng.<\/p>\n

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