{"id":2744,"date":"2023-07-20T22:06:23","date_gmt":"2023-07-20T22:06:23","guid":{"rendered":"https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/"},"modified":"2023-07-20T22:06:23","modified_gmt":"2023-07-20T22:06:23","slug":"bilah-kemajuan-google-spreadsheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/","title":{"rendered":"Cara membuat bilah kemajuan di google spreadsheet (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 Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24158\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prog4.jpg\" alt=\"bilah kemajuan di Google Spreadsheet\" width=\"629\" height=\"413\" 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-24155 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prog1.jpg\" alt=\"\" width=\"477\" height=\"407\" 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, ketik rumus berikut di sel <strong>C2<\/strong> untuk membuat bilah kemajuan untuk tugas pertama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SPARKLINE( <span style=\"color: #ff6600;\">B2<\/span> ,{\" <span style=\"color: #008000;\">charttype<\/span> \",\" <span style=\"color: #008000;\">bar<\/span> \";\" <span style=\"color: #008000;\">max<\/span> \", <span style=\"color: #3366ff;\">1<\/span> ;\" <span style=\"color: #008000;\">min<\/span> \", <span style=\"color: #3366ff;\">0<\/span> ;\" <span style=\"color: #008000;\">color1<\/span> \",\" <span style=\"color: #008000;\">green<\/span> \"})\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Salin dan tempel rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24156 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prog2.jpg\" alt=\"\" width=\"654\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Panjang setiap bilah kemajuan di kolom C mencerminkan nilai persentase di kolom B.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Format Bilah Kemajuan (Opsional)<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Anda dapat mengubah bilah kemajuan untuk menampilkan warna tertentu berdasarkan persentase kemajuan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda dapat menggunakan rumus berikut untuk menampilkan bilah kemajuan <strong>berwarna hijau<\/strong> jika persentasenya lebih besar dari 70, jika tidak, bilah kemajuan <strong>berwarna kuning<\/strong> jika persentasenya lebih besar dari 50, jika tidak, bilah kemajuan <strong>berwarna merah<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SPARKLINE( <span style=\"color: #ff6600;\">B2<\/span> ,{\" <span style=\"color: #008000;\">charttype<\/span> \",\" <span style=\"color: #008000;\">bar<\/span> \"; \" <span style=\"color: #008000;\">max<\/span> \", <span style=\"color: #3366ff;\">1<\/span> ; \" <span style=\"color: #008000;\">min<\/span> \", <span style=\"color: #3366ff;\">0<\/span> ; \" <span style=\"color: #008000;\">color1<\/span> \",IF( <span style=\"color: #ff6600;\">B2<\/span> &gt; <span style=\"color: #3366ff;\">0.7<\/span> ,\" <span style=\"color: #008000;\">green<\/span> \",IF( <span style=\"color: #ff6600;\">B2<\/span> &gt; <span style=\"color: #3366ff;\">0.5<\/span> ,\" <span style=\"color: #008000;\">yellow<\/span> \", \" <span style=\"color: #008000;\">red<\/span> \"))})\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24157 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme3.jpg\" alt=\"\" width=\"501\" height=\"441\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Warna bilah kemajuan sekarang bergantung pada nilai kolom B.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menambahkan batas di sekeliling sel dan menambah panjang dan lebar sel untuk membuat bilah kemajuan lebih besar dan lebih mudah dibaca:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24158\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prog4.jpg\" alt=\"bilah kemajuan di Google Spreadsheet\" width=\"629\" height=\"413\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara membuat visualisasi umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memplot-beberapa-baris\/\" target=\"_blank\" rel=\"noopener\">Cara menggambar banyak garis di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-area-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Area di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pengukur-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Pengukur di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial langkah demi langkah ini menjelaskan cara membuat bilah kemajuan berikut di Google Spreadsheet: Langkah 1: Masukkan datanya Pertama, masukkan beberapa data yang menunjukkan persentase kemajuan untuk 10 tugas berbeda: Langkah 2: Tambahkan Bilah Kemajuan Selanjutnya, ketik rumus berikut di sel C2 untuk membuat bilah kemajuan untuk tugas pertama: =SPARKLINE( B2 ,{&#8221; charttype &#8220;,&#8221; bar [&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 Bilah Kemajuan di Google Spreadsheet (Langkah demi Langkah) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat bilah kemajuan di Google Spreadsheet, 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\/bilah-kemajuan-google-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Bilah Kemajuan di Google Spreadsheet (Langkah demi Langkah) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat bilah kemajuan di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T22:06:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prog4.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-google-spreadsheet\/\",\"url\":\"https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/\",\"name\":\"Cara Membuat Bilah Kemajuan di Google Spreadsheet (Langkah demi Langkah) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T22:06:23+00:00\",\"dateModified\":\"2023-07-20T22:06:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat bilah kemajuan di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bilah kemajuan di google spreadsheet (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 Bilah Kemajuan di Google Spreadsheet (Langkah demi Langkah) \u2013 Statorial","description":"Tutorial ini menjelaskan cara membuat bilah kemajuan di Google Spreadsheet, 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\/bilah-kemajuan-google-spreadsheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bilah Kemajuan di Google Spreadsheet (Langkah demi Langkah) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara membuat bilah kemajuan di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/","og_site_name":"Statorials","article_published_time":"2023-07-20T22:06:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/prog4.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-google-spreadsheet\/","url":"https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/","name":"Cara Membuat Bilah Kemajuan di Google Spreadsheet (Langkah demi Langkah) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T22:06:23+00:00","dateModified":"2023-07-20T22:06:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat bilah kemajuan di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bilah-kemajuan-google-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bilah kemajuan di google spreadsheet (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\/2744"}],"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=2744"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2744\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}