{"id":4835,"date":"2023-07-07T10:23:53","date_gmt":"2023-07-07T10:23:53","guid":{"rendered":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/"},"modified":"2023-07-07T10:23:53","modified_gmt":"2023-07-07T10:23:53","slug":"diagram-batang-bertumpuk-excel-dengan-subkategori","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/","title":{"rendered":"Excel: buat bagan batang bertumpuk dengan subkategori"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin membuat diagram batang bertumpuk di Excel dengan subkategori.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat diagram batang bertumpuk berikut dengan subkategori:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37758 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbart7.png\" alt=\"\" width=\"530\" height=\"364\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data berikut yang menunjukkan total penjualan empat produk berbeda di tiga lokasi berbeda untuk sebuah toko:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37751 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbart1.png\" alt=\"\" width=\"507\" height=\"359\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Masukkan Bagan Batang Bertumpuk<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Berikutnya, sorot rentang sel <strong>A1:E4<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon berlabel <strong>Batang Bertumpuk<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37752 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/empile_horizontal.png\" alt=\"\" width=\"487\" height=\"360\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Diagram batang bertumpuk berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37753 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbart2.png\" alt=\"\" width=\"502\" height=\"324\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Ubah Baris dan Kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan di mana saja pada grafik dan klik <strong>Pilih Data<\/strong> dari menu drop-down:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37754 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbart3.png\" alt=\"\" width=\"490\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Di jendela baru yang muncul, klik tombol bernama <strong>Ubah baris\/kolom<\/strong> dan klik <strong>OK<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37756 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbart5.png\" alt=\"\" width=\"571\" height=\"330\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tirai sekarang akan ditampilkan di sepanjang sumbu Y dan masing-masing produk akan ditampilkan sebagai subkategori di bilah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37757 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbart6.png\" alt=\"\" width=\"540\" height=\"354\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Sesuaikan bagan (opsional)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menambahkan judul, menyesuaikan warna, dan menyesuaikan lebar bilah untuk membuat plot lebih estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37758 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbart7.png\" alt=\"\" width=\"530\" height=\"364\" srcset=\"\" sizes=\"\"><\/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 Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/\" target=\"_blank\" rel=\"noopener\">Cara Menampilkan Persentase dalam Bagan Kolom Bertumpuk di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Batang Bertumpuk Berkelompok di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/total-diagram-batang-bertumpuk-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menambahkan nilai total ke diagram batang bertumpuk di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin membuat diagram batang bertumpuk di Excel dengan subkategori. Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat diagram batang bertumpuk berikut dengan subkategori: Ayo pergi! Langkah 1: Masukkan datanya Pertama, mari buat kumpulan data berikut yang menunjukkan total penjualan empat produk berbeda di tiga lokasi berbeda untuk sebuah toko: Langkah [&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>Excel: Membuat Bagan Batang Bertumpuk dengan Subkategori - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk dengan subkategori di Excel, beserta 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\/diagram-batang-bertumpuk-excel-dengan-subkategori\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Membuat Bagan Batang Bertumpuk dengan Subkategori - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk dengan subkategori di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T10:23:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbart7.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-excel-dengan-subkategori\/\",\"url\":\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/\",\"name\":\"Excel: Membuat Bagan Batang Bertumpuk dengan Subkategori - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T10:23:53+00:00\",\"dateModified\":\"2023-07-07T10:23:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk dengan subkategori di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: buat bagan batang bertumpuk dengan subkategori\"}]},{\"@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":"Excel: Membuat Bagan Batang Bertumpuk dengan Subkategori - Statorial","description":"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk dengan subkategori di Excel, beserta 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\/diagram-batang-bertumpuk-excel-dengan-subkategori\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Membuat Bagan Batang Bertumpuk dengan Subkategori - Statorial","og_description":"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk dengan subkategori di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/","og_site_name":"Statorials","article_published_time":"2023-07-07T10:23:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbart7.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-excel-dengan-subkategori\/","url":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/","name":"Excel: Membuat Bagan Batang Bertumpuk dengan Subkategori - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T10:23:53+00:00","dateModified":"2023-07-07T10:23:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk dengan subkategori di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-excel-dengan-subkategori\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: buat bagan batang bertumpuk dengan subkategori"}]},{"@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\/4835"}],"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=4835"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4835\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}