{"id":1544,"date":"2023-07-25T23:03:34","date_gmt":"2023-07-25T23:03:34","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/"},"modified":"2023-07-25T23:03:34","modified_gmt":"2023-07-25T23:03:34","slug":"excel-sebar-garis-horizontal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/","title":{"rendered":"Bagaimana cara menambahkan garis horizontal ke scatterplot di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Terkadang Anda mungkin ingin menambahkan garis horizontal ke plot sebar di Excel untuk mewakili ambang batas atau batas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara menambahkan garis horizontal dengan cepat ke diagram sebar apa pun di Excel.<\/span><\/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 berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15316 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontalexcel1.png\" alt=\"\" width=\"367\" height=\"422\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat titik cloud<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot data pada cell range <strong>A2:B17<\/strong> seperti berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15317 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontalexcel2.png\" alt=\"\" width=\"378\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di pita atas, klik <strong>Sisipkan<\/strong> , lalu klik bagan pertama di grup <strong>Sisipkan Bagan Sebar (X, Y) atau Bagan Gelembung<\/strong> di grup <strong>Bagan<\/strong> . Secara otomatis akan muncul point cloud berikut ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15318 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontalexcel3.png\" alt=\"\" width=\"537\" height=\"359\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan Garis Horizontal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin menambahkan garis horizontal di <strong>y = 20<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita dapat membuat rangkaian data palsu yang menunjukkan nilai minimum dan maksimum sepanjang sumbu x (0 dan 20) serta dua nilai y, keduanya sama dengan 20:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15319 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontalexcel4.png\" alt=\"\" width=\"557\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan di mana saja pada grafik dan klik <strong>Pilih Data<\/strong> . Di jendela yang muncul, klik <strong>Tambah<\/strong> di bawah bagian <strong>Entri Legenda (Seri)<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, berikan informasi berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15321 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontalexcel5.png\" alt=\"\" width=\"451\" height=\"467\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , dua titik oranye akan muncul pada grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15322 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontalexcel6.png\" alt=\"\" width=\"460\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Klik kanan pada salah satu titik oranye dan klik <strong>Format Seri Data\u2026<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul di sebelah kanan layar, klik <strong>Garis padat<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15298 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel10.png\" alt=\"\" width=\"283\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan mengubah dua titik oranye menjadi garis oranye solid:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15323\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontalexcel7.png\" alt=\"Tambahkan garis horizontal ke scatterplot di Excel\" width=\"508\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk memodifikasi warna, ketebalan dan gaya garis agar lebih estetis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin menambahkan beberapa garis horizontal ke satu bagan, cukup ulangi proses ini menggunakan nilai y yang berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/excel-menambahkan-garis-rata-rata-ke-diagram-batang\/\">Cara Menambahkan Garis Rata-Rata ke Diagram Batang di Excel<\/a><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/penyesuaian-kurva-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menyesuaikan kurva di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Poligon Frekuensi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Bland-Altman di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Terkadang Anda mungkin ingin menambahkan garis horizontal ke plot sebar di Excel untuk mewakili ambang batas atau batas. Tutorial ini memberikan contoh langkah demi langkah tentang cara menambahkan garis horizontal dengan cepat ke diagram sebar apa pun di Excel. Langkah 1: Buat datanya Pertama, mari buat kumpulan data palsu berikut: Langkah 2: Buat titik cloud [&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>Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan garis horizontal dan vertikal ke grafik di Excel, dengan beberapa 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-sebar-garis-horizontal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan garis horizontal dan vertikal ke grafik di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T23:03:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontalexcel1.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\/excel-sebar-garis-horizontal\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/\",\"name\":\"Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T23:03:34+00:00\",\"dateModified\":\"2023-07-25T23:03:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan garis horizontal dan vertikal ke grafik di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan garis horizontal ke scatterplot di excel\"}]},{\"@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":"Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel","description":"Tutorial ini menjelaskan cara menambahkan garis horizontal dan vertikal ke grafik di Excel, dengan beberapa 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-sebar-garis-horizontal\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel","og_description":"Tutorial ini menjelaskan cara menambahkan garis horizontal dan vertikal ke grafik di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/","og_site_name":"Statorials","article_published_time":"2023-07-25T23:03:34+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontalexcel1.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\/excel-sebar-garis-horizontal\/","url":"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/","name":"Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T23:03:34+00:00","dateModified":"2023-07-25T23:03:34+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan garis horizontal dan vertikal ke grafik di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan garis horizontal ke scatterplot di excel"}]},{"@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\/1544"}],"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=1544"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1544\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1544"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1544"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}