{"id":3460,"date":"2023-07-17T09:06:03","date_gmt":"2023-07-17T09:06:03","guid":{"rendered":"https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/"},"modified":"2023-07-17T09:06:03","modified_gmt":"2023-07-17T09:06:03","slug":"bagan-google-sheet-abaikan-sel-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/","title":{"rendered":"Google spreadsheet: cara membuat bagan dan mengabaikan sel kosong"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat bagan di Google Spreadsheet menggunakan rentang data dan mengabaikan sel kosong apa pun dalam rentang tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan menggunakan fitur <strong>Plot Nulls<\/strong> di Google Sheets.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Buat bagan di Google Spreadsheet dan abaikan sel kosong<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang menunjukkan penjualan suatu produk selama setiap bulan dalam setahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28905 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle1.jpg\" alt=\"\" width=\"473\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin membuat diagram garis untuk memvisualisasikan penjualan setiap bulan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menyorot sel-sel dalam rentang <strong>A1:B13<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28906 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle2.jpg\" alt=\"\" width=\"462\" height=\"479\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul grafik garis berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28907 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle3.jpg\" alt=\"\" width=\"585\" height=\"379\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa ada dua celah pada diagram garis di mana kita memiliki nilai yang hilang untuk bulan Mei dan Agustus.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengisi kekosongan ini, klik dua kali di mana saja pada grafik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>editor bagan<\/strong> yang muncul, klik tab <strong>Kustomisasi<\/strong> , lalu centang kotak di samping <strong>Plot Nulls<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28908 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle4.jpg\" alt=\"\" width=\"361\" height=\"573\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kesenjangan dalam diagram garis akan terisi secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28909 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/intrigue5.jpg\" alt=\"\" width=\"569\" height=\"362\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara Mengabaikan Sel Kosong dengan Rumus<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-adalah-rentang-kosong\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara Menggunakan ISBLANK dengan Cell Range<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pengurutan-lembar-google-mengabaikan-yang-kosong\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara mengurutkan dan mengabaikan spasi kosong<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membuat bagan di Google Spreadsheet menggunakan rentang data dan mengabaikan sel kosong apa pun dalam rentang tersebut. Untungnya, hal ini mudah dilakukan menggunakan fitur Plot Nulls di Google Sheets. Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Buat bagan di Google Spreadsheet dan abaikan sel kosong Misalkan kita mempunyai [&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>Google Spreadsheet: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat grafik di Google Sheets dan mengabaikan sel kosong, dengan sebuah contoh.\" \/>\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\/bagan-google-sheet-abaikan-sel-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat grafik di Google Sheets dan mengabaikan sel kosong, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T09:06:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle1.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\/bagan-google-sheet-abaikan-sel-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/\",\"name\":\"Google Spreadsheet: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T09:06:03+00:00\",\"dateModified\":\"2023-07-17T09:06:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat grafik di Google Sheets dan mengabaikan sel kosong, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara membuat bagan dan mengabaikan sel kosong\"}]},{\"@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":"Google Spreadsheet: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial","description":"Tutorial ini menjelaskan cara membuat grafik di Google Sheets dan mengabaikan sel kosong, dengan sebuah contoh.","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\/bagan-google-sheet-abaikan-sel-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial","og_description":"Tutorial ini menjelaskan cara membuat grafik di Google Sheets dan mengabaikan sel kosong, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-17T09:06:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle1.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\/bagan-google-sheet-abaikan-sel-kosong\/","url":"https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/","name":"Google Spreadsheet: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T09:06:03+00:00","dateModified":"2023-07-17T09:06:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat grafik di Google Sheets dan mengabaikan sel kosong, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bagan-google-sheet-abaikan-sel-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara membuat bagan dan mengabaikan sel kosong"}]},{"@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\/3460"}],"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=3460"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3460\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}