{"id":11504,"date":"2025-01-15T03:51:20","date_gmt":"2025-01-15T03:51:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-thay-doi-dinh-dang-ngay-thang-trong-truc-bieu-do-pivotchart-trong-excel\/"},"modified":"2025-01-15T03:51:20","modified_gmt":"2025-01-15T03:51:20","slug":"cach-thay-doi-dinh-dang-ngay-thang-trong-truc-bieu-do-pivotchart-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-thay-doi-dinh-dang-ngay-thang-trong-truc-bieu-do-pivotchart-trong-excel\/","title":{"rendered":"C\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong tr\u1ee5c bi\u1ec3u \u0111\u1ed3\/PivotChart trong Excel"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n v\u00e0i ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong tr\u1ee5c bi\u1ec3u \u0111\u1ed3\/Pivot Chart trong Excel.<\/p>\n

Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong tr\u1ee5c PivotChart trong Excel<\/strong><\/p>\n

Gi\u1ea3 s\u1eed b\u1ea1n v\u1eeba t\u1ea1o bi\u1ec3u \u0111\u1ed3 tr\u1ee5c nh\u01b0 h\u00ecnh sau, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong tr\u1ee5c nh\u01b0 sau:<\/p>\n

<\/p>\n

1. Trong PivotChart, nh\u1ea5p ph\u1ea3i v\u00e0o n\u00fat\u00a0Date\u00a0<\/strong><\/em>v\u00e0 ch\u1ecdn Field Settings<\/strong><\/em>\u00a0t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n

<\/p>\n

<\/p>\n

Ch\u00fa \u00fd.\u00a0<\/strong>Trong Excel 2007, b\u1ea1n kh\u00f4ng th\u1ec3 t\u00ecm ra n\u00fat\u00a0Field\u00a0<\/strong><\/em>trong PivotChart, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o\u00a0Date\u00a0<\/strong><\/em>trong\u00a0Axis Fields (Categories)\u00a0<\/strong><\/em>c\u1ee7a b\u1ea3ng\u00a0PivotTable Field List<\/strong><\/em> v\u00e0 ch\u1ecdn\u00a0Filed Settings<\/strong><\/em> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y ch\u1ec9 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c trong Excel 2010\/2013.<\/p>\n

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

2. Trong h\u1ed9p tho\u1ea1i\u00a0Field Settings<\/strong><\/em>, nh\u1ea5n n\u00fat\u00a0Number Format.<\/strong><\/em><\/p>\n

<\/p>\n

3. B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 truy c\u1eadp v\u00e0o h\u1ed9p tho\u1ea1i\u00a0Format Cells<\/strong><\/em>, nh\u1ea5p ch\u1ecdn\u00a0Custom\u00a0<\/strong><\/em>trong h\u1ed9p\u00a0Category<\/strong><\/em>, sau \u0111\u00f3 g\u00f5 m\u00e3 \u0111\u1ecbnh d\u1ea1ng v\u00e0o \u00f4\u00a0Type<\/strong><\/em>, nh\u1ea5n OK. (Ch\u00fa \u00fd: N\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb 2014-01-03 th\u00e0nh 1\/3, g\u00f5 m\/d. N\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb th\u00e0nh Jan (Th\u00e1ng 1), g\u00f5 mmm v\u00e0o \u00f4\u00a0Type<\/strong><\/em>)<\/p>\n

<\/p>\n

4. Nh\u1ea5n OK trong h\u1ed9p tho\u1ea1i\u00a0Field Settings<\/strong><\/em>. Sau \u0111\u00f3 b\u1ea1n s\u1ebd th\u1ea5y ng\u00e0y th\u00e1ng trong tr\u1ee5c c\u1ee7a PivotChart \u0111\u01b0\u1ee3c thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng.<\/p>\n

<\/p>\n

Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong tr\u1ee5c bi\u1ec3u \u0111\u1ed3 trong Excel<\/strong><\/p>\n

V\u00ed d\u1ee5, c\u00f3 m\u1ed9t bi\u1ec3u \u0111\u1ed3 nh\u01b0 h\u00ecnh sau, v\u00e0 \u0111\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong tr\u1ee5c bi\u1ec3u \u0111\u1ed3 b\u00ecnh th\u01b0\u1eddng, h\u00e3y l\u00e0m nh\u01b0 sau:<\/p>\n

<\/p>\n

1. Nh\u1ea5p ph\u1ea3i v\u00e0o tr\u1ee5c b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng, ch\u1ecdn\u00a0Format Axis\u00a0<\/strong><\/em>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n

<\/p>\n

2. T\u00f9y theo phi\u00ean b\u1ea3n Excel:<\/p>\n

(1) Trong b\u1ea3ng\u00a0Format Axis\u00a0<\/strong><\/em>c\u1ee7a Excel 2013, m\u1edf r\u1ed9ng nh\u00f3m\u00a0Number\u00a0<\/strong><\/em>trong th\u1ebb\u00a0Axis Options<\/strong><\/em>, nh\u1eadp m\/d ho\u1eb7c mmm ho\u1eb7c m\u00e3 kh\u00e1c v\u00e0o \u00f4\u00a0Format Code\u00a0<\/strong><\/em>v\u00e0 nh\u1ea5n n\u00fat\u00a0Add<\/strong><\/em>.<\/p>\n

(2) Trong Excel 2007 v\u00e0 2010, nh\u1ea5p\u00a0Number\u00a0<\/strong><\/em>trong thanh b\u00ean tr\u00e1i, g\u00f5 m\/d ho\u1eb7c mmm ho\u1eb7c m\u00e3 kh\u00e1c v\u00e0o \u00f4\u00a0Format Code<\/strong><\/em>, nh\u1ea5p\u00a0Add<\/strong><\/em>.<\/p>\n

Trong Excel 2013 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n cao h\u01a1n:<\/p>\n

<\/p>\n

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

<\/p>\n

Ch\u00fa \u00fd.\u00a0<\/strong>N\u1ebfu b\u1ea1n g\u00f5 m\/d v\u00e0o h\u1ed9p\u00a0Format Code<\/strong><\/em>, c\u00e1c ng\u00e0y trong c\u00e1c tr\u1ee5c \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng th\u00e0nh 1\/1, 2\/1\u2026 N\u1ebfu b\u1ea1n g\u00f5 mmm v\u00e0o \u00f4, ng\u00e0y th\u00e1ng s\u1ebd \u0111\u01b0\u1ee3c thay \u0111\u1ed5i th\u00e0nh Jan, Feb\u2026<\/p>\n

3. \u0110\u00f3ng h\u1ed9p tho\u1ea1i\u00a0Format Axis<\/strong><\/em>. Sau \u0111\u00f3 b\u1ea1n s\u1ebd th\u1ea5y ng\u00e0y th\u00e1ng trong tr\u1ee5c bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1ee3c thay \u0111\u1ed5i th\u00e0nh \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n.<\/p>\n

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