{"id":4764,"date":"2023-07-08T04:35:09","date_gmt":"2023-07-08T04:35:09","guid":{"rendered":"https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/"},"modified":"2023-07-08T04:35:09","modified_gmt":"2023-07-08T04:35:09","slug":"bagan-kolom-cluster-3d-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/","title":{"rendered":"Cara membuat histogram clustered 3d di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Histogram yang dikelompokkan 3D<\/strong> adalah jenis bagan yang menggunakan batang 3D untuk memvisualisasikan nilai beberapa variabel numerik yang dikelompokkan berdasarkan variabel kategori.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat histogram yang dikelompokkan 3D berikut di Excel yang memperlihatkan penjualan dua produk berbeda di wilayah berbeda untuk sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37204 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus4.png\" alt=\"\" width=\"551\" height=\"337\" 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, masukkan kumpulan data berikut yang menunjukkan total penjualan dua produk berbeda di wilayah berbeda untuk sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37199 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus1.png\" alt=\"\" width=\"464\" height=\"423\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Sisipkan Bagan Kolom Tergugus 3D<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>A1:C7<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Kolom Tergugus 3D<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37200 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus2.png\" alt=\"\" width=\"457\" height=\"299\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan menghasilkan histogram yang dikelompokkan 3D berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37201 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus3.png\" alt=\"\" width=\"572\" height=\"347\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan grafik<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menyesuaikan jarak dan ukuran batang, klik dua kali salah satu batang pada grafik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>Format Seri Data<\/strong> yang muncul, Anda dapat menyesuaikan kedalaman celah dan lebar diagram batang:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37202 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus5.png\" alt=\"\" width=\"288\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan hal berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Gap Depth<\/strong> : Semakin tinggi nilainya, semakin dalam pula bar-bar di grafik.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Lebar celah<\/strong> : Semakin tinggi nilainya, semakin lebar masing-masing batangnya.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menyesuaikan nilai-nilai ini agar bilah tampak sesuai keinginan Anda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan membiarkan nilainya pada pengaturan default untuk contoh ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, silakan ubah warna batang, tambahkan judul pada bagan, dan tambahkan label untuk sumbu Y:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37204 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus4.png\" alt=\"\" width=\"551\" height=\"337\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Grafik terakhir menampilkan penjualan produk A dan B sepanjang sumbu y dengan wilayah yang ditampilkan sepanjang sumbu x.<\/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\/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\/bagan-excel-donat-ganda\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Donat Ganda di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grafik-kuadran-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Kuadran di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Histogram yang dikelompokkan 3D adalah jenis bagan yang menggunakan batang 3D untuk memvisualisasikan nilai beberapa variabel numerik yang dikelompokkan berdasarkan variabel kategori. Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat histogram yang dikelompokkan 3D berikut di Excel yang memperlihatkan penjualan dua produk berbeda di wilayah berbeda untuk sebuah perusahaan: Ayo pergi! Langkah 1: [&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 Histogram Clustered 3D di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat histogram berkelompok 3D di Excel, 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\/bagan-kolom-cluster-3d-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Histogram Clustered 3D di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat histogram berkelompok 3D di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T04:35:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus4.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\/bagan-kolom-cluster-3d-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/\",\"name\":\"Cara Membuat Histogram Clustered 3D di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T04:35:09+00:00\",\"dateModified\":\"2023-07-08T04:35:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat histogram berkelompok 3D di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat histogram clustered 3d 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 Histogram Clustered 3D di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara membuat histogram berkelompok 3D di Excel, 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\/bagan-kolom-cluster-3d-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Histogram Clustered 3D di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara membuat histogram berkelompok 3D di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-08T04:35:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus4.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\/bagan-kolom-cluster-3d-excel\/","url":"https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/","name":"Cara Membuat Histogram Clustered 3D di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T04:35:09+00:00","dateModified":"2023-07-08T04:35:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat histogram berkelompok 3D di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bagan-kolom-cluster-3d-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat histogram clustered 3d 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\/4764"}],"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=4764"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4764\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}