{"id":3731,"date":"2023-07-15T21:20:56","date_gmt":"2023-07-15T21:20:56","guid":{"rendered":"https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/"},"modified":"2023-07-15T21:20:56","modified_gmt":"2023-07-15T21:20:56","slug":"data-bagan-google-sheet-dari-beberapa-lembar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/","title":{"rendered":"Google spreadsheet: cara membuat grafik data dari beberapa lembar"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Anda dapat dengan mudah membuat grafik data dari beberapa lembar di Google Spreadsheet hanya dengan menambahkan beberapa rentang <strong>rangkaian<\/strong> di panel <strong>Editor Bagan<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan kumpulan data berikut ke dalam <strong>Lembar 1<\/strong> yang menunjukkan penjualan berbagai produk di toko A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30408 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique1.jpg\" alt=\"\" width=\"598\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan memasukkan kumpulan data berikut ke dalam <strong>Sheet2<\/strong> yang menunjukkan penjualan produk yang sama di toko B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30409 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique2.jpg\" alt=\"\" width=\"583\" height=\"453\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Bagan Awal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menyorot rentang <strong>A2:B7<\/strong> di <strong>Sheet1<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30410 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique3.jpg\" alt=\"\" width=\"536\" height=\"482\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>editor grafik<\/strong> yang muncul, kita akan memilih <strong>Histogram<\/strong> sebagai <strong>tipe grafik<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30411 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique4.jpg\" alt=\"\" width=\"335\" height=\"496\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan menghasilkan grafik berikut yang menunjukkan penjualan setiap produk di <strong>Sheet1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30412 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique5.jpg\" alt=\"\" width=\"546\" height=\"353\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan Data dari Lembar Kedua ke Bagan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Untuk menambahkan data penjualan <strong>Sheet2<\/strong> ke bagan, klik <strong>Tambahkan Seri<\/strong> pada tab <strong>Penyetelan<\/strong> di panel <strong>Editor Bagan<\/strong> , lalu klik ikon kisi kecil:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30413 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique6.jpg\" alt=\"\" width=\"322\" height=\"693\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, ketik <strong>Sheet2!B1:B7<\/strong> untuk rentang data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30414 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique7.jpg\" alt=\"\" width=\"438\" height=\"261\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , data penjualan dari <strong>Sheet2<\/strong> akan ditambahkan ke grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30415\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique8.jpg\" alt=\"Data grafik Google Spreadsheet dari beberapa lembar\" width=\"616\" height=\"381\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bilah biru mewakili penjualan setiap produk dari toko A dan bilah merah mewakili penjualan setiap produk dari toko B.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #1<\/strong> : Contoh ini mengasumsikan bahwa data disusun dengan cara yang sama pada setiap lembar.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #2<\/strong> : Dalam contoh ini, kami membuat bagan menggunakan data dari dua lembar. Namun, Anda dapat menambahkan rentang <strong>rangkaian<\/strong> di panel <strong>editor bagan<\/strong> sebanyak yang Anda inginkan untuk membuat bagan menggunakan lebih banyak lembar.<\/span><\/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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/garis-rata-rata-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis rata-rata ke grafik di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-tren-google\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis tren ke grafik di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memplot-beberapa-baris\/\" target=\"_blank\" rel=\"noopener\">Cara memplot banyak baris di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat dengan mudah membuat grafik data dari beberapa lembar di Google Spreadsheet hanya dengan menambahkan beberapa rentang rangkaian di panel Editor Bagan . Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Masukkan datanya Pertama, masukkan kumpulan data berikut ke dalam Lembar 1 yang menunjukkan penjualan berbagai produk di toko A: [&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: Cara Merencanakan Data dari Beberapa Lembar - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat grafik data dari beberapa sheet di Google Sheets, 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\/data-bagan-google-sheet-dari-beberapa-lembar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara Merencanakan Data dari Beberapa Lembar - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat grafik data dari beberapa sheet di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T21:20:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique1.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\/data-bagan-google-sheet-dari-beberapa-lembar\/\",\"url\":\"https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/\",\"name\":\"Google Spreadsheet: Cara Merencanakan Data dari Beberapa Lembar - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T21:20:56+00:00\",\"dateModified\":\"2023-07-15T21:20:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat grafik data dari beberapa sheet di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara membuat grafik data dari beberapa lembar\"}]},{\"@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: Cara Merencanakan Data dari Beberapa Lembar - Statologi","description":"Tutorial ini menjelaskan cara membuat grafik data dari beberapa sheet di Google Sheets, 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\/data-bagan-google-sheet-dari-beberapa-lembar\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara Merencanakan Data dari Beberapa Lembar - Statologi","og_description":"Tutorial ini menjelaskan cara membuat grafik data dari beberapa sheet di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/","og_site_name":"Statorials","article_published_time":"2023-07-15T21:20:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique1.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\/data-bagan-google-sheet-dari-beberapa-lembar\/","url":"https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/","name":"Google Spreadsheet: Cara Merencanakan Data dari Beberapa Lembar - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T21:20:56+00:00","dateModified":"2023-07-15T21:20:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat grafik data dari beberapa sheet di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/data-bagan-google-sheet-dari-beberapa-lembar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara membuat grafik data dari beberapa lembar"}]},{"@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\/3731"}],"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=3731"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3731\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3731"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}