{"id":4848,"date":"2023-07-07T06:41:05","date_gmt":"2023-07-07T06:41:05","guid":{"rendered":"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/"},"modified":"2023-07-07T06:41:05","modified_gmt":"2023-07-07T06:41:05","slug":"warna-excel-berdasarkan-plot-sebar-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/","title":{"rendered":"Excel: cara mewarnai plot sebar berdasarkan nilai"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin mewarnai titik-titik dalam plot sebar di Excel berdasarkan nilai atau kategori<\/span> <span style=\"color: #000000;\">, mirip dengan bagan di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37887\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/colcat5-1.png\" alt=\"Warna sebar Excel berdasarkan nilai\" width=\"522\" height=\"375\" 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 nilai berikut (X, Y) untuk tiga kategori berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37881 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/colcat1.png\" alt=\"\" width=\"465\" height=\"392\" srcset=\"\" sizes=\"\"><\/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 plot sebar untuk memvisualisasikan koordinat (X,Y) setiap grup, 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 kategori di sepanjang baris atas, lalu masukkan rumus berikut di sel <strong>D2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF( <span style=\"color: #3366ff;\">$C2<\/span> = <span style=\"color: #ff0000;\">D$1<\/span> , <span style=\"color: #800080;\">$B2<\/span> , NA())\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret rumus ini ke kanan sel <strong>F2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeretnya ke bawah hingga mencapai sel <strong>F9<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37882 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/colcat2.png\" alt=\"\" width=\"535\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Masukkan titik cloud<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang <strong>A2:A9<\/strong> . Selanjutnya, tahan <strong>Ctrl<\/strong> dan sorot setiap sel dalam rentang <strong>D2:F9<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37883 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/colcat3.png\" alt=\"\" width=\"496\" height=\"329\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, dan klik <strong>Sisipkan Sebar (X, Y)<\/strong> di grup <strong>Grafik<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16294 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/disperserexcel.png\" alt=\"\" width=\"547\" height=\"225\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul plot sebar berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37884 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/colcat4.png\" alt=\"\" width=\"554\" height=\"343\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Masing-masing koordinat (X, Y) dari dataset ditampilkan pada titik cloud dan setiap titik diberi warna sesuai dengan kategorinya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Ubah Tampilan Sebar (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=\" wp-image-37887 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/colcat5-1.png\" alt=\"\" width=\"522\" height=\"375\" 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 menjalankan fungsi umum lainnya dengan plot sebar di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis regresi ke scatterplot di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/label-plot-sebar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menambahkan Label ke Scatterplot Point di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin mewarnai titik-titik dalam plot sebar di Excel berdasarkan nilai atau kategori , mirip dengan bagan 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 nilai berikut (X, Y) untuk tiga kategori berbeda: Langkah [&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 plot sebar berdasarkan nilai \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mewarnai titik pada scatterplot di Excel berdasarkan nilai, beserta 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-excel-berdasarkan-plot-sebar-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 plot sebar berdasarkan nilai \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mewarnai titik pada scatterplot di Excel berdasarkan nilai, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T06:41:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/colcat5-1.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-excel-berdasarkan-plot-sebar-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/\",\"name\":\"Excel: Cara mewarnai plot sebar berdasarkan nilai \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T06:41:05+00:00\",\"dateModified\":\"2023-07-07T06:41:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mewarnai titik pada scatterplot di Excel berdasarkan nilai, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mewarnai plot sebar 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 plot sebar berdasarkan nilai \u2013 Statologi","description":"Tutorial ini menjelaskan cara mewarnai titik pada scatterplot di Excel berdasarkan nilai, beserta 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-excel-berdasarkan-plot-sebar-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mewarnai plot sebar berdasarkan nilai \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara mewarnai titik pada scatterplot di Excel berdasarkan nilai, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-07T06:41:05+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/colcat5-1.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-excel-berdasarkan-plot-sebar-nilai\/","url":"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/","name":"Excel: Cara mewarnai plot sebar berdasarkan nilai \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T06:41:05+00:00","dateModified":"2023-07-07T06:41:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mewarnai titik pada scatterplot di Excel berdasarkan nilai, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/warna-excel-berdasarkan-plot-sebar-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mewarnai plot sebar 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\/4848"}],"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=4848"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4848\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}