{"id":7463,"date":"2021-08-11T08:50:38","date_gmt":"2021-08-11T01:50:38","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=7463"},"modified":"2021-08-18T11:08:34","modified_gmt":"2021-08-18T04:08:34","slug":"cach-tao-bieu-do-hien-thi-so-luong-nguoi-tren-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/cach-tao-bieu-do-hien-thi-so-luong-nguoi-tren-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng ng\u01b0\u1eddi tr\u00ean Excel"},"content":{"rendered":"

B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n t\u1ea1o bi\u1ec3u \u0111\u1ed3 hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng ng\u01b0\u1eddi tr\u00ean Excel \u0111\u1eb9p v\u00e0 nhanh ch\u00f3ng.<\/p>\n

B\u01b0\u1edbc 1:<\/strong>\u00a0Tr\u01b0\u1edbc khi t\u1ea1o \u0111\u01b0\u1ee3c bi\u1ec3u \u0111\u1ed3 tr\u00ean Excel, b\u1ea1n s\u1ebd ph\u1ea3i l\u00e0m cho m\u00ecnh b\u1ea3ng d\u1eef li\u1ec7u v\u1edbi n\u1ed9i dung \u0111\u1ec1 m\u1ee5c v\u00e0 c\u00e1c s\u1ed1 li\u1ec7u c\u1ea7n t\u00ednh to\u00e1n.<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 2:<\/strong>\u00a0Sau \u0111\u00f3, b\u1ea1n h\u00e3y ch\u1ecdn th\u1ebb\u00a0Insert<\/strong>\u00a0v\u00e0 ch\u1ecdn\u00a0Get Add-ins<\/strong> \u0111\u1ec3 l\u1ea5y th\u00eam d\u1eef li\u1ec7u tr\u1ef1c tuy\u1ebfn t\u1eeb trang ch\u1ee7.<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 3:<\/strong>\u00a0Ti\u1ebfp theo, b\u1ea1n h\u00e3y nh\u1eadp\u00a0People graph<\/strong>\u00a0v\u00e0o trong thanh t\u00ecm ki\u1ebfm v\u00e0 ch\u1ecdn\u00a0Add<\/strong>\u00a0c\u1ee7a t\u00ednh n\u0103ng t\u1ea1o bi\u1ec3u \u0111\u1ed3 People graph \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u0111\u1ea7u ti\u00ean.<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 4:<\/strong>\u00a0Khi b\u1ea1n th\u00eam c\u00e1c Add-ins m\u1edbi v\u00e0o trong Microsoft Excel, b\u1ea1n s\u1ebd ph\u1ea3i x\u00e1c nh\u1eadn cho vi\u1ec7c b\u1ea3o m\u1eadt v\u00e0 b\u1ea3n quy\u1ec1n. B\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn\u00a0Continue<\/strong>\u00a0\u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 5:<\/strong>\u00a0Ngay l\u1eadp t\u1ee9c, h\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u t\u1eeb trang ch\u1ee7 v\u00e0 g\u1eedi b\u1ea3ng d\u1eef li\u1ec7u bi\u1ec3u \u0111\u1ed3 d\u1ea1ng ng\u01b0\u1eddi cho b\u1ea1n. \u0110\u1ec3 t\u00f9y ch\u1ecdn, thay \u0111\u1ed5i d\u1eef li\u1ec7u tr\u00ean b\u1ea3ng bi\u1ec3u \u0111\u1ed3 th\u00ec b\u1ea1n h\u00e3y ch\u1ecdn th\u1ebb\u00a0Table<\/strong>\u00a0tr\u00ean bi\u1ec3u \u0111\u1ed3.<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 6:<\/strong>\u00a0Tr\u01b0\u1edbc h\u1ebft, ch\u00fang ta s\u1ebd ph\u1ea3i l\u1ea5y d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3 b\u1eb1ng c\u00e1ch ch\u1ecdn m\u1ee5c\u00a0Select your data<\/strong>.<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 7:<\/strong>\u00a0\u0110\u1ec3 l\u1ea5y d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3, b\u1ea1n h\u00e3y b\u00f4i \u0111en\u00a0v\u00f9ng trang t\u00ednh tr\u00ean Excel\u00a0(1)<\/strong>\u00a0\u0111\u00e3 t\u1ea1o tr\u01b0\u1edbc \u0111\u00e2y v\u00e0 nh\u1ea5n\u00a0Create\u00a0(2)<\/strong>\u00a0\u0111\u1ec3 nh\u1eadp d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u \u0111\u1ed3.<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 8:<\/strong>\u00a0Sau khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c th\u00eam v\u00e0o bi\u1ec3u \u0111\u1ed3, b\u1ea1n s\u1ebd th\u1ea5y \u0111\u1ec1 m\u1ee5c, ch\u00fa th\u00edch v\u00e0 s\u1ed1 li\u1ec7u \u0111\u01b0\u1ee3c thay \u0111\u1ed5i l\u1ea1i.<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 9:<\/strong>\u00a0\u0110\u1ed1i v\u1edbi ph\u1ea7n ti\u00eau \u0111\u1ec1 c\u1ee7a bi\u1ec3u \u0111\u1ed3, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i b\u1eb1ng c\u00e1ch ch\u1ecdn\u00a0Table<\/strong>\u00a0tr\u00ean bi\u1ec3u \u0111\u1ed3 v\u00e0 nh\u1eadp d\u1eef li\u1ec7u v\u00e0o m\u1ee5c\u00a0Title<\/strong>\u00a0\u0111\u1ec3 thay \u0111\u1ed5i ti\u00eau \u0111\u1ec1.<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 10:<\/strong>\u00a0Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 thay \u0111\u1ed5i giao di\u1ec7n, n\u1ec1n, h\u00ecnh ng\u01b0\u1eddi tr\u00ean bi\u1ec3u \u0111\u1ed3 b\u1eb1ng c\u00e1ch ch\u1ecdn m\u1ee5c\u00a0Settings<\/strong>\u00a0tr\u00ean bi\u1ec3u \u0111\u1ed3.<\/p>\n

\"\"<\/p>\n

B\u01b0\u1edbc 11:<\/strong>\u00a0Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 ho\u00e0n t\u1ea5t vi\u1ec7c t\u1ea1o b\u1ea3ng bi\u1ec3u \u0111\u1ed3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ng\u01b0\u1eddi tr\u00ean n\u1ec1n t\u1ea3ng Excel. B\u1ea1n c\u00f3 th\u1ec3 th\u1ecfa th\u00edch t\u00f9y bi\u1ebfn giao di\u1ec7n tr\u00ean b\u1ea3ng bi\u1ec3u \u0111\u1ed3 sao cho ph\u00f9 h\u1ee3p.<\/p>\n

\"\"<\/p>\n

Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n","protected":false},"excerpt":{"rendered":"

B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n t\u1ea1o bi\u1ec3u \u0111\u1ed3 hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng ng\u01b0\u1eddi tr\u00ean Excel \u0111\u1eb9p v\u00e0 nhanh ch\u00f3ng. B\u01b0\u1edbc 1:\u00a0Tr\u01b0\u1edbc khi t\u1ea1o \u0111\u01b0\u1ee3c bi\u1ec3u \u0111\u1ed3 tr\u00ean Excel, b\u1ea1n s\u1ebd ph\u1ea3i l\u00e0m cho m\u00ecnh b\u1ea3ng d\u1eef li\u1ec7u v\u1edbi n\u1ed9i dung \u0111\u1ec1 m\u1ee5c v\u00e0 c\u00e1c s\u1ed1 li\u1ec7u c\u1ea7n t\u00ednh to\u00e1n. B\u01b0\u1edbc 2:\u00a0Sau \u0111\u00f3, b\u1ea1n […]<\/p>\n","protected":false},"author":3,"featured_media":7464,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-7463","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-tuc"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=7463"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7463\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/7464"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=7463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=7463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=7463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}