{"id":2743,"date":"2023-07-20T22:10:36","date_gmt":"2023-07-20T22:10:36","guid":{"rendered":"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/"},"modified":"2023-07-20T22:10:36","modified_gmt":"2023-07-20T22:10:36","slug":"bilah-kemajuan-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/","title":{"rendered":"Cara membuat progress bar di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial langkah demi langkah ini menjelaskan cara membuat bilah kemajuan berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24147\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/progres5.jpg\" alt=\"bilah kemajuan di Excel\" width=\"594\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan beberapa data yang menunjukkan persentase kemajuan untuk 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<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Tambahkan Bilah Kemajuan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot cell range <strong>B2:B11<\/strong> yang berisi persentase kemajuan, lalu klik ikon <strong>Conditional Formatting<\/strong> pada tab <strong>Home<\/strong> , lalu klik <strong>Data Bars<\/strong> , lalu klik <strong>More Rules<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24144 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/progres2.jpg\" alt=\"\" width=\"501\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jendela baru muncul yang memungkinkan Anda memformat bilah data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk <strong>Minimum<\/strong> , ubah <strong>Type<\/strong> menjadi <strong>Number<\/strong> dan <strong>Value<\/strong> menjadi <strong>0<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk <strong>Maksimum<\/strong> , ubah <strong>Type<\/strong> menjadi <strong>Number<\/strong> dan <strong>Value<\/strong> menjadi <strong>1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian pilih warna yang Anda inginkan untuk batangannya. Kami akan memilih hijau muda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24145 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/progres3.jpg\" alt=\"\" width=\"652\" height=\"539\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , bilah kemajuan akan muncul di setiap sel di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24146 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/progres4.jpg\" alt=\"\" width=\"444\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Format Bilah Kemajuan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, kita bisa memperluas lebar kolom dan lebar baris di spreadsheet Excel kita sehingga bilah kemajuan menjadi lebih besar dan lebih mudah dibaca.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga bisa menambahkan batas di sekeliling sel dan meratakan teks sehingga persentasenya berada di sisi kiri sel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24147 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/progres5.jpg\" alt=\"\" width=\"594\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda memperbarui persentase mana pun, panjang bilah kemajuan akan berubah secara otomatis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita mengubah persentase kemajuan terakhir menjadi 22%:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24148 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/progres6.jpg\" alt=\"\" width=\"585\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa bilah kemajuan secara otomatis diperpendek untuk mencerminkan persentase baru ini.<\/span><\/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><br \/> <a href=\"https:\/\/statorials.org\/id\/statistik-kontrol-proses-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Kendali Proses Statistik di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial langkah demi langkah ini menjelaskan cara membuat bilah kemajuan berikut di Excel: Langkah 1: Masukkan datanya Pertama, masukkan beberapa data yang menunjukkan persentase kemajuan untuk 10 tugas berbeda: Langkah 2: Tambahkan Bilah Kemajuan Selanjutnya, sorot cell range B2:B11 yang berisi persentase kemajuan, lalu klik ikon Conditional Formatting pada tab Home , lalu klik Data [&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 Progress Bar di Excel (Langkah demi Langkah) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini memberikan contoh langkah demi langkah membuat bilah kemajuan di Excel.\" \/>\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\/bilah-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 Progress Bar di Excel (Langkah demi Langkah) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini memberikan contoh langkah demi langkah membuat bilah kemajuan di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T22:10:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/progres5.jpg\" \/>\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\/bilah-kemajuan-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/\",\"name\":\"Cara Membuat Progress Bar di Excel (Langkah demi Langkah) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T22:10:36+00:00\",\"dateModified\":\"2023-07-20T22:10:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini memberikan contoh langkah demi langkah membuat bilah kemajuan di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat progress bar 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 Progress Bar di Excel (Langkah demi Langkah) - Statologi","description":"Tutorial ini memberikan contoh langkah demi langkah membuat bilah kemajuan di Excel.","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\/bilah-kemajuan-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Progress Bar di Excel (Langkah demi Langkah) - Statologi","og_description":"Tutorial ini memberikan contoh langkah demi langkah membuat bilah kemajuan di Excel.","og_url":"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-20T22:10:36+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/progres5.jpg"}],"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\/bilah-kemajuan-excel\/","url":"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/","name":"Cara Membuat Progress Bar di Excel (Langkah demi Langkah) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T22:10:36+00:00","dateModified":"2023-07-20T22:10:36+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini memberikan contoh langkah demi langkah membuat bilah kemajuan di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bilah-kemajuan-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat progress bar 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\/2743"}],"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=2743"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2743\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}