{"id":4682,"date":"2023-07-09T00:23:03","date_gmt":"2023-07-09T00:23:03","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/"},"modified":"2023-07-09T00:23:03","modified_gmt":"2023-07-09T00:23:03","slug":"excel-plot-x-vs-y","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/","title":{"rendered":"Cara membuat plot x dan y di excel (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Seringkali Anda mungkin ingin membuat plot titik data X dan Y di Excel.<\/span><\/p>\n

Untungnya, hal ini mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya.<\/span><\/p>\n

Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n

Pertama, mari masukkan kumpulan data berikut ke dalam Excel:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Buat titik cloud<\/strong><\/span><\/h2>\n

Selanjutnya kita akan membuat scatterplot untuk memvisualisasikan nilai dari dataset.<\/span><\/p>\n

Untuk melakukannya, sorot sel dalam rentang A2:B14<\/strong> , lalu klik tab Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon Sebar<\/strong> di grup Bagan<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Point cloud berikut akan otomatis dibuat:<\/span> <\/p>\n

\"\"<\/p>\n

Sumbu x menampilkan nilai x dan sumbu y menampilkan nilai y dari kumpulan data.<\/span><\/p>\n

Catatan<\/strong> : Jika ingin titik plotnya terhubung, silakan klik ikon berlabel Sebar dengan Garis Halus dan Penanda<\/strong> di grup Grafik<\/strong> .<\/span><\/p>\n

Langkah 3: Edit Jalur (Opsional)<\/strong><\/span><\/h2>\n

Kemudian kita bisa melakukan beberapa perubahan pada plotnya agar lebih mudah dibaca.<\/span><\/p>\n

Pertama, klik dua kali pada salah satu titik pada plot.<\/span><\/p>\n

Pada panel Format Data Series<\/strong> yang muncul di sisi kanan layar, klik ikon Marker<\/strong> , lalu klik Marker Options<\/strong> , lalu klik Built-in<\/strong> dan ubah Ukurannya<\/strong> menjadi 7:<\/span> <\/p>\n

\"\"<\/p>\n

Hal ini akan meningkatkan ukuran titik-titik dalam plot.<\/span><\/p>\n

Selanjutnya, klik di mana saja pada jalur tersebut. Kemudian klik tanda plus kecil berwarna hijau yang muncul di sudut kanan atas plot, lalu centang Judul Sumbu<\/strong> dari menu drop-down:<\/span> <\/p>\n

\"\"<\/p>\n

Selanjutnya, klik judul sumbu dan judul bagan satu per satu dan edit judulnya:<\/span> <\/p>\n

\"Bagan<\/p>\n

Hasil akhirnya adalah plot nilai x versus nilai y dari dataset asli yang mudah dibaca dan estetis.<\/span><\/p>\n

Sumber daya tambahan<\/span><\/strong><\/h2>\n

Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n

Cara Menambahkan Label ke Scatterplot Point di Excel<\/a>
Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel<\/a>
Bagaimana cara menambahkan garis regresi ke scatterplot di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Seringkali Anda mungkin ingin membuat plot titik data X dan Y di Excel. Untungnya, hal ini mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya. Langkah 1: Masukkan datanya Pertama, mari masukkan kumpulan data berikut ke dalam Excel: Langkah 2: Buat titik cloud Selanjutnya kita akan membuat scatterplot untuk memvisualisasikan nilai dari dataset. […]<\/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":"\nCara Membuat Plot X dan Y di Excel (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memplot titik data x dan y di Excel pada bagan, termasuk 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\/excel-plot-x-vs-y\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Plot X dan Y di Excel (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memplot titik data x dan y di Excel pada bagan, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T00:23:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/connecter3.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-plot-x-vs-y\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/\",\"name\":\"Cara Membuat Plot X dan Y di Excel (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T00:23:03+00:00\",\"dateModified\":\"2023-07-09T00:23:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memplot titik data x dan y di Excel pada bagan, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot x dan y di excel (dengan contoh)\"}]},{\"@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":"Cara Membuat Plot X dan Y di Excel (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara memplot titik data x dan y di Excel pada bagan, termasuk 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\/excel-plot-x-vs-y\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot X dan Y di Excel (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara memplot titik data x dan y di Excel pada bagan, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/","og_site_name":"Statorials","article_published_time":"2023-07-09T00:23:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/connecter3.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-plot-x-vs-y\/","url":"https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/","name":"Cara Membuat Plot X dan Y di Excel (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T00:23:03+00:00","dateModified":"2023-07-09T00:23:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memplot titik data x dan y di Excel pada bagan, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-plot-x-vs-y\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot x dan y di excel (dengan contoh)"}]},{"@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\/4682"}],"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=4682"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4682\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}