{"id":4665,"date":"2023-07-09T04:06:09","date_gmt":"2023-07-09T04:06:09","guid":{"rendered":"https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/"},"modified":"2023-07-09T04:06:09","modified_gmt":"2023-07-09T04:06:09","slug":"pelacakan-kemajuan-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/","title":{"rendered":"Cara membuat pelacak kemajuan di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial langkah demi langkah ini menjelaskan cara membuat pelacak kemajuan berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36416 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme6.png\" alt=\"\" width=\"568\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan beberapa data yang menunjukkan kemajuan dalam 10 tugas berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24143 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/progres1.jpg\" alt=\"\" width=\"470\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Diagram Batang Horizontal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>A1:B11<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon yang disebut <strong>Bilah 2D yang Dikelompokkan<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36411 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme1.png\" alt=\"\" width=\"364\" height=\"345\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul grafik batang berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36412 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme2.png\" alt=\"\" width=\"575\" height=\"371\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan Rentang Sumbu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik dua kali sumbu x di bagian bawah grafik. Pada panel <strong>Format Axis<\/strong> yang muncul di sisi kanan layar, ubah nilai <strong>maksimum<\/strong> menjadi <strong>1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36413 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme3.png\" alt=\"\" width=\"309\" height=\"627\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x pada grafik akan diperbarui dari 0% menjadi 100%:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36414 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme4.png\" alt=\"\" width=\"559\" height=\"364\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Tambahkan Label Data<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik di mana saja pada grafik. Lalu klik tanda plus berwarna hijau di pojok kanan atas diagram, lalu centang kotak di samping <strong>Label Data<\/strong> untuk menambahkan label di akhir setiap batang:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36415 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme5.png\" alt=\"\" width=\"667\" height=\"327\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 5: Sesuaikan Tampilan Bagan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, silakan klik elemen bagan individual seperti judul, label data, label sumbu, dan batang itu sendiri untuk mengubah ukuran font dan warna batang:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36416 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme6.png\" alt=\"\" width=\"568\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Langkah 6: Perbarui data<\/span><\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Jika Anda memperbarui salah satu nilai dalam kumpulan data asli, bilah pelacak kemajuan akan diperbarui secara otomatis untuk mencerminkan nilai kemajuan baru.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita mengubah kemajuan <strong>tugas 10<\/strong> dari <strong>22%<\/strong> menjadi <strong>90%<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bilah kemajuan untuk <strong>tugas 10<\/strong> akan diperbarui secara otomatis dalam grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36417 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme7.png\" alt=\"\" width=\"670\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/grafik-gantt-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Gantt Chart di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/membuat-garis-waktu-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Garis Waktu 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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial langkah demi langkah ini menjelaskan cara membuat pelacak kemajuan berikut di Excel: Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan beberapa data yang menunjukkan kemajuan dalam 10 tugas berbeda: Langkah 2: Buat Diagram Batang Horizontal Selanjutnya, sorot rentang sel A1:B11 , lalu klik tab Sisipkan di sepanjang pita atas, lalu klik ikon yang [&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 Pelacak Kemajuan di Excel (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat pelacak kemajuan 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\/pelacakan-kemajuan-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Pelacak Kemajuan di Excel (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat pelacak kemajuan di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T04:06:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme6.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\/pelacakan-kemajuan-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/\",\"name\":\"Cara Membuat Pelacak Kemajuan di Excel (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T04:06:09+00:00\",\"dateModified\":\"2023-07-09T04:06:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat pelacak kemajuan di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat pelacak kemajuan di excel (dengan contoh)\"}]},{\"@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 Pelacak Kemajuan di Excel (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara membuat pelacak kemajuan 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\/pelacakan-kemajuan-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Pelacak Kemajuan di Excel (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara membuat pelacak kemajuan di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-09T04:06:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme6.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\/pelacakan-kemajuan-excel\/","url":"https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/","name":"Cara Membuat Pelacak Kemajuan di Excel (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T04:06:09+00:00","dateModified":"2023-07-09T04:06:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat pelacak kemajuan di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pelacakan-kemajuan-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat pelacak kemajuan di excel (dengan contoh)"}]},{"@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\/4665"}],"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=4665"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4665\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}