{"id":3458,"date":"2023-07-17T09:23:30","date_gmt":"2023-07-17T09:23:30","guid":{"rendered":"https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/"},"modified":"2023-07-17T09:23:30","modified_gmt":"2023-07-17T09:23:30","slug":"bagan-excel-abaikan-label-sumbu-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/","title":{"rendered":"Excel: cara membuat bagan &amp; mengabaikan label sumbu kosong"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan di Excel dan mengabaikan label sumbu kosong.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 1: Masukkan data dengan nilai kosong<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan kumpulan data berikut ke dalam Excel yang berisi nilai kosong untuk label sumbu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28891 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer1.jpg\" alt=\"\" width=\"387\" height=\"461\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita menyorot rentang data ini dan menyisipkan diagram batang, sumbu x akan memiliki beberapa nilai kosong:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28892 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer2.jpg\" alt=\"\" width=\"480\" height=\"343\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Edit data untuk menghapus nilai kosong<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Pada langkah ini, kita akan membuat dataset baru yang menghapus semua nilai kosong dari dataset asli.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, ketik rumus berikut di sel D2:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IFERROR(INDEX( <span style=\"color: #3366ff;\">$A$2:$A$9<\/span> ,AGGREGATE(15,3,ROW( <span style=\"color: #3366ff;\">$A$2:$A$9<\/span> )-ROW( <span style=\"color: #ff0000;\">$A$1<\/span> )\/( <span style=\"color: #3366ff;\">$A$2:$A$9<\/span> &lt;&gt;\"\") ,ROWS( <span style=\"color: #800080;\">$A$2:A2<\/span> ))),\"\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Lalu seret rumus ke sel lain di kolom D hingga Anda menemukan nilai kosong:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28893 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer3.jpg\" alt=\"\" width=\"497\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketikkan rumus berikut di sel E2:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=INDEX( <span style=\"color: #3366ff;\">$B$2:$B$9<\/span> ,MATCH( <span style=\"color: #ff0000;\">D2<\/span> , <span style=\"color: #800080;\">$A$2:$A$9<\/span> ,0))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Lalu seret rumus ke sel lainnya di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28894 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer4.jpg\" alt=\"\" width=\"547\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami telah berhasil membuat kumpulan data baru yang hanya berisi baris-baris yang nilai kolom &#8216;Store&#8217; aslinya tidak kosong.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Buat bagan tanpa label sumbu kosong<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Sekarang kita dapat menyorot sel dalam rentang <strong>D2:E6<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon yang disebut <strong>Kolom yang Dikelompokkan<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28895 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer5-1.jpg\" alt=\"\" width=\"676\" height=\"552\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sumbu x pada grafik tidak berisi label kosong karena kami menggunakan kumpulan data yang dimodifikasi untuk membuat grafik ini.<\/span><\/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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/label-plot-sebar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menambahkan Label ke Scatterplot Point di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/\" target=\"_blank\" rel=\"noopener\">Cara mengubah skala sumbu di plot Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tambahkan-grafik-excel-dengan-garis-vertikal\/\" target=\"_blank\" rel=\"noopener\">Cara Menambahkan Garis Vertikal pada Bagan di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan di Excel dan mengabaikan label sumbu kosong. Langkah 1: Masukkan data dengan nilai kosong Pertama, masukkan kumpulan data berikut ke dalam Excel yang berisi nilai kosong untuk label sumbu: Jika kita menyorot rentang data ini dan menyisipkan diagram batang, sumbu x akan memiliki beberapa [&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 Label Sumbu Kosong - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat grafik di Excel dan mengabaikan label sumbu 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-abaikan-label-sumbu-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 Label Sumbu Kosong - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat grafik di Excel dan mengabaikan label sumbu kosong, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T09:23:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer1.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-abaikan-label-sumbu-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/\",\"name\":\"Excel: Cara Membuat Bagan dan Mengabaikan Label Sumbu Kosong - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T09:23:30+00:00\",\"dateModified\":\"2023-07-17T09:23:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat grafik di Excel dan mengabaikan label sumbu kosong, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara membuat bagan &amp; mengabaikan label sumbu 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 Label Sumbu Kosong - Statorials","description":"Tutorial ini menjelaskan cara membuat grafik di Excel dan mengabaikan label sumbu 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-abaikan-label-sumbu-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Membuat Bagan dan Mengabaikan Label Sumbu Kosong - Statorials","og_description":"Tutorial ini menjelaskan cara membuat grafik di Excel dan mengabaikan label sumbu kosong, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-17T09:23:30+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer1.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-abaikan-label-sumbu-kosong\/","url":"https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/","name":"Excel: Cara Membuat Bagan dan Mengabaikan Label Sumbu Kosong - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T09:23:30+00:00","dateModified":"2023-07-17T09:23:30+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat grafik di Excel dan mengabaikan label sumbu kosong, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bagan-excel-abaikan-label-sumbu-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara membuat bagan &amp; mengabaikan label sumbu 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\/3458"}],"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=3458"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3458\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}