{"id":662,"date":"2023-07-29T04:27:04","date_gmt":"2023-07-29T04:27:04","guid":{"rendered":"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/"},"modified":"2023-07-29T04:27:04","modified_gmt":"2023-07-29T04:27:04","slug":"bagan-excel-donat-ganda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/","title":{"rendered":"Cara membuat bagan donat ganda di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Bagan donat<\/strong> adalah bagan melingkar yang menggunakan &#8220;irisan&#8221; untuk menampilkan ukuran relatif data. Bentuknya seperti diagram lingkaran, hanya saja ada lubang di tengahnya sehingga lebih mirip donat.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6341 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet1.png\" alt=\"Contoh Bagan Donat\" width=\"279\" height=\"270\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Bagan donat ganda<\/strong> persis seperti yang terlihat: bagan donat dengan dua lapisan, bukan satu.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6342 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet2.png\" alt=\"Contoh Bagan Donat Ganda\" width=\"273\" height=\"297\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara membuat bagan donat ganda di Excel.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh: Bagan Donat Ganda di Excel<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Selesaikan langkah-langkah berikut untuk membuat bagan donat ganda di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Masukkan data berikut ke dalam Excel, yang menampilkan persentase pendapatan perusahaan dari empat produk berbeda selama dua kuartal penjualan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6343 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet3.png\" alt=\"Data mentah di Excel\" width=\"409\" height=\"332\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Buat bagan donat.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Sorot dua kolom data pertama.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6344 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet4.png\" alt=\"\" width=\"418\" height=\"316\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada tab <strong>Data<\/strong> , di grup <strong>Charts<\/strong> , klik ikon <strong>Insert Pie or Donut Chart<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6345 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet5.png\" alt=\"Ikon diagram lingkaran atau diagram donat di Excel\" width=\"350\" height=\"115\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Klik pada ikon yang bertuliskan <strong>Donat<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6346 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet6.png\" alt=\"Opsi Bagan Donat di Excel\" width=\"211\" height=\"368\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bagan donat berikut akan otomatis muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6348 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet7.png\" alt=\"Contoh Bagan Donat di Excel\" width=\"293\" height=\"260\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan layer untuk membuat bagan donat ganda.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik kanan bagan donat dan klik <strong>Pilih Data<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6349 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet8.png\" alt=\"Pilih data di Excel\" width=\"429\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Tambah<\/strong> untuk menambahkan seri data baru.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6350 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet9.png\" alt=\"\" width=\"469\" height=\"269\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk <strong>Nilai Seri<\/strong> , masukkan rentang nilai pendapatan kuartal kedua:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6351 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet10.png\" alt=\"\" width=\"399\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Klik <strong>Oke<\/strong> . Bagan donat akan otomatis diperbarui dengan lapisan luar kedua:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6352 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet11.png\" alt=\"Bagan Donat Ganda di Excel\" width=\"410\" height=\"382\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 4: Ubah Tampilan (Opsional).<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda membuat bagan donat ganda, Anda dapat memutuskan untuk menambahkan judul dan label, dan sedikit memperkecil ukuran lubang di tengahnya agar bagan lebih mudah dibaca:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6342 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet2.png\" alt=\"Bagan donat ganda dengan judul di Excel\" width=\"296\" height=\"322\" 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 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\/bilah-kemajuan-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Progress Bar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/menggambar-banyak-garis-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menggambar banyak garis di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Ogive di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bagan donat adalah bagan melingkar yang menggunakan &#8220;irisan&#8221; untuk menampilkan ukuran relatif data. Bentuknya seperti diagram lingkaran, hanya saja ada lubang di tengahnya sehingga lebih mirip donat. Bagan donat ganda persis seperti yang terlihat: bagan donat dengan dua lapisan, bukan satu. Tutorial ini menjelaskan cara membuat bagan donat ganda di Excel. Contoh: Bagan Donat Ganda [&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 Donat Ganda di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat bagan donat ganda 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\/bagan-excel-donat-ganda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Bagan Donat Ganda di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat bagan donat ganda di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T04:27:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet1.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-excel-donat-ganda\/\",\"url\":\"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/\",\"name\":\"Cara Membuat Bagan Donat Ganda di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T04:27:04+00:00\",\"dateModified\":\"2023-07-29T04:27:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat bagan donat ganda di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bagan donat ganda 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 Donat Ganda di Excel \u2013 Statorials","description":"Penjelasan sederhana cara membuat bagan donat ganda 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\/bagan-excel-donat-ganda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bagan Donat Ganda di Excel \u2013 Statorials","og_description":"Penjelasan sederhana cara membuat bagan donat ganda di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/","og_site_name":"Statorials","article_published_time":"2023-07-29T04:27:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/beignet1.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-excel-donat-ganda\/","url":"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/","name":"Cara Membuat Bagan Donat Ganda di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T04:27:04+00:00","dateModified":"2023-07-29T04:27:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat bagan donat ganda di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bagan-excel-donat-ganda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bagan donat ganda 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\/662"}],"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=662"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/662\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}