{"id":11541,"date":"2022-03-14T14:02:05","date_gmt":"2022-03-14T07:02:05","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11541"},"modified":"2022-03-20T22:43:36","modified_gmt":"2022-03-20T15:43:36","slug":"cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/","title":{"rendered":"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11541&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><span style=\"font-weight: 400\">Trong nhi\u1ec1u c\u00e1ch \u0111\u1ec3 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u th\u00ec bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111\u01b0\u1ee3c d\u00f9ng kh\u00e1 ph\u1ed5 bi\u1ebfn. V\u1eady, <\/span><a href=\"https:\/\/teky.edu.vn\/\"><b>c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel <\/b><\/a><span style=\"font-weight: 400\">c\u00f3 qu\u00e1 kh\u00f3 kh\u00f4ng? H\u00e3y theo d\u00f5i vi\u1ebft n\u00e0y \u0111\u1ec3 \u0111\u01b0\u1ee3c hi\u1ec3u r\u00f5 n\u1ebfu b\u1ea1n ch\u01b0a t\u1eebng bi\u1ebft qua c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel.\u00a0<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#Cach_ve_bieu_do_cot_trong_Excel\" >C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#Thao_tac_chinh_sua_cach_ve_bieu_do_cot_trong_Excel\" >Thao t\u00e1c ch\u1ec9nh s\u1eeda c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#Thay_doi_ve_kich_thuoc_cung_nhu_di_chuyen_bieu_do_cot\" >Thay \u0111\u1ed5i v\u1ec1 k\u00edch th\u01b0\u1edbc c\u00f9ng nh\u01b0 di chuy\u1ec3n bi\u1ec3u \u0111\u1ed3 c\u1ed9t.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#Cach_them_phan_tieu_de_cho_bieu_do_dang_cot\" >C\u00e1ch th\u00eam ph\u1ea7n ti\u00eau \u0111\u1ec1 cho bi\u1ec3u \u0111\u1ed3 d\u1ea1ng c\u1ed9t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#Thao_tac_de_lam_an_hoac_hien_nhung_thanh_phan_o_bieu_do_cot\" >Thao t\u00e1c \u0111\u1ec3 l\u00e0m \u1ea9n ho\u1eb7c hi\u1ec7n nh\u1eefng th\u00e0nh ph\u1ea7n \u1edf bi\u1ec3u \u0111\u1ed3 c\u1ed9t.<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#Chi_tiet_phan_ve_bieu_do_cot_chong\" >Chi ti\u1ebft ph\u1ea7n v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_ve_bieu_do_cot_trong_Excel\"><\/span><span style=\"font-weight: 400\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel <\/b><span style=\"font-weight: 400\">g\u1ed3m c\u00e1c b\u01b0\u1edbc v\u00f4 c\u00f9ng d\u1ec5 d\u00e0ng, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u01b0\u1edbc 1: M\u1edf m\u00e1y v\u00e0 b\u1eadt \u1ee9ng d\u1ee5ng Excel, m\u1edf c\u00e1c file c\u1ea7n s\u1eed d\u1ee5ng trong Excel. V\u1edbi c\u00e1c s\u1ed1 li\u1ec7u c\u0169ng nh\u01b0 th\u00f4ng tin c\u1ea7n thi\u1ebft \u0111\u1ec3 d\u00f9ng cho c\u1ed9t. Ch\u00fa \u00fd k\u0129 b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 b\u00f4i \u0111en ph\u1ea7n th\u00f4ng tin c\u1ea7n ch\u1ecdn. Sau \u0111\u00f3 ch\u1ecdn Insert v\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 ch\u1ecdn <\/span><span style=\"font-weight: 400\">Recommended Charts.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11542 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-1.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-1-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-1-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u01b0\u1edbc 2: L\u00fac n\u00e0y, giao di\u1ec7n m\u00e0n hinh Excel s\u1ebd xu\u1ea5t hi\u1ec7n Insert Chart v\u00e0 m\u1edf th\u1ebb All Charts. Trong qu\u00e1 tr\u00ecnh tr\u00ecnh b\u00e0y th\u00f4ng tin s\u1ebd g\u1ed3m c\u00f3 hai d\u1ea1ng c\u1ed9t \u0111\u00f3 l\u00e0 c\u1ed9t d\u1ecdc v\u00e0 c\u1ed9t ngang. T\u1ea1i \u0111\u00e2y, b\u1ea1n h\u00e3y ch\u1ecdn ki\u1ec3u c\u1ed9t ph\u00f9 h\u1ee3p v\u1edbi th\u00f4ng tin m\u00e0 b\u1ea1n mu\u1ed1n di\u1ec5n \u0111\u1ea1t. Nh\u1eb1m \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ee5c \u0111\u00edch h\u1ecdc t\u1eadp, c\u00f4ng vi\u1ec7c t\u1ed1t nh\u1ea5t cho b\u1ea1n.\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11559 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-3.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-3-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-3-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n tr\u00ecnh b\u00e0y theo ki\u1ec3u c\u1ed9t d\u1ecdc h\u00e3y ch\u1ecdn trong ph\u1ea7n Column. C\u00f2n v\u1edbi bi\u1ec3u \u0111\u1ed3 ngang b\u1ea1n ch\u1ecdn trong ph\u1ea7n Bar. Trong ph\u1ea7n bi\u1ec3u \u0111\u1ed3 d\u1ecdc v\u00e0 ngang. C\u00f2n c\u00f3 nhi\u1ec1u ph\u1ea7n nh\u1ecf cho b\u1ea1n l\u1ef1a ch\u1ecdn ki\u1ec3u: bi\u1ec3u \u0111\u1ed3 c\u1ed9t d\u1ea1ng 2D, bi\u1ec3u \u0111\u1ed3 c\u1ed9t d\u1ea1ng 3D, bi\u1ec3u \u0111\u1ed3 c\u1ed9t 2D ki\u1ec3u x\u1ebfp ch\u1ed3ng, bi\u1ec3u \u0111\u1ed3 c\u1ed9t d\u1ea1ng 3D ki\u1ec3u x\u1ebfp ch\u1ed3ng\u2026T\u00f9y theo s\u1ef1 l\u1ef1a ch\u1ecdn c\u1ee7a b\u1ea1n mu\u00f4n nh\u01b0 th\u1ebf n\u00e0o v\u00e0 nh\u1eadn n\u00fat ch\u1ecdn, r\u1ed3i ch\u1ecdn OK.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 v\u1eady, \u0111\u00f3 l\u00e0 g\u1ed3m c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1ec1 c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel. V\u1edbi v\u00e0i b\u01b0\u1edbc b\u1ea1n \u0111\u00e3 t\u1ea1o n\u00ean cho m\u00ecnh bi\u1ec3u \u0111\u1ed3 c\u1ea7n thi\u1ebft ph\u1ee5c v\u1ee5 cho vi\u1ec7c h\u1ecdc t\u1eadp, c\u00f4ng vi\u1ec7c.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thao_tac_chinh_sua_cach_ve_bieu_do_cot_trong_Excel\"><\/span><span style=\"font-weight: 400\">Thao t\u00e1c ch\u1ec9nh s\u1eeda c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_ve_kich_thuoc_cung_nhu_di_chuyen_bieu_do_cot\"><\/span><span style=\"font-weight: 400\">Thay \u0111\u1ed5i v\u1ec1 k\u00edch th\u01b0\u1edbc c\u00f9ng nh\u01b0 di chuy\u1ec3n bi\u1ec3u \u0111\u1ed3 c\u1ed9t.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/b><span style=\"font-weight: 400\"> s\u1ebd lu\u00f4n bao g\u1ed3m c\u1ea3 c\u00e1ch ch\u1ec9nh s\u1eeda. V\u1ec1 ph\u1ea7n thay \u0111\u1ed5i k\u00edch th\u00edch cho c\u1ed9t s\u1ebd c\u1ea7n:<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n nh\u1ea5n b\u00f4i \u0111en bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o, ti\u1ebfp theo d\u00f9ng tr\u1ecf chu\u1ed9t v\u00e0o ch\u1ed7 c\u00f3 n\u00fat n\u1eafm t\u1ea1i v\u1ecb tr\u00ed b\u1ed1n g\u1ed1c c\u1ee7a bi\u1ec3u \u0111\u1ed3. B\u00ean c\u1ea1nh \u0111\u00f3, c\u0169ng c\u1ea7n ch\u1ecdn gi\u1eefa b\u1ed1n c\u1ea1nh c\u1ee7a bi\u1ec3u \u0111\u1ed3. Cu\u1ed1i c\u00f9ng, nh\u1ea5n gi\u1eef n\u00fat tr\u1ecf chu\u1ed9t r\u1ed3i t\u00f9y ch\u1ec9nh k\u00edch th\u00edch theo y\u00eau c\u1ea7u c\u1ee7a b\u1ea1n \u0111\u1eb7t ra cho bi\u1ec3u \u0111\u1ed3.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11561 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">V\u1ec1 ph\u1ea7n di chuy\u1ec3n bi\u1ec3u \u0111\u1ed3 sang v\u1ecb tr\u00ed kh\u00e1c g\u1ed3m c\u00e1c thao t\u00e1c: <\/span><span style=\"font-weight: 400\">B\u1ea1n ch\u1ecdn bi\u1ec3u \u0111\u1ed3 \u1edf v\u1ecb tr\u00ed hi\u1ec7n t\u1ea1i nh\u1ea5n gi\u1eef ch\u1ed9t r\u1ed3i chuy\u1ec3n n\u00f3 \u0111\u1ebfn n\u01a1i b\u1ea1n c\u1ea7n chuy\u1ec3n b\u1eb1ng c\u00e1ch th\u1ea3 nh\u1eb9 chu\u1ed9t ra.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_them_phan_tieu_de_cho_bieu_do_dang_cot\"><\/span><span style=\"font-weight: 400\">C\u00e1ch th\u00eam ph\u1ea7n ti\u00eau \u0111\u1ec1 cho bi\u1ec3u \u0111\u1ed3 d\u1ea1ng c\u1ed9t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel b\u1ea1n \u0111\u00e3 bi\u1ebft, th\u00ec ph\u1ea7n ti\u00eau \u0111\u1ec1 \u0111\u1ec3 th\u00eam cho bi\u1ec3u \u0111\u1ed3 c\u1ed9t b\u1ea1n c\u0169ng n\u00ean n\u1eafm ch\u1eafc.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u1ecdn Chart Title v\u00e0 nh\u1eadn ch\u1ecdn \u0111\u00fap chu\u1ed9t v\u00e0o. Sau \u0111\u00f3 g\u00f5 ti\u00eau \u0111\u1ec1 c\u1ea7n nh\u1eadp cho bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u1ee7a b\u1ea1n. Nh\u1eefng g\u00ec b\u1ea1n g\u00f5 cho bi\u1ec3u \u0111\u1ed3 c\u1ed9t s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec7n l\u00ean tr\u00ean bi\u1ec3u \u0111\u1ed3 c\u1ed9t ban \u0111\u1ea7u. V\u1ec1 ki\u1ec3u ch\u1eef c\u0169ng nh\u01b0 trang tr\u00ed c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n t\u1ea1i \u0111\u00e2y nh\u01b0 Word.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11558 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-6.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-6-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-6-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thao_tac_de_lam_an_hoac_hien_nhung_thanh_phan_o_bieu_do_cot\"><\/span><span style=\"font-weight: 400\">Thao t\u00e1c \u0111\u1ec3 l\u00e0m \u1ea9n ho\u1eb7c hi\u1ec7n nh\u1eefng th\u00e0nh ph\u1ea7n \u1edf bi\u1ec3u \u0111\u1ed3 c\u1ed9t.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i v\u00e0i th\u00e0nh ph\u1ea7n c\u1ee7a bi\u1ec3u \u0111\u1ed3 c\u1ed9t sau khi \u0111\u00e3 th\u1ef1c hi\u1ec7n xong c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Th\u1ea5y d\u1ea5u + b\u00ean c\u1ea1nh bi\u1ec3u \u0111\u1ed3 c\u1ed9t, nh\u1ea5n chu\u1ed9t v\u00e0o ngay bi\u1ec3u t\u01b0\u1ee3ng \u0111\u00f3 \u0111\u1ec3 b\u1eaft \u0111\u1ea7u vi\u1ec7c ch\u1ec9nh s\u1eeda. Nh\u1eefng th\u00e0nh ph\u1ea7n c\u1ee7a bi\u1ec3u \u0111\u1ed3 c\u1ed9t b\u1eaft \u0111\u1ea7u xu\u1ea5t hi\u1ec7n. L\u00fac n\u00e0y, theo t\u00f9y \u00fd c\u1ee7a b\u1ea1n m\u00e0 cho ph\u00e9p ch\u00fang \u1ea9n hay hi\u1ec7n ra:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><b>Axes<\/b><span style=\"font-weight: 400\">: \u00fd ngh\u0129a c\u1ee7a s\u1ef1 hi\u1ec7n hay \u1ea9n tr\u1ee5c tung ho\u1eb7c tr\u1ee5c ho\u00e0nh d\u00e0nh cho ph\u1ea7n l\u1edbn l\u00e0 d\u00e0nh cho to\u00e1n h\u1ecdc. Hay c\u00f2n \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u00ean l\u00e0 thanh tr\u1ee5c nagng v\u00e0 d\u1ecdc c\u1ee7a c\u00e1ch n\u00f3i th\u00f4ng th\u01b0\u1eddng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><b>Axis Titles<\/b><span style=\"font-weight: 400\">: tr\u1ea1ng th\u00e1i d\u1ecdc hay ngang c\u1ee7a ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3 c\u1ed9t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><b>Chart Title: <\/b><span style=\"font-weight: 400\">bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1eafc ch\u1eafn r\u1eb1ng c\u1ea7n m\u1ed9t c\u00e1i ti\u00eau \u0111\u1ec1 ch\u00ednh. V\u00ec th\u1ebf \u0111\u00e2y l\u00e0 ti\u00eau \u0111\u1ec1 ch\u00ednh c\u1ee7a bi\u1ec3u \u0111\u1ed3 c\u1ed9t, m\u00e0 ch\u1eafc ch\u1eafn s\u1ebd r\u1ea5t h\u1eefu \u00edch v\u1edbi b\u1ea1n.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><b>Data Labels<\/b><span style=\"font-weight: 400\">: \u0111\u00e2y l\u00e0 nh\u1eefng th\u1ee9 trang tr\u00ed d\u1eef li\u1ec7u tr\u00ean bi\u1ec3u \u0111\u1ed3 c\u1ed9t hay c\u00f2n \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 nh\u00e3n d\u00e1n.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><b>Data Table<\/b><span style=\"font-weight: 400\">: d\u1eef li\u1ec7u b\u1eb1ng b\u1ea3ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong qu\u00e1 tr\u00ecnh v\u1ebd bi\u1ec3u \u0111\u1ed9 c\u1ed9t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><b>Gridlines<\/b><span style=\"font-weight: 400\">: ph\u1ea7n \u1ea9n hi\u1ec7n v\u1ec1 \u0111\u01b0\u1eddng l\u01b0\u1edbi \u1edf ki\u1ec3u d\u1ecdc ho\u1eb7c ngang tr\u00ean bi\u1ec3u \u0111\u1ed3 c\u1ed9t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><b>Legend<\/b><span style=\"font-weight: 400\">: \u0111\u00e2y l\u00e0 ph\u1ea7n ch\u00fa th\u00edch ri\u00eang d\u00e0nh \u0111\u1ec3 gi\u1ea3i th\u00edch cho nh\u1eefng k\u00ed hi\u1ec7u \u0111\u1eb7c bi\u1ec7t \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n \u1edf bi\u1ec3u \u0111\u1ed3 c\u1ed9t. Nh\u1eefng \u00fd ngh\u0129a c\u1ee7a bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u1ea7n \u0111\u01b0\u1ee3c hi\u1ec3u r\u00f5. \u0110\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c h\u1ebft c\u00e1c th\u00f4ng tin v\u00ec th\u1ebf legend th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u1edf m\u1ecdi bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">V\u1edbi nh\u1eefng t\u00ednh n\u0103ng trong Excel, b\u1ea1n mu\u1ed1n d\u00f9ng ph\u1ea7n n\u00e0o cho bi\u1ec3u \u0111\u1ed3 c\u1ed9t c\u1ee7a ch\u00ednh m\u00ecnh. th\u00ec h\u00e3y click \u0111\u00e1nh d\u1ea5u v\u00e0o \u00f4 vu\u00f4ng \u0111\u1ec3 ch\u1ecdn ph\u1ea7n hi\u1ec7n. C\u00f2n v\u1edbi vi\u1ec7c b\u1ea1n mu\u1ed1n \u1ea9n n\u00f3 trong bi\u1ec3u \u0111\u1ed3 c\u1ed9t b\u1ea1n \u0111ang v\u1ebd th\u00ec h\u00e3y \u0111\u1ec3 \u00f4 vu\u00f4ng tr\u1ed1ng.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11557 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-5.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-5-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-5-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chi_tiet_phan_ve_bieu_do_cot_chong\"><\/span><span style=\"font-weight: 400\">Chi ti\u1ebft ph\u1ea7n v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u1edbi nh\u1eefng ph\u1ea7n tr\u00ean l\u00e0 c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111\u01a1n. V\u1eady c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng s\u1ebd \u0111\u01b0\u1ee3c t\u1ea1o n\u00ean nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y theo d\u00f5i ti\u1ebfp b\u00e0i vi\u1ebft nh\u00e9.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng \u0111\u01b0\u1ee3c hi\u1ec3u nh\u01b0 l\u00e0 c\u00e1c thanh x\u1ebfp ch\u1ed3ng l\u00ean nh\u1eb1m \u0111\u1ec3 th\u1ec3 hi\u1ec7n s\u1ef1 thay \u0111\u1ed5i. C\u0169ng nh\u01b0 gi\u00e1 tr\u1ecb c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t theo th\u1eddi gian. C\u00e1c d\u1eef li\u1ec7u c\u1ee7a bi\u1ec3u \u0111\u1ed3 s\u1ebd \u0111\u01b0\u1ee3c x\u1ebfp g\u1ea7n nhau n\u00ean s\u1ef1 kh\u00e1c bi\u1ec7t s\u1ebd \u0111\u01b0\u1ee3c th\u1ea5y d\u1ec5 d\u00e0ng. Tuy c\u00f9ng m\u1ed9t c\u1ed9t nh\u01b0ng s\u1ebd \u0111\u01b0\u1ee3c ph\u00e2n ra nh\u1eefng ph\u1ea7n nh\u1ecf v\u1edbi c\u00e1c m\u00e0u kh\u00e1c nhau.\u00a0 C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng trong Excel g\u1ed3m:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u01b0\u1edbc 1: M\u1edf Excel v\u00e0 truy c\u1eadp v\u00e0o trang t\u00ednh. Sau \u0111\u00f3 ch\u1ecdn l\u1ecdc c\u00e1c th\u00f4ng tin c\u0169ng nh\u01b0 d\u1eef li\u1ec7u c\u1ea7n c\u00f3 cho bi\u1ec3u \u0111\u1ed3. Ch\u1ecdn c\u00e1c v\u00f9ng d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng th\u00edch h\u1ee3p v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n \u1edf b\u1ea3ng.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11556 size-full aligncenter\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-4.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-4-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-4-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u01b0\u1edbc 2: Tr\u00ean thanh c\u00f4ng c\u1ee5 ph\u1ea7n menu nh\u1ea5n chu\u1ed9t theo th\u1ee9 t\u1ef1 c\u00e1c b\u01b0\u1edbc: Charts \u0111\u1ebfn Column \u0111\u1ebfn Stacked Column.\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11554 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-6.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-6-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-6-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u01b0\u1edbc 3: D\u00f9ng tr\u1ecf chu\u1ed9t click v\u00e0o ki\u1ec3u bi\u1ec3u \u0111\u1ed3 m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn. V\u00e0 nh\u1eefng ph\u1ea7n \u0111\u1ecbnh d\u1ea1ng c\u1ee7a bi\u1ec3u \u0111\u1ed3 trong Excel s\u1ebd xu\u1ea5t hi\u1ec7n l\u00ean trang l\u00e0m vi\u1ec7c cu\u1ea3 b\u1ea1n.\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11555 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-5.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-5-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-5-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Trong Excel c\u00f2n c\u00f3 nhi\u1ec1u lo\u1ea1i bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng kh\u00e1c v\u00e0 \u1edf tr\u00ean thu\u1ed9c m\u1ed9t trong c\u00e1c d\u1ea1ng. B\u1ea1n c\u00f3 th\u1ec3 v\u1edbi s\u1ef1 l\u1ef1a ch\u1ecdn v\u00e0 y\u00eau th\u00edch ch\u1ecdn cho m\u00ecnh m\u1ed9t ki\u1ec3u bi\u1ec3u \u0111\u1ed3 ch\u1ed3ng c\u01a1 b\u1ea3n kh\u00e1c. M\u1ed7i d\u1ea1ng s\u1ebd c\u00f3 c\u00e1c ki\u1ec3u 2D v\u00e0 3D \u0111\u1ec3 \u0111\u00e1p \u1ee9ng nhu c\u1ea7u t\u1ed1t nh\u1ea5t cho b\u1ea1n. H\u00e3y th\u1eed ngay<\/span> c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 <span style=\"font-weight: 400\">theo c\u00e1ch ri\u00eang c\u1ee7a b\u1ea1n t\u1ea1o n\u00ean s\u1ef1 \u0111\u1eb7c s\u1eafc ri\u00eang bi\u1ec7t nh\u1ea5t.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Hy v\u1ecdng v\u1edbi s\u1ef1 h\u01b0\u1edbng d\u1eabn \u0111\u1ea7y chi ti\u1ebft c\u1ee7a c\u00fang t\u00f4i b\u1ea1n s\u1ebd v\u1eadn d\u1ee5ng \u0111\u01b0\u1ee3c <\/span><b>c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel <\/b><span style=\"font-weight: 400\">v\u00e0 <\/span>c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t ch\u1ed3ng trong Excel<span style=\"font-weight: 400\">. Bi\u1ec3u \u0111\u1ed3 c\u1ed9t s\u1ebd gi\u00fap \u0111\u01b0a ra c\u00e1c \u00fd t\u01b0\u1edfng v\u00e0 ph\u1ee5c v\u1ee5 t\u1edbt nh\u1ea5t cho vi\u1ec7c h\u1ecdc v\u00e0 vi\u1ec7c l\u00e0m c\u1ee7a b\u1ea1n.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong nhi\u1ec1u c\u00e1ch \u0111\u1ec3 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u th\u00ec bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111\u01b0\u1ee3c d\u00f9ng kh\u00e1 ph\u1ed5 bi\u1ebfn. V\u1eady, c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel c\u00f3 qu\u00e1 kh\u00f3 kh\u00f4ng? H\u00e3y theo d\u00f5i vi\u1ebft n\u00e0y \u0111\u1ec3 \u0111\u01b0\u1ee3c hi\u1ec3u r\u00f5 n\u1ebfu b\u1ea1n ch\u01b0a t\u1eebng bi\u1ebft qua c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel.\u00a0 C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 &hellip;<\/p>\n","protected":false},"author":26,"featured_media":11552,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11541","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0<\/title>\n<meta name=\"description\" content=\"c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel c\u00f3 qu\u00e1 kh\u00f3 kh\u00f4ng? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 \u0111\u01b0\u1ee3c hi\u1ec3u r\u00f5 n\u1ebfu b\u1ea1n ch\u01b0a t\u1eebng bi\u1ebft qua c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0\" \/>\n<meta property=\"og:description\" content=\"c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel c\u00f3 qu\u00e1 kh\u00f3 kh\u00f4ng? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 \u0111\u01b0\u1ee3c hi\u1ec3u r\u00f5 n\u1ebfu b\u1ea1n ch\u01b0a t\u1eebng bi\u1ebft qua c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-14T07:02:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-20T15:43:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-5.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0\",\"datePublished\":\"2022-03-14T07:02:05+00:00\",\"dateModified\":\"2022-03-20T15:43:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/\"},\"wordCount\":1869,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-5.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/\",\"name\":\"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-5.jpg\",\"datePublished\":\"2022-03-14T07:02:05+00:00\",\"dateModified\":\"2022-03-20T15:43:36+00:00\",\"description\":\"c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel c\u00f3 qu\u00e1 kh\u00f3 kh\u00f4ng? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 \u0111\u01b0\u1ee3c hi\u1ec3u r\u00f5 n\u1ebfu b\u1ea1n ch\u01b0a t\u1eebng bi\u1ebft qua c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-5.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-5.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0","description":"c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel c\u00f3 qu\u00e1 kh\u00f3 kh\u00f4ng? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 \u0111\u01b0\u1ee3c hi\u1ec3u r\u00f5 n\u1ebfu b\u1ea1n ch\u01b0a t\u1eebng bi\u1ebft qua c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel.\u00a0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0","og_description":"c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel c\u00f3 qu\u00e1 kh\u00f3 kh\u00f4ng? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 \u0111\u01b0\u1ee3c hi\u1ec3u r\u00f5 n\u1ebfu b\u1ea1n ch\u01b0a t\u1eebng bi\u1ebft qua c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel.\u00a0","og_url":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-03-14T07:02:05+00:00","article_modified_time":"2022-03-20T15:43:36+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-5.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0","datePublished":"2022-03-14T07:02:05+00:00","dateModified":"2022-03-20T15:43:36+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/"},"wordCount":1869,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-5.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/","url":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/","name":"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-5.jpg","datePublished":"2022-03-14T07:02:05+00:00","dateModified":"2022-03-20T15:43:36+00:00","description":"c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel c\u00f3 qu\u00e1 kh\u00f3 kh\u00f4ng? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 \u0111\u01b0\u1ee3c hi\u1ec3u r\u00f5 n\u1ebfu b\u1ea1n ch\u01b0a t\u1eebng bi\u1ebft qua c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel.\u00a0","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-5.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-5.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11541"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11541\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11552"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}