{"id":8522,"date":"2024-12-22T14:47:24","date_gmt":"2024-12-22T14:47:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-tao-duong-thoi-gian-timeline-trong-excel\/"},"modified":"2024-12-22T14:47:24","modified_gmt":"2024-12-22T14:47:24","slug":"huong-dan-tao-duong-thoi-gian-timeline-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-tao-duong-thoi-gian-timeline-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o \u0111\u01b0\u1eddng th\u1eddi gian (Timeline) trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>V\u1edbi Excel ta c\u00f3 th\u1ec3 t\u1ea1o ra nh\u1eefng \u0111\u01b0\u1eddng th\u1eddi gian bi\u1ec3u th\u1ecb cho nh\u1eefng s\u1ef1 ki\u1ec7n \u0111\u00e3 di\u1ec5n ra. C\u1ee5 th\u1ec3 ta s\u1ebd s\u1eed d\u1ee5ng t\u00ednh n\u0103ng SmartArt \u0111\u1ec3 t\u1ea1o timeline nh\u01b0 h\u01b0\u1edbng d\u1eabn c\u01a1 b\u1ea3n d\u01b0\u1edbi \u0111\u00e2y.<\/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-6768267c267bd\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/duong-thoi-gian-timeline-trong-excel.html#Tao_duong_thoi_gian_voi_SmartArt\" title=\"T\u1ea1o \u0111\u01b0\u1eddng th\u1eddi gian v\u1edbi SmartArt\">T\u1ea1o \u0111\u01b0\u1eddng th\u1eddi gian v\u1edbi SmartArt<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/duong-thoi-gian-timeline-trong-excel.html#Tuy_chinh_mot_so_thuoc_tinh_SmartArt_don_gian\" title=\"T\u00f9y ch\u1ec9nh m\u1ed9t s\u1ed1 thu\u1ed9c t\u00ednh SmartArt \u0111\u01a1n gi\u1ea3n\">T\u00f9y ch\u1ec9nh m\u1ed9t s\u1ed1 thu\u1ed9c t\u00ednh SmartArt \u0111\u01a1n gi\u1ea3n<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/duong-thoi-gian-timeline-trong-excel.html#Thembot_thoi_gian\" title=\"Th\u00eam\/b\u1edbt th\u1eddi gian\">Th\u00eam\/b\u1edbt th\u1eddi gian<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/duong-thoi-gian-timeline-trong-excel.html#Thay_doi_vi_tri_cac_moc\" title=\"Thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c m\u1ed1c\">Thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c m\u1ed1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/duong-thoi-gian-timeline-trong-excel.html#Thay_doi_Layout\" title=\"Thay \u0111\u1ed5i Layout\">Thay \u0111\u1ed5i Layout<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/duong-thoi-gian-timeline-trong-excel.html#Doi_mau_va_style\" title=\"\u0110\u1ed5i m\u00e0u v\u00e0 style\">\u0110\u1ed5i m\u00e0u v\u00e0 style<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Tao_duong_thoi_gian_voi_SmartArt\"><\/span>T\u1ea1o \u0111\u01b0\u1eddng th\u1eddi gian v\u1edbi SmartArt<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Trong th\u1ebb\u00a0<strong>Insert<\/strong>, ch\u1ecdn\u00a0<strong>SmartArt<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27726\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-duong-thoi-gian-1.png\" width=\"483\" height=\"237\" title=\"tao-duong-thoi-gian-1\"><\/strong><\/li>\n<li>Trong m\u1ee5c\u00a0<strong>Choose a SmartArt Graphic<\/strong>, ch\u1ecdn\u00a0<strong>Process<\/strong> sau \u0111\u00f3 ch\u1ecdn\u00a0<em>Timeline<\/em>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27727\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-duong-thoi-gian-2.png\" width=\"745\" height=\"395\" title=\"tao-duong-thoi-gian-2\"><\/li>\n<li>Click v\u00e0o\u00a0<strong>[Text]<\/strong> v\u00e0 nh\u1eadp d\u1eef li\u1ec7u v\u00e0o. V\u1eady l\u00e0 ta \u0111\u00e3 c\u00f3 m\u1ed9t \u0111\u01b0\u1eddng th\u1eddi gian \u0111\u01a1n gi\u1ea3n r\u1ed3i.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27728\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-duong-thoi-gian-3.png\" width=\"758\" height=\"311\" title=\"tao-duong-thoi-gian-3\"><\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"Tuy_chinh_mot_so_thuoc_tinh_SmartArt_don_gian\"><\/span>T\u00f9y ch\u1ec9nh m\u1ed9t s\u1ed1 thu\u1ed9c t\u00ednh SmartArt \u0111\u01a1n gi\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t timeline \u0111\u01a1n \u0111i\u1ec7u s\u1ebd\u00a0kh\u00f4ng g\u00e2y \u0111\u01b0\u1ee3c \u1ea5n t\u01b0\u1ee3ng. Ta c\u00f3 th\u1ec3 t\u00f9y bi\u1ebfn v\u1edbi m\u1ed9t v\u00e0i t\u00ednh n\u0103ng \u0111i k\u00e8m:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Thembot_thoi_gian\"><\/span>Th\u00eam\/b\u1edbt th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u1eb7c \u0111\u1ecbnh ta s\u1ebd c\u00f3 2 m\u1ed1c th\u1eddi gian l\u1edbn v\u00e0 2 m\u1ed1c nh\u1ecf. \u0110\u1ec3 th\u00eam ho\u1eb7c b\u1edbt c\u00e1c m\u1ed1c m\u1ed9t c\u00e1ch th\u1ed1ng nh\u1ea5t, ta s\u1eed d\u1ee5ng\u00a0<strong>Add Shape<\/strong> trong th\u1ebb\u00a0<strong>Design:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27729\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-duong-thoi-gian-4.png\" width=\"934\" height=\"605\" title=\"tao-duong-thoi-gian-4\"><\/p>\n<ul>\n<li><em>\u0110\u1ec3 th\u00eam m\u1ed1c ph\u00eda sau, ch\u1ecdn\u00a0<strong>Add Shape After<\/strong><\/em><\/li>\n<li><em>V\u1edbi m\u1ed1c ph\u00eda tr\u01b0\u1edbc, ch\u1ecdn\u00a0<strong>Add Shape Before<\/strong><\/em><\/li>\n<li><em>\u0110\u1ed1i v\u1edbi m\u1ed1c l\u1edbn h\u01a1n (s\u1ef1 ki\u1ec7n bao tr\u00f9m), ch\u1ecdn\u00a0<\/em><strong><em>Add Shape Above<\/em><\/strong><\/li>\n<li><em>Khi mu\u1ed1n th\u00eam s\u1ef1 ki\u1ec7n con, ch\u1ecdn\u00a0<strong>Add Shape Below<\/strong><\/em><\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"Thay_doi_vi_tri_cac_moc\"><\/span>Thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c m\u1ed1c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u00f4i khi ta hi\u1ec3n th\u1ecb sai th\u1eddi gian ho\u1eb7c mu\u1ed1n c\u1eadp nh\u1eadt m\u1ed1c th\u1eddi gian. Khi \u0111\u00f3 ta c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n<ol>\n<li>Ch\u1ecdn m\u1ed1c mu\u1ed1n di chuy\u1ec3n<\/li>\n<li>\u0110\u1ec3 di chuy\u1ec3n m\u1ed1c l\u00ean s\u1edbm h\u01a1n, ch\u1ecdn\u00a0<strong>Move Up<\/strong><\/li>\n<li>\u0110\u1ec3 di chuy\u1ec3n m\u1ed1c xu\u1ed1ng mu\u1ed9n h\u01a1n, ch\u1ecdn\u00a0<strong>Move Down<\/strong><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27730\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-duong-thoi-gian-5.png\" width=\"931\" height=\"569\" title=\"tao-duong-thoi-gian-5\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Thay_doi_Layout\"><\/span>Thay \u0111\u1ed5i Layout<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00f3 nhi\u1ec1u lo\u1ea1i h\u00ecnh mi\u00eau t\u1ea3 s\u1ef1 ki\u1ec7n\/qu\u00e1 tr\u00ecnh. Ta c\u00f3 th\u1ec3 xem v\u00e0 ch\u1ecdn layout ph\u00f9 h\u1ee3p t\u1ea1i th\u1ebb\u00a0<strong>Design<\/strong>, m\u1ee5c\u00a0<strong>Layouts<\/strong><\/p>\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-785.gif\" title=\"ex101_92019-nho-785\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27731\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-duong-thoi-gian-6.png\" width=\"629\" height=\"170\" title=\"tao-duong-thoi-gian-6\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Doi_mau_va_style\"><\/span>\u0110\u1ed5i m\u00e0u v\u00e0 style<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 \u0111\u1ed5i m\u00e0u, ta ch\u1ecdn\u00a0<strong>Change Colors<\/strong><\/p>\n<p>Thay \u0111\u1ed5i Style, ta ch\u1ecdn danh s\u00e1ch <strong>SmartArt Style<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27732\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-duong-thoi-gian-7.png\" width=\"514\" height=\"163\" title=\"tao-duong-thoi-gian-7\"><\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-5.html\"><strong>T\u1ed5ng h\u1ee3p c\u00e1c k\u0129 n\u0103ng cho b\u00e0i thi MOS \u2013 Bi\u1ec3u \u0111\u1ed3\u00a0<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-cac-doi-tuong-hoa.html\">Thao t\u00e1c v\u1edbi c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u1ed3 h\u1ecda<\/a><\/strong><\/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\/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-785.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8523,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8522","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\/8522","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=8522"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8522\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8523"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}