{"id":3192,"date":"2023-07-18T18:32:16","date_gmt":"2023-07-18T18:32:16","guid":{"rendered":"https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/"},"modified":"2023-07-18T18:32:16","modified_gmt":"2023-07-18T18:32:16","slug":"bagan-excel-mengabaikan-sel-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/","title":{"rendered":"Excel: cara membuat bagan dan mengabaikan sel kosong"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat bagan di Excel menggunakan rentang data dan mengabaikan sel kosong dalam rentang tersebut.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dengan menggunakan fitur <strong>Sel Tersembunyi dan Sel Kosong<\/strong> di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Buat Bagan di Excel dan Abaikan Sel Kosong<\/strong><\/span><\/h3>\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-27124 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer11.jpg\" alt=\"\" width=\"406\" height=\"384\" 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 dalam rentang <strong>B2:B13<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik tombol <strong>Garis<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27125 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique-en-ligne.jpg\" alt=\"\" width=\"590\" height=\"261\" 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-27126 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer12.jpg\" alt=\"\" width=\"597\" height=\"407\" 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 kanan di mana saja pada grafik lalu klik <strong>Pilih Data<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27127 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer134.jpg\" alt=\"\" width=\"564\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik tombol <strong>Sel Tersembunyi dan Kosong<\/strong> di pojok kiri bawah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27128 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer14.jpg\" alt=\"\" width=\"604\" height=\"344\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, centang tombol di sebelah <strong>Hubungkan titik data dengan garis<\/strong> lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27129 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer15.jpg\" alt=\"\" width=\"325\" height=\"221\" 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=\"aligncenter wp-image-27130\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer16.jpg\" alt=\"Bagan Excel mengabaikan bagian yang kosong\" width=\"625\" height=\"418\" 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 melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-ganti-na\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti nilai #N\/A di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menginterpolasi nilai yang hilang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-duplikat\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung duplikat di excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membuat bagan di Excel menggunakan rentang data dan mengabaikan sel kosong dalam rentang tersebut. Untungnya, hal ini mudah dilakukan dengan menggunakan fitur Sel Tersembunyi dan Sel Kosong di Excel. Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Buat Bagan di Excel dan Abaikan Sel Kosong Misalkan kita mempunyai kumpulan [&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>Excel: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat grafik di Excel 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-excel-mengabaikan-sel-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat grafik di Excel dan mengabaikan sel kosong, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T18:32:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer11.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-excel-mengabaikan-sel-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/\",\"name\":\"Excel: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T18:32:16+00:00\",\"dateModified\":\"2023-07-18T18:32:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat grafik di Excel dan mengabaikan sel kosong, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: 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":"Excel: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial","description":"Tutorial ini menjelaskan cara membuat grafik di Excel 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-excel-mengabaikan-sel-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial","og_description":"Tutorial ini menjelaskan cara membuat grafik di Excel dan mengabaikan sel kosong, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-18T18:32:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer11.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-excel-mengabaikan-sel-kosong\/","url":"https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/","name":"Excel: Cara Membuat Bagan dan Mengabaikan Sel Kosong - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T18:32:16+00:00","dateModified":"2023-07-18T18:32:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat grafik di Excel dan mengabaikan sel kosong, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bagan-excel-mengabaikan-sel-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: 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\/3192"}],"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=3192"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3192\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}