{"id":1436,"date":"2023-07-26T09:55:04","date_gmt":"2023-07-26T09:55:04","guid":{"rendered":"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/"},"modified":"2023-07-26T09:55:04","modified_gmt":"2023-07-26T09:55:04","slug":"bagan-gelembung-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/","title":{"rendered":"Bagan gelembung di google spreadsheet (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Bagan gelembung<\/strong> adalah jenis bagan yang memungkinkan Anda memvisualisasikan tiga variabel dalam kumpulan data secara bersamaan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dua variabel pertama digunakan sebagai koordinat (x, y) pada plot sebar dan variabel ketiga digunakan untuk merepresentasikan ukuran.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah cara membuat diagram gelembung berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14212 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles8.png\" alt=\"Contoh Bagan Gelembung di Google Spreadsheet\" width=\"579\" height=\"348\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data palsu yang menampilkan berbagai statistik untuk 10 tim bola basket profesional berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14203 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles1.png\" alt=\"\" width=\"555\" height=\"374\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita perlu menggunakan format berikut untuk membuat diagram gelembung di Google Spreadsheet:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Kolom A:<\/strong> Label<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Kolom B:<\/strong> Nilai sumbu X<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Kolom C:<\/strong> Nilai sumbu Y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Kolom D:<\/strong> Warna<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Kolom E:<\/strong> Ukuran<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Bagan Gelembung<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot setiap kolom data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14204 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles2.png\" alt=\"\" width=\"550\" height=\"349\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Sisipkan<\/strong> , lalu klik <strong>Bagan<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14205 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles3.png\" alt=\"Cara Membuat Bagan Gelembung di Google Spreadsheet\" width=\"336\" height=\"328\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Google Sheets akan menyisipkan histogram secara default. Untuk mengubahnya menjadi bagan gelembung, cukup klik <strong>Tipe Bagan<\/strong> di editor bagan yang muncul di sebelah kanan layar. Lalu gulir ke bawah dan klik <strong>Bagan Gelembung<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14206\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles4.png\" alt=\"Bagan gelembung di Google Spreadsheet\" width=\"577\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini secara otomatis akan menghasilkan diagram gelembung berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14207 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles5.png\" alt=\"\" width=\"548\" height=\"467\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Edit Bagan Gelembung<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita bisa mengubah tampilan bubble chart agar lebih mudah dibaca.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, klik dua kali pada sumbu vertikal. Pada editor grafik yang muncul di sebelah kanan, ubah nilai sumbu Min dan Maks masing-masing menjadi 75 dan 115.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14208 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles6.png\" alt=\"\" width=\"246\" height=\"479\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik dua kali sumbu horizontal grafik dan ubah nilai Min dan Max masing-masing menjadi 90 dan 115.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14209\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles7.png\" alt=\"\" width=\"261\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik dua kali lagi pada grafik. Di editor grafik, pilih tab <strong>Gelembung<\/strong> dan ubah opacity menjadi 20% dan warna tepi menjadi hitam.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-14210 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles7-1.png\" alt=\"\" width=\"283\" height=\"441\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Chart &amp; Axis Titles<\/strong> dan edit teks untuk judul, subjudul, judul sumbu horizontal, dan judul sumbu vertikal.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14211 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles7-2.png\" alt=\"\" width=\"279\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Seperti inilah tampilan bagan gelembung terakhir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14212 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles8.png\" alt=\"Contoh Bagan Gelembung di Google Spreadsheet\" width=\"579\" height=\"348\" 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\/plot-kotak-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Kotak di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Pareto di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-area-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Area di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bagan gelembung adalah jenis bagan yang memungkinkan Anda memvisualisasikan tiga variabel dalam kumpulan data secara bersamaan. Dua variabel pertama digunakan sebagai koordinat (x, y) pada plot sebar dan variabel ketiga digunakan untuk merepresentasikan ukuran. Tutorial ini memberikan contoh langkah demi langkah cara membuat diagram gelembung berikut di Google Spreadsheet: Langkah 1: Buat datanya Pertama, mari [&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>Bagan Gelembung di Google Spreadsheet (Langkah demi Langkah) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram gelembung 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\/bagan-gelembung-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagan Gelembung di Google Spreadsheet (Langkah demi Langkah) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram gelembung di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T09:55:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles8.png\" \/>\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-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/\",\"name\":\"Bagan Gelembung di Google Spreadsheet (Langkah demi Langkah) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T09:55:04+00:00\",\"dateModified\":\"2023-07-26T09:55:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram gelembung di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagan gelembung 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":"Bagan Gelembung di Google Spreadsheet (Langkah demi Langkah) \u2013 Statologi","description":"Tutorial ini menjelaskan cara membuat diagram gelembung 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\/bagan-gelembung-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Bagan Gelembung di Google Spreadsheet (Langkah demi Langkah) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara membuat diagram gelembung di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-26T09:55:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-a-bulles8.png"}],"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-google-sheet\/","url":"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/","name":"Bagan Gelembung di Google Spreadsheet (Langkah demi Langkah) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T09:55:04+00:00","dateModified":"2023-07-26T09:55:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram gelembung di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagan gelembung 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\/1436"}],"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=1436"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1436\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}