{"id":3703,"date":"2023-07-16T01:13:39","date_gmt":"2023-07-16T01:13:39","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/"},"modified":"2023-07-16T01:13:39","modified_gmt":"2023-07-16T01:13:39","slug":"excel-memplot-beberapa-kumpulan-data","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/","title":{"rendered":"Excel: cara merencanakan beberapa kumpulan data pada bagan yang sama"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin memplot beberapa kumpulan data pada bagan yang sama di Excel, mirip dengan bagan di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30230\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipleexcel6.jpg\" alt=\"Excel memplot beberapa kumpulan data pada bagan yang sama\" width=\"558\" height=\"378\" srcset=\"\" sizes=\"\"><\/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 kumpulan data<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan dua kumpulan data berikut ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30225 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipleexcel1.jpg\" alt=\"\" width=\"457\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Plot kumpulan data pertama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Untuk membuat plot sebar untuk Tim A, sorot rentang sel <strong>A2:B12<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu klik opsi <strong>Sebar<\/strong> di grup <strong>Bagan<\/strong> :<\/span><\/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=\"520\" height=\"214\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Cloud titik berikut akan dibuat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30226 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipleexcel2.jpg\" alt=\"\" width=\"520\" height=\"346\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan Kumpulan Data Kedua<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan di mana saja pada titik cloud. Lalu klik <strong>Pilih Data<\/strong> dari menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30227 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipleexcel3.jpg\" alt=\"\" width=\"551\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Tambah<\/strong> di bawah kotak <strong>Entri Keterangan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian ketik \u201cTim B\u201d untuk nama serinya, lalu pilih <strong>D3:D12<\/strong> untuk nilai seri X dan <strong>E3:E12<\/strong> untuk nilai seri Y:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30228 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipleexcel4.jpg\" alt=\"\" width=\"511\" height=\"509\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , nilai dari kumpulan data kedua akan secara otomatis ditambahkan ke diagram sebar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30229 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipleexcel5.jpg\" alt=\"\" width=\"495\" height=\"359\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Sesuaikan bagan (opsional)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, silakan ubah warnanya, tambahkan judul bagan, tambahkan judul sumbu, dan tambahkan legenda agar bagan lebih mudah diinterpretasikan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30230\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipleexcel6.jpg\" alt=\"Excel memplot beberapa kumpulan data pada bagan yang sama\" width=\"558\" height=\"378\" 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 tugas 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\/diagram-batang-bertumpuk-berkerumun-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Batang Bertumpuk Berkelompok di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Scatter Plot dengan Beberapa Seri di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin memplot beberapa kumpulan data pada bagan yang sama di Excel, mirip dengan bagan di bawah ini: Contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Langkah 1: Masukkan kumpulan data Mari kita mulai dengan memasukkan dua kumpulan data berikut ke dalam Excel: Langkah 2: Plot kumpulan data pertama [&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 memplot beberapa kumpulan data pada bagan yang sama - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memplot beberapa kumpulan data pada bagan yang sama 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\/excel-memplot-beberapa-kumpulan-data\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara memplot beberapa kumpulan data pada bagan yang sama - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memplot beberapa kumpulan data pada bagan yang sama di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T01:13:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipleexcel6.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\/excel-memplot-beberapa-kumpulan-data\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/\",\"name\":\"Excel: Cara memplot beberapa kumpulan data pada bagan yang sama - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T01:13:39+00:00\",\"dateModified\":\"2023-07-16T01:13:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memplot beberapa kumpulan data pada bagan yang sama di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara merencanakan beberapa kumpulan data pada bagan yang sama\"}]},{\"@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 memplot beberapa kumpulan data pada bagan yang sama - Statorial","description":"Tutorial ini menjelaskan cara memplot beberapa kumpulan data pada bagan yang sama 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\/excel-memplot-beberapa-kumpulan-data\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara memplot beberapa kumpulan data pada bagan yang sama - Statorial","og_description":"Tutorial ini menjelaskan cara memplot beberapa kumpulan data pada bagan yang sama di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/","og_site_name":"Statorials","article_published_time":"2023-07-16T01:13:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipleexcel6.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\/excel-memplot-beberapa-kumpulan-data\/","url":"https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/","name":"Excel: Cara memplot beberapa kumpulan data pada bagan yang sama - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T01:13:39+00:00","dateModified":"2023-07-16T01:13:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memplot beberapa kumpulan data pada bagan yang sama di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-memplot-beberapa-kumpulan-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara merencanakan beberapa kumpulan data pada bagan yang sama"}]},{"@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\/3703"}],"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=3703"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3703\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}