{"id":781,"date":"2023-07-28T18:58:49","date_gmt":"2023-07-28T18:58:49","guid":{"rendered":"https:\/\/statorials.org\/id\/grafik-gantt-excel\/"},"modified":"2023-07-28T18:58:49","modified_gmt":"2023-07-28T18:58:49","slug":"grafik-gantt-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grafik-gantt-excel\/","title":{"rendered":"Cara membuat gantt chart di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Bagan Gantt<\/strong> adalah jenis bagan yang menunjukkan waktu mulai dan selesainya berbagai tugas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara membuat diagram Gantt berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8598 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ganttexcel8.png\" alt=\"Bagan Gantt di Excel\" width=\"568\" height=\"355\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Bagan Gantt di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Ikuti langkah-langkah berikut untuk membuat bagan Gantt di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Masukkan nama, tanggal mulai, dan durasi setiap tugas di kolom terpisah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8589 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ganttexcel1.png\" alt=\"\" width=\"434\" height=\"381\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Ubah format tanggal menjadi jumlah hari sejak 1 Januari 1990.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Secara default, tanggal di Excel disimpan sebagai jumlah hari sejak 1 Januari 1990. Untuk membuat bagan Gantt, kita perlu mengonversi tanggal menjadi angka menggunakan rumus berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8590 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ganttexcel2.png\" alt=\"\" width=\"409\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Sisipkan diagram batang bertumpuk.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot sel A10:C16. Di grup <strong>Charts<\/strong> pada tab <strong>Insert<\/strong> , klik opsi yang bertuliskan <strong>2D Stacked Bar Chart<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8591 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ganttexcel3.png\" alt=\"\" width=\"663\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<p data-slot-rendered-dynamic=\"true\"> <span style=\"color: #000000;\">Grafik berikut akan otomatis muncul:<\/span> <\/p>\n<p data-slot-rendered-dynamic=\"true\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8592 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ganttexcel4.png\" alt=\"\" width=\"447\" height=\"283\" srcset=\"\" sizes=\"\"><\/p>\n<p data-slot-rendered-dynamic=\"true\"> <span style=\"color: #000000;\"><strong>Langkah 4: Ubah tampilan grafik.<\/strong><\/span><\/p>\n<p data-slot-rendered-dynamic=\"true\"> <span style=\"color: #000000;\">Terakhir, kami akan mengubah tampilan diagram Gantt.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Balikkan urutan tugas.<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Klik kanan tugas apa pun di bagan. Lalu klik <strong>Format Sumbu\u2026<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Centang kotak di samping <b>Kategori dalam urutan terbalik<\/b> .<\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8594 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ganttexcel5.png\" alt=\"\" width=\"252\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Hapus bilah biru.<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Klik kanan pada salah satu bilah biru. Lalu klik <strong>Format Seri Data\u2026<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik ikon ember cat, lalu klik Isi, lalu klik <strong>Tanpa Isi<\/strong> .<\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8595 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ganttexcel6.png\" alt=\"\" width=\"263\" height=\"296\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Edit tanggal pada sumbu x.<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Klik kanan pada salah satu tanggal. Lalu klik <strong>Format Sumbu\u2026<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Di bawah <strong>Opsi Sumbu<\/strong> , ubah nilai <strong>Minimum<\/strong> menjadi 43830 untuk mencerminkan tanggal paling awal tugas pertama.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Di bawah <strong>Nomor<\/strong> , ubah <strong>kategori<\/strong> menjadi Tanggal.<\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8597 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ganttexcel7-1.png\" alt=\"\" width=\"245\" height=\"600\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ubah judul grafik sesuai keinginan. Klik pada keterangan di bagian bawah dan hapus.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Hasil akhirnya akan terlihat seperti ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8598 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ganttexcel8.png\" alt=\"Bagan Gantt di Excel\" width=\"568\" height=\"355\" srcset=\"\" sizes=\"\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bagan Gantt adalah jenis bagan yang menunjukkan waktu mulai dan selesainya berbagai tugas. Tutorial ini menjelaskan cara membuat diagram Gantt berikut di Excel: Contoh: Bagan Gantt di Excel Ikuti langkah-langkah berikut untuk membuat bagan Gantt di Excel. Langkah 1: Masukkan datanya. Masukkan nama, tanggal mulai, dan durasi setiap tugas di kolom terpisah: Langkah 2: Ubah [&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 Gantt Chart di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat Gantt chart di Excel, termasuk 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\/grafik-gantt-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Gantt Chart di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat Gantt chart di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grafik-gantt-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T18:58:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ganttexcel8.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-gantt-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/grafik-gantt-excel\/\",\"name\":\"Cara Membuat Gantt Chart di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T18:58:49+00:00\",\"dateModified\":\"2023-07-28T18:58:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat Gantt chart di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grafik-gantt-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grafik-gantt-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-gantt-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat gantt chart di excel\"}]},{\"@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 Gantt Chart di Excel - Statologi","description":"Penjelasan sederhana cara membuat Gantt chart di Excel, termasuk 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\/grafik-gantt-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Gantt Chart di Excel - Statologi","og_description":"Penjelasan sederhana cara membuat Gantt chart di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/grafik-gantt-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T18:58:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ganttexcel8.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/grafik-gantt-excel\/","url":"https:\/\/statorials.org\/id\/grafik-gantt-excel\/","name":"Cara Membuat Gantt Chart di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T18:58:49+00:00","dateModified":"2023-07-28T18:58:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat Gantt chart di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grafik-gantt-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grafik-gantt-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grafik-gantt-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat gantt chart di excel"}]},{"@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\/781"}],"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=781"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/781\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}