{"id":6714,"date":"2024-12-21T16:01:46","date_gmt":"2024-12-21T16:01:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-them-cot-phu-trong-bieu-do-truc-cua-excel\/"},"modified":"2024-12-21T16:01:46","modified_gmt":"2024-12-21T16:01:46","slug":"cach-them-cot-phu-trong-bieu-do-truc-cua-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-them-cot-phu-trong-bieu-do-truc-cua-excel\/","title":{"rendered":"C\u00e1ch th\u00eam c\u1ed9t ph\u1ee5 trong bi\u1ec3u \u0111\u1ed3 tr\u1ee5c c\u1ee7a Excel"},"content":{"rendered":"
\n

Bi\u1ec3u \u0111\u1ed3 tr\u1ee5c c\u00f3 th\u1ec3 gi\u00fap ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u01a1 b\u1ea3n m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, nh\u01b0ng \u0111\u00f4i khi, n\u1ebfu c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t l\u1edbn gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb, bi\u1ec3u \u0111\u1ed3 s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb \u0111\u1eb9p v\u00e0 ch\u00ednh x\u00e1c nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi. Ta c\u00f3 th\u1ec3 th\u00eam m\u1ed9t c\u1ed9t ph\u1ee5 v\u00e0o bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y.<\/p>\n

\"doc-pivottable-secondary-axis-1\"<\/p>\n

V\u00ed d\u1ee5, t\u00f4i mu\u1ed1n th\u00eam m\u1ed9t c\u1ed9t ph\u1ee5 \u0111\u1ec3 th\u1ec3 hi\u1ec7n Sum of Profit<\/strong><\/p>\n

1. Nh\u1ea5p ph\u1ea3i v\u00e0o c\u1ed9t Sum of Profit, <\/strong>ch\u1ecdn Format Data Series<\/strong>.<\/p>\n

\"doc-pivottable-secondary-axis-2\"<\/p>\n

2. Trong h\u1ed9p tho\u1ea1i Format Data Series<\/strong>, ch\u1ecdn Secondary Axis<\/strong> trong ph\u1ea7n Series Options<\/strong><\/p>\n

\"doc-pivottable-secondary-axis-3\"<\/p>\n

\u1ede Excel 2013, ch\u1ecdn\u00a0Secondary Axis<\/strong> d\u01b0\u1edbi Series Options<\/strong> trong b\u1ea3ng Format Data Series<\/strong><\/p>\n

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

3. \u0110\u00f3ng c\u1eeda s\u1ed5 tho\u1ea1i, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y tr\u1ee5c ph\u1ee5 \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o<\/p>\n

\"doc-pivottable-secondary-axis-4\"<\/p>\n

4. Nh\u1ea5p ph\u1ea3i v\u00e0o c\u1ed9t Sum of Profit<\/strong>, ch\u1ecdn Change Series Chart Type<\/strong><\/p>\n

\"doc-pivottable-secondary-axis-5\"<\/p>\n

5. Trong h\u1ed9p tho\u1ea1i Change Chart Type<\/strong>, ch\u1ecdn Line<\/strong> v\u00e0 nh\u1ea5p OK \u0111\u1ec3 \u0111\u00f3ng c\u1eeda s\u1ed5 tho\u1ea1i.<\/p>\n

\"doc-pivottable-secondary-axis-6\"<\/p>\n

B\u00e2y gi\u1edd bi\u1ec3u \u0111\u1ed3 tr\u1ee5c s\u1ebd nh\u01b0 sau<\/p>\n

\"doc-pivottable-secondary-axis-7\"<\/p>\n

Trong Excel 2013, trong h\u1ed9p tho\u1ea1i Change Chart Type<\/strong>, ch\u1ecdn ph\u1ea7n Combo <\/strong>s\u1ebd c\u00f3 h\u00e0ng lo\u1ea1t c\u00e1c c\u00e1c bi\u1ec3u \u0111\u1ed3 c\u00f3 tr\u1ee5c ph\u1ee5 trong ph\u1ea7n Choose the chart type and axis for your data series, <\/strong>ch\u1ecdn lo\u1ea1i nh\u01b0 h\u00ecnh v\u00e0 ch\u1ecdn Line <\/strong>trong danh s\u00e1ch t\u00f9y ch\u1ecdn<\/p>\n

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

Wow, r\u1ea5t nhi\u1ec1u \u0111i\u1ec1u m\u1edbi ph\u1ea3i kh\u00f4ng n\u00e0o? Excel c\u00f2n v\u00f4 v\u00e0n ki\u1ebfn th\u1ee9c kh\u00e1c m\u00e0 ch\u00fang ta c\u1ea7n bi\u1ebft \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c. B\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u1ebfn nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y? M\u1ed9t g\u1ee3i \u00fd c\u1ea7n thi\u1ebft cho b\u1ea1n, \u0111\u00f3 l\u00e0 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft t\u1ea1i Blog H\u1ecdc Excel Online <\/a>ho\u1eb7c kh\u00f3a h\u1ecdc<\/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":6715,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6714","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\/6714","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=6714"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6714\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6715"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}