{"id":4635,"date":"2023-07-09T10:30:22","date_gmt":"2023-07-09T10:30:22","guid":{"rendered":"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/"},"modified":"2023-07-09T10:30:22","modified_gmt":"2023-07-09T10:30:22","slug":"membuat-garis-waktu-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/","title":{"rendered":"Cara membuat timeline di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat garis waktu di Excel untuk memvisualisasikan kapan peristiwa tertentu akan terjadi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, ini cukup mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara membuat garis waktu berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36178 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie10.png\" alt=\"\" width=\"626\" height=\"330\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 1: Masukkan datanya<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, kita akan memasukkan data berikut ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36169 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie1-1.png\" alt=\"\" width=\"460\" height=\"389\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 2: Sisipkan Diagram Batang<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>A2:B11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon bernama <strong>Kolom yang Dikelompokkan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30237 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diagramme-a-bandes.jpg\" alt=\"\" width=\"607\" height=\"145\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Diagram batang berikut akan dibuat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36170 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie2.png\" alt=\"\" width=\"544\" height=\"328\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 3: Tambahkan Label Data<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tanda plus berwarna hijau di pojok kanan atas grafik, lalu klik <strong>Label Data<\/strong> , lalu klik <strong>Opsi Lainnya<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36171 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie3.png\" alt=\"\" width=\"498\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel yang muncul di sisi kanan layar, hapus centang pada kotak di samping <strong>Nilai<\/strong> , lalu centang kotak di samping <strong>Nilai Dari Sel<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela yang muncul, pilih range <strong>C2:C11<\/strong> lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36172 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie4.png\" alt=\"\" width=\"514\" height=\"569\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai di kolom \u201cNama Tugas\u201d akan ditambahkan ke bagan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36173 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie5.png\" alt=\"\" width=\"585\" height=\"349\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Edit Bilah<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik pada batang mana saja pada grafik. Di panel <strong>Format Seri Data<\/strong> di sisi kanan layar, pilih <strong>Tanpa isi<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36174 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie6.png\" alt=\"\" width=\"329\" height=\"500\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik tanda plus kecil di pojok kanan atas grafik, lalu klik <strong>Error Bars<\/strong> , lalu klik <strong>More Options<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36175 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie7.png\" alt=\"\" width=\"554\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Format Error Bars<\/strong> yang muncul di sisi kanan layar, pilih <strong>Minus<\/strong> as Direction, lalu klik <strong>Percentage<\/strong> as Error Amount dan ketik <strong>100%<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36176 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie8.png\" alt=\"\" width=\"302\" height=\"539\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bilah grafik sekarang akan muncul sebagai garis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36177 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie9.png\" alt=\"\" width=\"574\" height=\"339\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 5: Sesuaikan grafik<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, silakan sesuaikan grafik dengan melakukan perubahan berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Klik pada bilah horizontal dan hapus.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tambahkan judul bagan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Buat font tebal agar label lebih mudah dibaca.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Garis waktu terakhir akan terlihat seperti ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36178 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie10.png\" alt=\"\" width=\"626\" height=\"330\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda tidak ingin peristiwa apa pun ditampilkan di bawah sumbu x, cukup buat semua nilai di kolom &#8220;Tinggi Tugas&#8221; di spreadsheet menjadi positif.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Progress Bar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Donat Ganda di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bilah-diagram-lingkaran-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Batang Diagram Lingkaran di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membuat garis waktu di Excel untuk memvisualisasikan kapan peristiwa tertentu akan terjadi. Untungnya, ini cukup mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara membuat garis waktu berikut di Excel: Ayo pergi! Langkah 1: Masukkan datanya Pertama, kita akan memasukkan data berikut ke dalam Excel: Langkah 2: Sisipkan Diagram Batang [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Membuat Timeline di Excel (Langkah demi Langkah) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat timeline di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Timeline di Excel (Langkah demi Langkah) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat timeline di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T10:30:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie10.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/\",\"name\":\"Cara Membuat Timeline di Excel (Langkah demi Langkah) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T10:30:22+00:00\",\"dateModified\":\"2023-07-09T10:30:22+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat timeline di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat timeline di excel (langkah demi langkah)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Membuat Timeline di Excel (Langkah demi Langkah) - Statologi","description":"Tutorial ini menjelaskan cara membuat timeline di Excel, dengan contoh langkah demi langkah.","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:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Timeline di Excel (Langkah demi Langkah) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat timeline di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-09T10:30:22+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie10.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/","url":"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/","name":"Cara Membuat Timeline di Excel (Langkah demi Langkah) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T10:30:22+00:00","dateModified":"2023-07-09T10:30:22+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat timeline di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat timeline di excel (langkah demi langkah)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4635"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4635"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4635\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}