{"id":2309,"date":"2023-07-22T20:14:10","date_gmt":"2023-07-22T20:14:10","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/"},"modified":"2023-07-22T20:14:10","modified_gmt":"2023-07-22T20:14:10","slug":"google-sheet-memetakan-beberapa-rentang-data","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/","title":{"rendered":"Google spreadsheet: buat bagan dengan beberapa rentang data"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda sering kali ingin membuat bagan di Google Spreadsheet yang menggunakan beberapa rentang data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan beberapa data dalam format berikut yang menunjukkan total penjualan tiga perusahaan berbeda selama 10 periode penjualan berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20990 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiple11.png\" alt=\"\" width=\"594\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat bagan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk membuat diagram garis dengan banyak garis, pertama-tama kita dapat menyorot semua sel dalam rentang <strong>A1:D11<\/strong> , lalu klik <strong>Sisipkan<\/strong> lalu klik <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20991 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiple12.png\" alt=\"\" width=\"498\" height=\"526\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara default, Google Charts akan menyisipkan diagram garis dengan beberapa baris:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20992 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiple13.png\" alt=\"\" width=\"614\" height=\"383\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap baris mewakili penjualan masing-masing dari tiga perusahaan selama 10 periode penjualan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan grafik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk menyesuaikan tampilan grafik, klik di mana saja pada grafik lalu klik tiga titik vertikal di pojok kanan atas, lalu klik <strong>Edit Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20993 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiple14.png\" alt=\"\" width=\"603\" height=\"384\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Chart Editor<\/strong> yang muncul di sisi kanan layar, klik tab <strong>Customize<\/strong> , lalu klik <strong>Chart and Axis Titles<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian ketikkan judul pilihan Anda pada kotak berlabel <strong>Judul Teks<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20994 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiple15.png\" alt=\"\" width=\"343\" height=\"610\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik <strong>Seri<\/strong> dan silakan ubah warna, jenis garis, dan ketebalan setiap garis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-20995 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiple16.png\" alt=\"\" width=\"341\" height=\"637\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik <strong>Legenda<\/strong> dan ubah <strong>posisinya<\/strong> ke mana pun Anda inginkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20996 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiple17.png\" alt=\"\" width=\"340\" height=\"626\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Inilah tampilan tabel akhir kami:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-20997\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiple18.png\" alt=\"Bagan Google Spreadsheet dengan beberapa rentang data\" width=\"626\" height=\"388\" srcset=\"\" sizes=\"\"><\/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\/diagram-lingkaran-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Diagram Lingkaran di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Gelembung di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Pareto di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda sering kali ingin membuat bagan di Google Spreadsheet yang menggunakan beberapa rentang data. Untungnya, hal ini mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya. Langkah 1: Masukkan datanya Pertama, masukkan beberapa data dalam format berikut yang menunjukkan total penjualan tiga perusahaan berbeda selama 10 periode penjualan berturut-turut: Langkah 2: Buat bagan [&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>Google Spreadsheet: Membuat bagan dengan beberapa rentang data \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat grafik di Google Sheets menggunakan beberapa rentang data, termasuk 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\/google-sheet-memetakan-beberapa-rentang-data\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Membuat bagan dengan beberapa rentang data \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat grafik di Google Sheets menggunakan beberapa rentang data, termasuk sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T20:14:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiple11.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\/google-sheet-memetakan-beberapa-rentang-data\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/\",\"name\":\"Google Spreadsheet: Membuat bagan dengan beberapa rentang data \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T20:14:10+00:00\",\"dateModified\":\"2023-07-22T20:14:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat grafik di Google Sheets menggunakan beberapa rentang data, termasuk sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: buat bagan dengan beberapa rentang data\"}]},{\"@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":"Google Spreadsheet: Membuat bagan dengan beberapa rentang data \u2013 Statorial","description":"Tutorial ini menjelaskan cara membuat grafik di Google Sheets menggunakan beberapa rentang data, termasuk 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\/google-sheet-memetakan-beberapa-rentang-data\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Membuat bagan dengan beberapa rentang data \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara membuat grafik di Google Sheets menggunakan beberapa rentang data, termasuk sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/","og_site_name":"Statorials","article_published_time":"2023-07-22T20:14:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiple11.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\/google-sheet-memetakan-beberapa-rentang-data\/","url":"https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/","name":"Google Spreadsheet: Membuat bagan dengan beberapa rentang data \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T20:14:10+00:00","dateModified":"2023-07-22T20:14:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat grafik di Google Sheets menggunakan beberapa rentang data, termasuk sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-memetakan-beberapa-rentang-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: buat bagan dengan beberapa rentang data"}]},{"@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\/2309"}],"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=2309"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2309\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}