{"id":4849,"date":"2023-07-07T06:31:52","date_gmt":"2023-07-07T06:31:52","guid":{"rendered":"https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/"},"modified":"2023-07-07T06:31:52","modified_gmt":"2023-07-07T06:31:52","slug":"warna-bagan-gelembung-excel-berdasarkan-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/","title":{"rendered":"Excel: cara mewarnai bagan gelembung berdasarkan nilai"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin mewarnai titik-titik dalam bagan gelembung di Excel berdasarkan nilai atau kategori<\/span> <span style=\"color: #000000;\">, mirip dengan plot di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37898\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bcol7.png\" alt=\"Warna Bagan Gelembung Excel berdasarkan Nilai\" width=\"541\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, ini mudah dilakukan di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan dataset berikut yang berisi informasi poin, assist, dan tahun bermain di liga untuk berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37892 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bcol1.png\" alt=\"\" width=\"420\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menggunakan data ini untuk membuat diagram gelembung menggunakan <strong>poin<\/strong> sebagai nilai x, <strong>bantuan<\/strong> sebagai nilai y, dan <strong>tahun<\/strong> sebagai ukuran poin.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Format datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Sebelum kita dapat membuat diagram gelembung, pertama-tama kita perlu memformat data dengan cara tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita akan memasukkan nilai unik untuk setiap nama tim serta nilai y dan z untuk digunakan dalam plot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37893 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bcol2.png\" alt=\"\" width=\"667\" height=\"286\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kemudian ketikkan rumus berikut pada sel <strong>F3<\/strong> dan <strong>G3<\/strong> :<\/span><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>F3<\/strong> : =JIKA($A3=F$1, $C3, NA())<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>G3<\/strong> : =JIKA($A3=F$1, $D3, NA())<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot sel <strong>F3<\/strong> dan <strong>G3<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik dan seret rumus ini ke kanan hingga Anda mencapai sel <strong>K3<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik dan drag rumusnya ke bawah hingga mencapai sel <strong>K11<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37894 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bcol3.png\" alt=\"\" width=\"678\" height=\"298\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Masukkan Bagan Gelembung<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang <strong>B3:B11<\/strong> . Selanjutnya, tahan <strong>Ctrl<\/strong> dan sorot setiap sel dalam rentang <strong>F3:K11<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37895 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bcol4.png\" alt=\"\" width=\"669\" height=\"285\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>Gelembung<\/strong> di grup <strong>Grafik<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37896 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bcol5.png\" alt=\"\" width=\"338\" height=\"335\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bagan gelembung berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37897 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bcol6.png\" alt=\"\" width=\"531\" height=\"336\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Masing-masing pemain dalam kumpulan data ditampilkan dalam bagan gelembung, dengan setiap gelembung diwarnai sesuai dengan nama tim.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Ubah Tampilan Bagan Gelembung (Opsional)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, silakan ubah warna, ukuran titik, dan label untuk membuat plot lebih estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37898\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bcol7.png\" alt=\"Warna Bagan Gelembung Excel berdasarkan Nilai\" width=\"541\" height=\"396\" 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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Gelembung dengan Label di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/\" target=\"_blank\" rel=\"noopener\">Cara Mewarnai Plot Sebar Berdasarkan Nilai di Excel<\/a><br \/><\/span> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/label-plot-sebar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menambahkan Label ke Scatterplot Point di Excel<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin mewarnai titik-titik dalam bagan gelembung di Excel berdasarkan nilai atau kategori , mirip dengan plot di bawah ini: Untungnya, ini mudah dilakukan di Excel. Contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Langkah 1: Masukkan datanya Pertama, masukkan dataset berikut yang berisi informasi poin, assist, dan tahun [&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 Mewarnai Bagan Gelembung Berdasarkan Nilai \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mewarnai titik dalam bagan gelembung berdasarkan nilai di Excel, 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\/warna-bagan-gelembung-excel-berdasarkan-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Mewarnai Bagan Gelembung Berdasarkan Nilai \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mewarnai titik dalam bagan gelembung berdasarkan nilai di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T06:31:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bcol7.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\/warna-bagan-gelembung-excel-berdasarkan-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/\",\"name\":\"Excel: Cara Mewarnai Bagan Gelembung Berdasarkan Nilai \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T06:31:52+00:00\",\"dateModified\":\"2023-07-07T06:31:52+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mewarnai titik dalam bagan gelembung berdasarkan nilai di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mewarnai bagan gelembung berdasarkan nilai\"}]},{\"@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 Mewarnai Bagan Gelembung Berdasarkan Nilai \u2013 Statorial","description":"Tutorial ini menjelaskan cara mewarnai titik dalam bagan gelembung berdasarkan nilai di Excel, 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\/warna-bagan-gelembung-excel-berdasarkan-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Mewarnai Bagan Gelembung Berdasarkan Nilai \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara mewarnai titik dalam bagan gelembung berdasarkan nilai di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-07T06:31:52+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bcol7.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\/warna-bagan-gelembung-excel-berdasarkan-nilai\/","url":"https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/","name":"Excel: Cara Mewarnai Bagan Gelembung Berdasarkan Nilai \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T06:31:52+00:00","dateModified":"2023-07-07T06:31:52+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mewarnai titik dalam bagan gelembung berdasarkan nilai di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/warna-bagan-gelembung-excel-berdasarkan-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mewarnai bagan gelembung berdasarkan nilai"}]},{"@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\/4849"}],"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=4849"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4849\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}