{"id":2323,"date":"2024-12-02T07:28:21","date_gmt":"2024-12-02T07:28:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ve-va-phan-tich-bieu-do-xu-huong-trong-excel-voi-chuc-nang-data-analysis-phan-1\/"},"modified":"2024-12-02T07:28:21","modified_gmt":"2024-12-02T07:28:21","slug":"ve-va-phan-tich-bieu-do-xu-huong-trong-excel-voi-chuc-nang-data-analysis-phan-1","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ve-va-phan-tich-bieu-do-xu-huong-trong-excel-voi-chuc-nang-data-analysis-phan-1\/","title":{"rendered":"V\u1ebd v\u00e0 ph\u00e2n t\u00edch bi\u1ec3u \u0111\u1ed3 xu h\u01b0\u1edbng trong Excel v\u1edbi ch\u1ee9c n\u0103ng Data Analysis \u2013 Ph\u1ea7n 1"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u00e0o c\u00e1c b\u1ea1n, Ch\u00fang ta c\u00f9ng \u0111\u1ebfn v\u1edbi ch\u1ee7 \u0111\u1ec1 v\u1ebd bi\u1ec3u \u0111\u1ed3 xu h\u01b0\u1edbng trong Excel. Vi\u1ec7c x\u00e1c \u0111\u1ecbnh xu h\u01b0\u1edbng, ho\u1eb7c ph\u00e2n t\u00edch trung b\u00ecnh gi\u1eefa c\u00e1c th\u1eddi k\u1ef3 l\u00e0 m\u1ed9t ch\u1ec9 ti\u00eau th\u01b0\u1eddng g\u1eb7p khi ch\u00fang ta l\u00e0m c\u00f4ng vi\u1ec7c ph\u00e2n t\u00edch v\u00e0 ra quy\u1ebft \u0111\u1ecbnh v\u1edbi bi\u1ec3u \u0111\u1ed3. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> c\u00f9ng ban t\u00ecm ti\u1ec3u c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 xu h\u01b0\u1edbng v\u00e0 c\u00e1ch ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi bi\u1ec3u \u0111\u1ed3 n\u00e0y nh\u00e9.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d619467875\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ve-va-phan-tich-bieu-xu-huong-trong-excel-voi-chuc-nang-data-analysis.html#De_bai\" title=\"\u0110\u1ec1 b\u00e0i\">\u0110\u1ec1 b\u00e0i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ve-va-phan-tich-bieu-xu-huong-trong-excel-voi-chuc-nang-data-analysis.html#Cach_lam\" title=\"C\u00e1ch l\u00e0m\">C\u00e1ch l\u00e0m<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ve-va-phan-tich-bieu-xu-huong-trong-excel-voi-chuc-nang-data-analysis.html#Buoc_1_Ve_bieu_do\" title=\"B\u01b0\u1edbc 1: V\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\">B\u01b0\u1edbc 1: V\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ve-va-phan-tich-bieu-xu-huong-trong-excel-voi-chuc-nang-data-analysis.html#Buoc_2_Tao_duong_xu_huong\" title=\"B\u01b0\u1edbc 2: T\u1ea1o\u00a0\u0111\u01b0\u1eddng xu h\u01b0\u1edbng\">B\u01b0\u1edbc 2: T\u1ea1o\u00a0\u0111\u01b0\u1eddng xu h\u01b0\u1edbng<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"De_bai\"><\/span>\u0110\u1ec1 b\u00e0i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Cho s\u1eb5n b\u1ea3ng s\u1ed1 li\u1ec7u sau, h\u00e3y v\u1ebd bi\u1ec3u \u0111\u1ed3 v\u00e0 ph\u00e2n t\u00edch xu h\u01b0\u1edbng c\u1ee7a doanh thu theo c\u00e1c th\u1eddi k\u1ef3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12869 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic01-5.png\" width=\"794\" height=\"82\" title=\"pic01-5\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_lam\"><\/span>C\u00e1ch l\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>Ph\u1ea7n 1: V\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3 v\u00e0 t\u1ea1o\u00a0\u0111\u01b0\u1eddng xu h\u01b0\u1edbng<\/strong><\/em><\/p>\n<p><em><strong>Ph\u1ea7n 2: Ph\u00e2n t\u00edch\u00a0\u0111\u01b0\u1eddng xu h\u01b0\u1edbng<\/strong><\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_Ve_bieu_do\"><\/span>B\u01b0\u1edbc 1: V\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016.html\"><strong>c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/strong><\/a>, b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n qua c\u00e1c b\u01b0\u1edbc:<\/p>\n<ul>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u t\u1eeb A2\u00a0\u0111\u1ebfn M2<\/li>\n<li>B\u1ea5m ch\u1ecdn tab\u00a0Insert \/ Recommended Charts r\u1ed3i ch\u1ecdn bi\u1ec3u\u00a0\u0111\u1ed3 d\u1ea1ng\u00a0\u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12873 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic02-5.png\" width=\"953\" height=\"625\" title=\"pic02-5\"><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-76.gif\" title=\"vba101_92019-nho-76\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-179.gif\" title=\"ex101_92019-nho-179\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>Sau khi t\u1ea1o\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u\u00a0\u0111\u1ed3, ch\u00fang ta thi\u1ebft l\u1eadp c\u00e1c ch\u1ee9c n\u0103ng cho bi\u1ec3u\u00a0\u0111\u1ed3 nh\u01b0 sau:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12874 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic03-3.png\" width=\"628\" height=\"554\" title=\"pic03-3\"><\/p>\n<ol>\n<li>Axes: tr\u1ee5c tung, tr\u1ee5c ho\u00e0nh: th\u01b0\u1eddng bi\u1ec3u\u00a0\u0111\u1ed3 s\u1ebd c\u00f3 s\u1eb5n c\u1ea3 2 tr\u1ee5c n\u00e0y<\/li>\n<li>Axis\u00a0Titles: T\u00ean c\u1ee7a c\u00e1c tr\u1ee5c. Ch\u00fang ta th\u00eam v\u00e0o ph\u1ea7n t\u00ean c\u1ee7a c\u00e1c tr\u1ee5c\u00a0\u0111\u1ec3 bi\u1ec3u\u00a0\u0111\u1ed3 d\u1ec5 hi\u1ec3u h\u01a1n. Tr\u1ee5c n\u1eb1m ngang (tr\u1ee5c ho\u00e0nh) l\u00e0 bi\u1ec3u di\u1ec5n c\u00e1c th\u00e1ng t\u1eeb th\u00e1ng 0 (quy\u00a0\u01b0\u1edbc l\u00e0 s\u1ed1 1 tr\u00ean bi\u1ec3u \u0111\u1ed3) t\u1edbi th\u00e1ng 11 (quy\u00a0\u01b0\u1edbc l\u00e0 s\u1ed1 12 tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3); tr\u1ee5c th\u1eb3ng\u00a0\u0111\u1ee9ng (tr\u1ee5c tung) l\u00e0 bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb c\u1ee7a doanh thu<\/li>\n<li>Chart Title: t\u00ean c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3. Ch\u00fang ta x\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed\u00a0\u0111\u1eb7t t\u00ean c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3 cho ph\u00f9 h\u1ee3p<\/li>\n<li>Gridlines:\u00a0\u0110\u01b0\u1eddng k\u1ebb m\u1edd trong bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u1ec3 d\u00f3ng c\u00e1c tr\u1ee5c. Ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ecdn 2 n\u1ed9i dung l\u00e0 Primal Major Horizontal +\u00a0Primal Major Vertical (\u0111\u01b0\u1eddng k\u1ebb m\u1edd th\u01b0a h\u01a1n\u00a0\u0111\u1ec3 d\u1ec5 nh\u00ecn)<\/li>\n<li>Legend: l\u00e0 ghi ch\u00fa c\u00e1c\u00a0\u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n. Ch\u00fang ta x\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed\u00a0\u0111\u1eb7t ph\u1ea7n ghi ch\u00fa n\u00e0y cho ph\u00f9 h\u1ee3p<\/li>\n<\/ol>\n<p>\u0110\u00e2y l\u00e0 m\u1eabu bi\u1ec3u\u00a0\u0111\u1ed3 sau khi\u00a0\u0111\u00e3 th\u1ef1c hi\u1ec7n c\u00e1c ch\u1ee9c n\u0103ng\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12875 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic04-4.png\" width=\"602\" height=\"306\" title=\"pic04-4\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2_Tao_duong_xu_huong\"><\/span>B\u01b0\u1edbc 2: T\u1ea1o\u00a0\u0111\u01b0\u1eddng xu h\u01b0\u1edbng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea5m ch\u1ecdn (click chu\u1ed9t tr\u00e1i) \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n doanh thu, t\u1ea1i\u00a0\u0111\u01b0\u1eddng n\u00e0y ch\u00fang ta click chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Add Trendline (\u0111\u01b0\u1eddng xu h\u01b0\u1edbng)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12876 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic05-3.png\" width=\"636\" height=\"336\" title=\"pic05-3\"><\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a\u00a0\u0111\u01b0\u1eddng xu h\u01b0\u1edbng cho ch\u00fang ta 1\u00a0\u0111\u01b0\u1eddng xu h\u01b0\u1edbng k\u1ebb m\u1edd trong bi\u1ec3u\u00a0\u0111\u1ed3, v\u00e0 ph\u00eda b\u00ean tr\u00e1i xu\u1ea5t hi\u1ec7n m\u1ed9t m\u1ee5c Format Trendline\u00a0\u0111\u1ec3 ch\u00fang ta\u00a0\u0111\u1ecbnh d\u1ea1ng cho\u00a0\u0111\u01b0\u1eddng xu h\u01b0\u1edbng n\u00e0y<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12877 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic06-2.png\" width=\"942\" height=\"432\" title=\"pic06-2\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 t\u1ea1o\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u01b0\u1eddng xu h\u01b0\u1edbng tr\u00ean bi\u1ec3u\u00a0\u0111\u1ed3 r\u1ed3i. Th\u1eadt\u00a0\u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>\u0110\u01b0\u1eddng bi\u1ec3u di\u1ec5n xu h\u01b0\u1edbng c\u00f3\u00a0\u00fd ngh\u0129a th\u1ebf n\u00e0o, c\u00e1ch ch\u00fang ta ph\u00e2n t\u00edch xu h\u01b0\u1edbng ra sao, m\u1eddi c\u00e1c b\u1ea1n xem ti\u1ebfp\u00a0\u1edf b\u00e0i h\u1ecdc sau.<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \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: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-76.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2324,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2323","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\/2323","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=2323"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2323\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2324"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}