{"id":6948,"date":"2024-12-21T16:34:25","date_gmt":"2024-12-21T16:34:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-them-duong-trung-binh-duong-tong-so-vao-bieu-do-trong-excel\/"},"modified":"2024-12-21T16:34:25","modified_gmt":"2024-12-21T16:34:25","slug":"cach-them-duong-trung-binh-duong-tong-so-vao-bieu-do-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-them-duong-trung-binh-duong-tong-so-vao-bieu-do-trong-excel\/","title":{"rendered":"C\u00e1ch th\u00eam \u0111\u01b0\u1eddng trung b\u00ecnh\/\u0111\u01b0\u1eddng t\u1ed5ng s\u1ed1 v\u00e0o bi\u1ec3u \u0111\u1ed3 trong Excel"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch th\u00eam \u0111\u01b0\u1eddng trung b\u00ecnh ho\u1eb7c \u0111\u01b0\u1eddng t\u1ed5ng v\u00e0o bi\u1ec3u \u0111\u1ed3.<\/p>\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng doanh s\u1ed1 b\u00e1n h\u00e0ng nh\u01b0 sau:<\/p>\n

<\/p>\n

B\u1ea1n t\u1ea1o m\u1ed9t Pivot Table v\u00e0 m\u1ed9t bi\u1ec3u \u0111\u1ed3 d\u1ef1a v\u00e0o Pivot Table \u0111\u00f3<\/p>\n

<\/p>\n

\u0110\u1ec3 th\u00eam \u0111\u01b0\u1eddng trung b\u00ecnh ho\u1eb7c \u0111\u01b0\u1eddng t\u1ed5ng v\u00e0o bi\u1ec3u \u0111\u1ed3 tr\u00ean, h\u00e3y l\u00e0m nh\u01b0 sau:<\/p>\n

1. Th\u00eam c\u1ed9t tr\u01b0\u1edbc c\u1ed9t Amount b\u1eb1ng c\u00e1ch nh\u1ea5p ph\u1ea3i t\u1ea1i c\u1ed9t Amount trong b\u1ea3ng ngu\u1ed3n, ch\u1ecdn Insert<\/strong>.<\/p>\n

<\/p>\n

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

2. Trong c\u1ed9t v\u1eeba t\u1ea1o, \u0111\u1eb7t t\u00ean l\u00e0 Average<\/strong> trong \u00f4 E1, nh\u1eadp c\u00f4ng th\u1ee9c sau:\u00a0=AVERAGE($F$2:$F$15)<\/strong> v\u00e0o \u00f4 E2 v\u00e0 k\u00e9o c\u00f4ng th\u1ee9c h\u1ebft b\u1ea3ng.<\/p>\n

<\/p>\n

Ch\u00fa \u00fd:<\/strong><\/p>\n

(1) Trong c\u00f4ng th\u1ee9c =AVERAGE($F$2:$F$15), $F$2:$F$15 l\u00e0 gi\u00e1 tr\u1ecb l\u1ea5y t\u1eeb c\u1ed9t Amount.<\/p>\n

(2) N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u01b0\u1eddng t\u1ed5ng \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n trong bi\u1ec3u \u0111\u1ed3, h\u00e3y \u0111\u1eb7t t\u00ean c\u1ed9t l\u00e0 $F$2:$F$15 trong E1, sau \u0111\u00f3 nh\u1eadp c\u00f4ng th\u1ee9c =SUM($F$2:$F$15) v\u00e0o \u00f4 E2 r\u1ed3i k\u00e9o c\u00f4ng th\u1ee9c h\u1ebft b\u1ea3ng.<\/p>\n

3. Nh\u1ea5p v\u00e0o bi\u1ec3u \u0111\u1ed3, nh\u1ea5n Refresh<\/strong> tr\u00ean tab Analyze<\/strong>.<\/p>\n

<\/p>\n

4. B\u00e2y gi\u1edd b\u1ea1n s\u1ebd th\u1ea5y gi\u00e1 tr\u1ecb\u00a0Average field (ho\u1eb7c Grand Total field) \u0111\u01b0\u1ee3c th\u00eam v\u00e0o PivotChart Fields<\/strong>. Ch\u1ecdn Average field (ho\u1eb7c Grand Total field), r\u1ed3i ch\u1ecdn Add to Values<\/strong>.<\/p>\n

<\/p>\n

5. Nh\u1ea5p ph\u1ea3i v\u00e0o m\u1ee5c average (ho\u1eb7c Grand Total) trong bi\u1ec3u \u0111\u1ed3 ch\u1ecdn Change Series Chart Type.<\/strong><\/p>\n

<\/p>\n

6. Trong h\u1ed9p tho\u1ea1i Change Chart Type trong Excel 2013, ch\u1ecdn Combo<\/strong> t\u1eeb c\u1eeda s\u1ed5 b\u00ean tr\u00e1i, trong h\u1ed9p Choose the chart type and axis for your data series<\/strong>, ch\u1ecdn Sum of Average<\/strong> v\u00e0\u00a0Line<\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn, sau \u0111\u00f3 nh\u1ea5n OK.<\/p>\n

Excel 2013:<\/p>\n

<\/p>\n

Excel 2007 v\u00e0 2010:<\/p>\n

<\/p>\n

B\u00e2y gi\u1edd bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n s\u1ebd th\u1ec3 hi\u1ec7n \u0111\u01b0\u1eddng trung b\u00ecnh (ho\u1eb7c t\u1ed5ng) nh\u01b0 sau:<\/p>\n

<\/p>\n

R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? Tuy nhi\u00ean, H\u1ecdc Excel Online \u0111\u00e3 gi\u00fap b\u1ea1n t\u1ed5ng h\u1ee3p nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y t\u1ea1i kh\u00f3a h\u1ecdc\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: HocExcel.Online<\/a><\/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":6949,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6948","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\/6948","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=6948"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6948\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6949"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6948"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6948"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}