{"id":4661,"date":"2023-07-09T04:52:36","date_gmt":"2023-07-09T04:52:36","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/"},"modified":"2023-07-09T04:52:36","modified_gmt":"2023-07-09T04:52:36","slug":"excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/","title":{"rendered":"Excel: menampilkan persentase dalam bagan kolom bertumpuk"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Terkadang Anda mungkin ingin menampilkan label persentase dalam histogram bertumpuk di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat diagram batang bertumpuk berikut dengan label persentase di dalam setiap batang:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36382\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp9.png\" alt=\"Excel menampilkan persentase dalam diagram batang bertumpuk\" width=\"562\" height=\"386\" 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 yang dilakukan setiap kuartal oleh toko ritel di berbagai wilayah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36374 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp1.png\" alt=\"\" width=\"474\" height=\"363\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung nilai persentase<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kami akan menghitung persentase penjualan yang dilakukan setiap kuartal untuk setiap wilayah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus berikut di sel <strong>B7<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>= <span style=\"color: #3366ff;\">B2<\/span> \/SUM( <span style=\"color: #ff0000;\">$B2:$E2<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke sebelah kanan setiap kuartal, lalu klik dan menyeret ke bawah ke setiap wilayah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36375 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp2.png\" alt=\"\" width=\"481\" height=\"385\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>B7:E10<\/strong> , dan klik simbol <strong>%<\/strong> di grup <strong>Angka<\/strong> pada tab <strong>Beranda<\/strong> untuk melihat nilai-nilai ini sebagai persentase:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36376 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp3.png\" alt=\"\" width=\"481\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Buat Bagan Kolom Bertumpuk<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>A1:E5<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>Kolom Bertumpuk<\/strong> di grup <strong>Bagan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Grafik berikut akan dibuat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36377 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp4.png\" alt=\"\" width=\"588\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Tambahkan Label Persentase<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik salah satu bilah kuning pada grafik. Kemudian klik tanda plus kecil berwarna hijau di pojok atas. Lalu klik panah tarik-turun di samping <strong>Label Data<\/strong> , lalu klik <strong>Opsi Lainnya<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36378 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp5.png\" alt=\"\" width=\"459\" height=\"488\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Format Data Labels<\/strong> yang muncul di sisi kanan layar, hapus centang pada kotak di samping <strong>Values<\/strong> , lalu centang kotak di samping <strong>Value From Cells<\/strong> dan pilih <strong>B10:E10<\/strong> sebagai rentangnya.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36379 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp6.png\" alt=\"\" width=\"532\" height=\"572\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , label persentase akan ditambahkan ke bilah kuning:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36380 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp7.png\" alt=\"\" width=\"610\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ulangi proses ini untuk bilah abu-abu, oranye, dan biru:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36381 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp8.png\" alt=\"\" width=\"576\" height=\"401\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 5: Sesuaikan bagan (opsional)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menambahkan judul, menyesuaikan warna, dan menyesuaikan ukuran font teks untuk membuat plot lebih estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36382\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp9.png\" alt=\"Excel menampilkan persentase dalam diagram batang bertumpuk\" width=\"562\" height=\"386\" 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> <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><br \/> <a href=\"https:\/\/statorials.org\/id\/spasi-bagan-kolom-berkerumun-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menyesuaikan spasi dalam bagan kolom yang dikelompokkan di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Terkadang Anda mungkin ingin menampilkan label persentase dalam histogram bertumpuk di Excel. Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat diagram batang bertumpuk berikut dengan label persentase di dalam setiap batang: Ayo pergi! Langkah 1: Masukkan datanya Pertama, mari buat kumpulan data berikut yang menunjukkan total penjualan yang dilakukan setiap kuartal oleh toko [&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: Menampilkan persentase dalam bagan kolom bertumpuk - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menampilkan persentase dalam diagram batang bertumpuk di Excel, termasuk 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\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Menampilkan persentase dalam bagan kolom bertumpuk - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menampilkan persentase dalam diagram batang bertumpuk di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T04:52:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp9.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/\",\"name\":\"Excel: Menampilkan persentase dalam bagan kolom bertumpuk - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T04:52:36+00:00\",\"dateModified\":\"2023-07-09T04:52:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menampilkan persentase dalam diagram batang bertumpuk di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: menampilkan persentase dalam bagan kolom bertumpuk\"}]},{\"@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: Menampilkan persentase dalam bagan kolom bertumpuk - Statorial","description":"Tutorial ini menjelaskan cara menampilkan persentase dalam diagram batang bertumpuk di Excel, termasuk 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\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Menampilkan persentase dalam bagan kolom bertumpuk - Statorial","og_description":"Tutorial ini menjelaskan cara menampilkan persentase dalam diagram batang bertumpuk di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/","og_site_name":"Statorials","article_published_time":"2023-07-09T04:52:36+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/showp9.png"}],"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\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/","url":"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/","name":"Excel: Menampilkan persentase dalam bagan kolom bertumpuk - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T04:52:36+00:00","dateModified":"2023-07-09T04:52:36+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menampilkan persentase dalam diagram batang bertumpuk di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menunjukkan-persentase-dalam-bagan-kolom-bertumpuk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: menampilkan persentase dalam bagan kolom bertumpuk"}]},{"@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\/4661"}],"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=4661"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4661\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}