{"id":2811,"date":"2023-07-20T14:32:04","date_gmt":"2023-07-20T14:32:04","guid":{"rendered":"https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/"},"modified":"2023-07-20T14:32:04","modified_gmt":"2023-07-20T14:32:04","slug":"plot-sebar-lembar-google-dengan-garis","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/","title":{"rendered":"Cara membuat plot sebar dengan garis di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat diagram sebar di Google Spreadsheet dengan masing-masing titik pada plot dihubungkan dengan garis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sayangnya, Google Spreadsheet tidak menawarkan bagan bawaan jenis ini, namun Anda dapat membuatnya menggunakan bagan garis sebagai solusinya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah cara membuat diagram sebar berikut dengan garis di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24691 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-de-dispersion7.jpg\" alt=\"\" width=\"573\" height=\"355\" srcset=\"\" sizes=\"\"><\/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 yang berisi nilai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24685 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-de-dispersion1.jpg\" alt=\"\" width=\"480\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Bagan Garis<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot nilai dalam rentang <strong>A1:11<\/strong> , lalu klik <strong>Sisipkan<\/strong> , lalu klik <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24686 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-de-dispersion2.jpg\" alt=\"\" width=\"475\" height=\"518\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Cloud titik berikut akan dimasukkan secara default:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24687 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-de-dispersion3.jpg\" alt=\"\" width=\"552\" height=\"361\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengubahnya menjadi diagram garis, cukup klik <strong>Tipe Bagan<\/strong> di editor bagan yang muncul di sebelah kanan layar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian gulir ke bawah dan klik <strong>Bagan Garis<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24688 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-de-dispersion4.jpg\" alt=\"\" width=\"344\" height=\"479\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini secara otomatis akan menghasilkan grafik garis berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24689 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-de-dispersion5.jpg\" alt=\"\" width=\"555\" height=\"355\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan titik ke grafik garis<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk menambahkan poin ke diagram garis, klik tab <strong>Kustomisasi<\/strong> di panel Editor Bagan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik panah drop-down di sebelah <strong>Seri<\/strong> dan pilih <strong>10px<\/strong> sebagai <strong>ukuran titik<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24690 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-de-dispersion6.jpg\" alt=\"\" width=\"310\" height=\"577\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Poin akan secara otomatis ditambahkan ke grafik garis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24691 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-de-dispersion7.jpg\" alt=\"\" width=\"573\" height=\"355\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Grafiknya sekarang terlihat seperti plot sebar dengan setiap titik pada plot dihubungkan oleh sebuah garis.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Silakan bermain-main dengan opsi <strong>Format<\/strong> di panel Editor Bagan untuk mengubah warna dan ukuran titik dan garis bagan.<\/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 membuat visualisasi umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Kotak di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Pareto di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-area-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Area di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membuat diagram sebar di Google Spreadsheet dengan masing-masing titik pada plot dihubungkan dengan garis. Sayangnya, Google Spreadsheet tidak menawarkan bagan bawaan jenis ini, namun Anda dapat membuatnya menggunakan bagan garis sebagai solusinya. Tutorial ini memberikan contoh langkah demi langkah cara membuat diagram sebar berikut dengan garis di Google Spreadsheet: Langkah 1: [&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>Cara Membuat Plot Sebar dengan Garis di Google Sheets \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat scatterplot dengan garis di Google Sheets, beserta contoh lengkapnya.\" \/>\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\/plot-sebar-lembar-google-dengan-garis\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Plot Sebar dengan Garis di Google Sheets \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat scatterplot dengan garis di Google Sheets, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T14:32:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-de-dispersion7.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\/plot-sebar-lembar-google-dengan-garis\/\",\"url\":\"https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/\",\"name\":\"Cara Membuat Plot Sebar dengan Garis di Google Sheets \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T14:32:04+00:00\",\"dateModified\":\"2023-07-20T14:32:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat scatterplot dengan garis di Google Sheets, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot sebar dengan garis di google sheets\"}]},{\"@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 Sebar dengan Garis di Google Sheets \u2013 Statorial","description":"Tutorial ini menjelaskan cara membuat scatterplot dengan garis di Google Sheets, beserta contoh lengkapnya.","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\/plot-sebar-lembar-google-dengan-garis\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot Sebar dengan Garis di Google Sheets \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara membuat scatterplot dengan garis di Google Sheets, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/","og_site_name":"Statorials","article_published_time":"2023-07-20T14:32:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-de-dispersion7.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\/plot-sebar-lembar-google-dengan-garis\/","url":"https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/","name":"Cara Membuat Plot Sebar dengan Garis di Google Sheets \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T14:32:04+00:00","dateModified":"2023-07-20T14:32:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat scatterplot dengan garis di Google Sheets, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/plot-sebar-lembar-google-dengan-garis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot sebar dengan garis di google sheets"}]},{"@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\/2811"}],"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=2811"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2811\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}