{"id":2317,"date":"2023-07-22T19:24:01","date_gmt":"2023-07-22T19:24:01","guid":{"rendered":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/"},"modified":"2023-07-22T19:24:01","modified_gmt":"2023-07-22T19:24:01","slug":"diagram-batang-bertumpuk-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/","title":{"rendered":"Cara membuat diagram batang bertumpuk di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Diagram batang bertumpuk<\/strong> adalah jenis diagram yang menggunakan batang yang dibagi menjadi beberapa subbar untuk memvisualisasikan nilai beberapa variabel sekaligus.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-21073\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile6.png\" alt=\"diagram batang bertumpuk di Google Spreadsheet\" width=\"533\" height=\"332\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara membuat diagram batang bertumpuk di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan data<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita mengirimkan survei dan meminta 100 pria dan 100 wanita untuk memilih olahraga favorit mereka antara baseball, sepak bola, sepak bola, dan bola basket.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa memasukkan hasil surveynya terlebih dahulu dengan format sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21068 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile1.png\" alt=\"\" width=\"478\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Bagan Batang Bertumpuk<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk membuat diagram batang bertumpuk guna memvisualisasikan data ini, kita dapat menyorot sel dalam rentang <strong>A1:C5<\/strong> , lalu klik <strong>Sisipkan<\/strong> , lalu <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21069 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile2.png\" alt=\"\" width=\"406\" height=\"482\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Diagram batang yang dikelompokkan akan muncul secara otomatis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengubahnya menjadi diagram batang bertumpuk, klik di mana saja pada diagram, lalu klik tiga titik vertikal di sudut kanan atas, lalu klik <strong>Edit<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21070 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile3.png\" alt=\"\" width=\"510\" height=\"321\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Chart Editor<\/strong> yang muncul di sisi kanan layar, klik menu drop-down <strong>Stacking<\/strong> , lalu klik <strong>Standard<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21071 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile4.png\" alt=\"\" width=\"334\" height=\"480\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bagan akan secara otomatis dikonversi menjadi bagan batang bertumpuk:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21072 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile5.png\" alt=\"\" width=\"532\" height=\"331\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x menunjukkan olahraga dan sumbu y menunjukkan berapa banyak pria dan wanita yang memilih setiap olahraga sebagai favoritnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda ingin setiap batang berjumlah 100%, klik opsi yang bertuliskan <strong>100%<\/strong> di menu tarik-turun <strong>Penumpukan<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Edit Bagan Batang Bertumpuk<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Silakan klik setiap elemen bagan untuk mengubah tampilannya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda dapat mengubah judul, warna bilah, dan lokasi legenda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21073 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile6.png\" alt=\"\" width=\"533\" height=\"332\" 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\/bilah-kesalahan-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan bilah kesalahan ke bagan di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Diagram batang bertumpuk adalah jenis diagram yang menggunakan batang yang dibagi menjadi beberapa subbar untuk memvisualisasikan nilai beberapa variabel sekaligus. Contoh langkah demi langkah berikut menunjukkan cara membuat diagram batang bertumpuk di Google Spreadsheet. Langkah 1: Masukkan data Katakanlah kita mengirimkan survei dan meminta 100 pria dan 100 wanita untuk memilih olahraga favorit mereka antara [&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 Diagram Batang Bertumpuk di Google Spreadsheet \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk di Google Spreadsheet, dengan 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\/diagram-batang-bertumpuk-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Diagram Batang Bertumpuk di Google Spreadsheet \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T19:24:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile6.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\/diagram-batang-bertumpuk-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/\",\"name\":\"Cara Membuat Diagram Batang Bertumpuk di Google Spreadsheet \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T19:24:01+00:00\",\"dateModified\":\"2023-07-22T19:24:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat diagram batang bertumpuk di google spreadsheet\"}]},{\"@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 Diagram Batang Bertumpuk di Google Spreadsheet \u2013 Statorial","description":"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk di Google Spreadsheet, dengan 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\/diagram-batang-bertumpuk-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Diagram Batang Bertumpuk di Google Spreadsheet \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-22T19:24:01+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile6.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\/diagram-batang-bertumpuk-lembar-google\/","url":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/","name":"Cara Membuat Diagram Batang Bertumpuk di Google Spreadsheet \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T19:24:01+00:00","dateModified":"2023-07-22T19:24:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat diagram batang bertumpuk di google spreadsheet"}]},{"@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\/2317"}],"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=2317"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2317\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}