{"id":3452,"date":"2023-07-17T10:13:43","date_gmt":"2023-07-17T10:13:43","guid":{"rendered":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/"},"modified":"2023-07-17T10:13:43","modified_gmt":"2023-07-17T10:13:43","slug":"diagram-batang-bertumpuk-berkerumun-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/","title":{"rendered":"Cara membuat bagan batang bertumpuk berkelompok di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Diagram batang bertumpuk berkerumun<\/strong> adalah jenis diagram batang yang dikelompokkan dan ditumpuk.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini sangat berguna untuk melihat nilai data yang memiliki banyak grup dan mencakup beberapa periode waktu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat diagram batang bertumpuk berkerumun berikut ini di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-28838\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clusterstack1.jpg\" alt=\"diagram batang bertumpuk berkerumun di Excel\" width=\"529\" height=\"385\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari kita masuk ke kumpulan data berikut yang menunjukkan penjualan berbagai produk di toko ritel berbeda pada tahun berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28839 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile-de-cluster2.jpg\" alt=\"\" width=\"557\" height=\"459\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Bagan Batang Bertumpuk Berkelompok<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>C1:E16<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Kolom Bertumpuk<\/strong> di grup <strong>Bagan<\/strong> untuk membuat diagram batang bertumpuk berkelompok berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28840 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clusterstack3.jpg\" alt=\"\" width=\"671\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan<\/strong><\/span> <span style=\"color: #000000;\"><strong>diagram batang bertumpuk yang terkluster<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu memasukkan label khusus pada sumbu x.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sebelum Anda melakukannya, klik sel <strong>A17<\/strong> dan ketik beberapa spasi kosong. Ini diperlukan untuk langkah selanjutnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan di mana saja pada grafik dan klik <strong>Pilih Data<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul, klik tombol <strong>Edit<\/strong> di bawah <strong>Label Sumbu Horizontal (Kategori)<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28841 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile-de-cluster4.jpg\" alt=\"\" width=\"607\" height=\"349\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk rentang label sumbu, sorot rentang <strong>A2:B17<\/strong> dan klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28842 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile-de-cluster5.jpg\" alt=\"\" width=\"355\" height=\"493\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Label berikut akan muncul pada sumbu X:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28843 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pile-de-cluster6.jpg\" alt=\"\" width=\"563\" height=\"377\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik salah satu batang pada grafik. Pada panel <strong>Format Data Series<\/strong> yang muncul, sesuaikan <strong>Gap width<\/strong> menjadi <strong>0%<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28844 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clusters7.jpg\" alt=\"\" width=\"328\" height=\"479\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kesenjangan antar batang dalam cluster yang sama akan dihilangkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28845 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clusters8.jpg\" alt=\"\" width=\"570\" height=\"377\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik pada batang mana saja pada grafik. Pada panel <strong>Format Data Series<\/strong> yang muncul, klik ikon paint bucket, lalu klik <strong>Border<\/strong> dan pilih <strong>Solid Line<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28846 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clusters9.jpg\" alt=\"\" width=\"305\" height=\"445\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ulangi untuk setiap batang pada bagan hingga ada batas hitam pekat di sekeliling setiap batang:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28847 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clusters10.jpg\" alt=\"\" width=\"582\" height=\"389\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, klik teks judul dan ubah menjadi \u201cPenjualan menurut toko dan tahun.\u201d<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik elemen teks individual dari plot yang Anda inginkan dan tebalkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28838 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clusterstack1.jpg\" alt=\"\" width=\"570\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Diagram batang bertumpuk yang terkluster kini telah selesai.<\/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 membuat visualisasi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Kuadran di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-gelembung-excel-dengan-label\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Gelembung di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Donat Ganda di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Diagram batang bertumpuk berkerumun adalah jenis diagram batang yang dikelompokkan dan ditumpuk. Ini sangat berguna untuk melihat nilai data yang memiliki banyak grup dan mencakup beberapa periode waktu. Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat diagram batang bertumpuk berkerumun berikut ini di Excel: Langkah 1: Masukkan datanya Pertama, mari kita masuk ke [&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 Bagan Batang Bertumpuk Berkelompok di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk cluster di Excel, dengan contoh lengkap.\" \/>\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-berkerumun-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Bagan Batang Bertumpuk Berkelompok di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk cluster di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T10:13:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clusterstack1.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=\"2 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-berkerumun-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/\",\"name\":\"Cara Membuat Bagan Batang Bertumpuk Berkelompok di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T10:13:43+00:00\",\"dateModified\":\"2023-07-17T10:13:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk cluster di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bagan batang bertumpuk berkelompok di excel\"}]},{\"@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 Bagan Batang Bertumpuk Berkelompok di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk cluster di Excel, dengan contoh lengkap.","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-berkerumun-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bagan Batang Bertumpuk Berkelompok di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk cluster di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-17T10:13:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clusterstack1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/","url":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/","name":"Cara Membuat Bagan Batang Bertumpuk Berkelompok di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T10:13:43+00:00","dateModified":"2023-07-17T10:13:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram batang bertumpuk cluster di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bagan batang bertumpuk berkelompok di excel"}]},{"@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\/3452"}],"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=3452"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3452\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}