{"id":2706,"date":"2023-07-21T02:21:52","date_gmt":"2023-07-21T02:21:52","guid":{"rendered":"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/"},"modified":"2023-07-21T02:21:52","modified_gmt":"2023-07-21T02:21:52","slug":"bagan-gelembung-excel-dengan-label","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/","title":{"rendered":"Excel: cara membuat bagan gelembung dengan label"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan gelembung berikut dengan label di Excel:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23839\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bulle8.jpg\" alt=\"bagan gelembung dengan label di Excel\" width=\"541\" height=\"391\" 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 data berikut ke dalam Excel yang memperlihatkan berbagai atribut untuk 10 pemain bola basket berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23832 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bulle1-1.jpg\" alt=\"\" width=\"429\" height=\"334\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Bagan Gelembung<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot sel dalam rentang <strong>B2:D11<\/strong> . Lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik opsi <strong>Bagan Gelembung<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23833 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bulle2-1.jpg\" alt=\"\" width=\"614\" height=\"446\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bagan gelembung berikut akan dibuat secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23834 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bulle3-1.jpg\" alt=\"\" width=\"587\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x menunjukkan <strong>titik<\/strong> , sumbu y menunjukkan <strong>bantuan<\/strong> , dan ukuran setiap gelembung menunjukkan <strong>pantulan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun sulit untuk mengetahui gelembung mana yang mewakili pemain mana karena tidak ada labelnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan Tag<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk menambahkan label ke bagan gelembung, klik di mana saja pada bagan, lalu klik tanda tambah hijau \u201c <strong>+<\/strong> \u201d di sudut kanan atas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik panah di samping <strong>Label Data<\/strong> , lalu klik <strong>Opsi Lainnya<\/strong> dari menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23835 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bulle4.jpg\" alt=\"\" width=\"544\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel yang muncul di sisi kanan layar, centang kotak di samping <strong>Nilai Sel<\/strong> di grup <strong>Opsi Label<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-23836 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bulle5.jpg\" alt=\"\" width=\"302\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, pilih <strong>A2:A11<\/strong> sebagai cell range yang berisi label kita:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23837 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bulle6.jpg\" alt=\"\" width=\"450\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik <strong>OK<\/strong> dan di panel <strong>Format Label Data<\/strong> di sisi kanan layar, hapus centang pada kotak di samping <strong>Nilai Y<\/strong> dan pilih <strong>Tengah<\/strong> sebagai posisi label.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Label berikut akan secara otomatis ditambahkan ke bagan gelembung:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23838 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bulle7.jpg\" alt=\"\" width=\"529\" height=\"371\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Sesuaikan Bagan Gelembung<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Terakhir, silakan klik masing-masing elemen bagan untuk menambahkan judul, menambahkan label sumbu, mengubah ukuran font label, dan menghapus garis kisi:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23839\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bulle8.jpg\" alt=\"bagan gelembung dengan label di Excel\" width=\"541\" height=\"391\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Papan gelembung terakhir mudah dibaca dan kita tahu persis gelembung mana yang mewakili pemain mana.<\/span><\/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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/menggambar-banyak-garis-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menggambar banyak garis di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/plot-kotak-berdampingan-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Kotak Berdampingan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Ogive di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan gelembung berikut dengan label di Excel: Langkah 1: Masukkan datanya Pertama, masukkan data berikut ke dalam Excel yang memperlihatkan berbagai atribut untuk 10 pemain bola basket berbeda: Langkah 2: Buat Bagan Gelembung Selanjutnya, sorot sel dalam rentang B2:D11 . Lalu klik tab Sisipkan di [&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 Gelembung dengan Label - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram gelembung dengan label di Excel, 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\/bagan-gelembung-excel-dengan-label\/\" \/>\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 Gelembung dengan Label - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram gelembung dengan label di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T02:21:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bulle8.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-gelembung-excel-dengan-label\/\",\"url\":\"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/\",\"name\":\"Excel: Cara Membuat Bagan Gelembung dengan Label - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T02:21:52+00:00\",\"dateModified\":\"2023-07-21T02:21:52+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram gelembung dengan label di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara membuat bagan gelembung dengan label\"}]},{\"@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 Gelembung dengan Label - Statorial","description":"Tutorial ini menjelaskan cara membuat diagram gelembung dengan label di Excel, 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\/bagan-gelembung-excel-dengan-label\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Membuat Bagan Gelembung dengan Label - Statorial","og_description":"Tutorial ini menjelaskan cara membuat diagram gelembung dengan label di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/","og_site_name":"Statorials","article_published_time":"2023-07-21T02:21:52+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bulle8.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-gelembung-excel-dengan-label\/","url":"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/","name":"Excel: Cara Membuat Bagan Gelembung dengan Label - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T02:21:52+00:00","dateModified":"2023-07-21T02:21:52+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram gelembung dengan label di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara membuat bagan gelembung dengan label"}]},{"@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\/2706"}],"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=2706"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2706\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}