{"id":4484,"date":"2023-07-10T17:54:59","date_gmt":"2023-07-10T17:54:59","guid":{"rendered":"https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/"},"modified":"2023-07-10T17:54:59","modified_gmt":"2023-07-10T17:54:59","slug":"diagram-lingkaran-excel-jumlah-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/","title":{"rendered":"Excel: cara membuat diagram lingkaran menggunakan nilai angka"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat diagram lingkaran di Excel menggunakan sejumlah nilai dalam kolom tertentu.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda memiliki kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35080 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombre-de-tartes1.png\" alt=\"\" width=\"446\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan Anda ingin membuat diagram lingkaran yang menunjukkan jumlah kemunculan setiap nama tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, kita akan memasukkan kumpulan data berikut ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35080 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombre-de-tartes1.png\" alt=\"\" width=\"431\" height=\"395\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat daftar nilai unik<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan rumus berikut untuk membuat daftar nama tim unik:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SINGLE( <span style=\"color: #3366ff;\">A2:A12<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus ini di sel <strong>D2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35081 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombre-de-tartes2.png\" alt=\"\" width=\"512\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya membuat daftar nama tim unik dari kolom A.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung kemunculan setiap nilai<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan memasukkan rumus berikut di sel <strong>E2<\/strong> untuk menghitung kemunculan setiap nama tim unik:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #3366ff;\">$A$2:$A$12<\/span> , <span style=\"color: #ff0000;\">D2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyeret rumus ini ke setiap sel yang tersisa di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35082 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombre-de-tartes3.png\" alt=\"\" width=\"506\" height=\"450\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Buat Diagram Lingkaran<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat menyorot rentang <strong>D2:E5<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Pai<\/strong> di grup <strong>Grafik<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35083 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diagramme-circulaire.png\" alt=\"\" width=\"501\" height=\"193\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Diagram lingkaran berikut akan dibuat secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35084 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombre-de-tartes4.png\" alt=\"\" width=\"506\" height=\"356\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Diagram lingkaran menunjukkan jumlah nama tim unik dalam kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menyesuaikan diagram lingkaran dengan menambahkan judul dan label data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35085 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombre-de-tartes5.png\" alt=\"\" width=\"506\" height=\"352\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Angka-angka di setiap potongan pie menunjukkan jumlah nama di setiap tim.<\/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\/bilah-diagram-lingkaran-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Batang Diagram Lingkaran di Excel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/memutar-diagram-lingkaran-excel\/\" target=\"_blank\" rel=\"noopener\">Cara memutar irisan diagram lingkaran 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>Seringkali, Anda mungkin ingin membuat diagram lingkaran di Excel menggunakan sejumlah nilai dalam kolom tertentu. Misalnya, Anda memiliki kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket: Misalkan Anda ingin membuat diagram lingkaran yang menunjukkan jumlah kemunculan setiap nama tim. Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Masukkan [&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: Cara Membuat Diagram Lingkaran Menggunakan Nilai Angka - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan sejumlah nilai dalam satu kolom, 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\/diagram-lingkaran-excel-jumlah-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Membuat Diagram Lingkaran Menggunakan Nilai Angka - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan sejumlah nilai dalam satu kolom, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T17:54:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombre-de-tartes1.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-lingkaran-excel-jumlah-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/\",\"name\":\"Excel: Cara Membuat Diagram Lingkaran Menggunakan Nilai Angka - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T17:54:59+00:00\",\"dateModified\":\"2023-07-10T17:54:59+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan sejumlah nilai dalam satu kolom, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara membuat diagram lingkaran menggunakan nilai angka\"}]},{\"@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: Cara Membuat Diagram Lingkaran Menggunakan Nilai Angka - Statorial","description":"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan sejumlah nilai dalam satu kolom, 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\/diagram-lingkaran-excel-jumlah-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Membuat Diagram Lingkaran Menggunakan Nilai Angka - Statorial","og_description":"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan sejumlah nilai dalam satu kolom, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-10T17:54:59+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombre-de-tartes1.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-lingkaran-excel-jumlah-nilai\/","url":"https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/","name":"Excel: Cara Membuat Diagram Lingkaran Menggunakan Nilai Angka - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T17:54:59+00:00","dateModified":"2023-07-10T17:54:59+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan sejumlah nilai dalam satu kolom, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/diagram-lingkaran-excel-jumlah-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara membuat diagram lingkaran menggunakan nilai angka"}]},{"@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\/4484"}],"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=4484"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4484\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}