{"id":4477,"date":"2023-07-10T19:14:02","date_gmt":"2023-07-10T19:14:02","guid":{"rendered":"https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/"},"modified":"2023-07-10T19:14:02","modified_gmt":"2023-07-10T19:14:02","slug":"diagram-lingkaran-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/","title":{"rendered":"Cara membuat diagram lingkaran di vba (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk membuat diagram lingkaran di Excel menggunakan VBA:<\/span><\/p>\n

 SubCreatePieChart<\/span> ()\n\n    Dim<\/span> MyChart As<\/span> ChartObject\n    \n    ' get input range from user<\/span>\n    Set Rng = Application.InputBox(Prompt:=\" Select chart input range<\/span> \", Type:=8)\n    \n    'create pie chart<\/span>\n    Set<\/span> MyChart = Worksheets(\" Sheet1<\/span> \").ChartObjects.Add(Left:=ActiveCell.Left, _\n    Width:=400, Top:=ActiveCell.Top, Height:=300)\n    \n    MyChart.Chart.SetSourceDataSource:=Rng\n    MyChart.Chart.ChartType = xlPie\n\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini akan menanyakan rentang masukan kepada pengguna dan kemudian secara otomatis membuat diagram lingkaran menggunakan rentang masukan dan memasukkannya ke dalam lembar bernama Sheet1<\/strong> dengan sudut kiri atas bagan terletak di sel yang sedang aktif.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan makro ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara Membuat Diagram Lingkaran di VBA<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang poin yang dicetak oleh berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin menggunakan VBA untuk menghasilkan diagram lingkaran menggunakan kumpulan data ini.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubCreatePieChart<\/span> ()\n\n    Dim<\/span> MyChart As<\/span> ChartObject\n    \n    ' get input range from user<\/span>\n    Set Rng = Application.InputBox(Prompt:=\" Select chart input range<\/span> \", Type:=8)\n    \n    'create pie chart<\/span>\n    Set<\/span> MyChart = Worksheets(\" Sheet1<\/span> \").ChartObjects.Add(Left:=ActiveCell.Left, _\n    Width:=400, Top:=ActiveCell.Top, Height:=300)\n    \n    MyChart.Chart.SetSourceDataSource:=Rng\n    MyChart.Chart.ChartType = xlPie\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Untuk menjalankan makro ini, kita dapat mengklik tab Pengembang<\/strong> di sepanjang pita atas di Excel lalu klik Makro<\/strong> .<\/span><\/p>\n
 Kita kemudian dapat mengklik yang berlabel CreatePieChart<\/strong> lalu klik Run<\/strong> :<\/span><\/p>\n
 Setelah kita mengklik Run<\/strong> , kita akan diminta memasukkan rentang input untuk diagram batang kita:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita ketik A1:B7<\/strong> , lalu tekan OK<\/strong> .<\/span><\/p>\n
 Diagram lingkaran berikut secara otomatis akan dibuat dan ditampilkan dengan sudut kiri atas diagram terletak di sel yang sedang aktif, yaitu sel D2<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Catatan<\/strong> : Anda dapat mengubah nilai argumen Lebar<\/strong> dan Tinggi<\/strong> di fungsi ChartObjects.Add()<\/strong> untuk menyesuaikan lebar dan tinggi diagram lingkaran.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 Cara Membuat Diagram Batang di VBA<\/a>
 Cara membulatkan nilai di VBA<\/a>
 Cara membulatkan nilai di VBA<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk membuat diagram lingkaran di Excel menggunakan VBA: SubCreatePieChart () Dim MyChart As ChartObject ‘ get input range from user Set Rng = Application.InputBox(Prompt:=” Select chart input range “, Type:=8) ‘create pie chart Set MyChart = Worksheets(” Sheet1 “).ChartObjects.Add(Left:=ActiveCell.Left, _ Width:=400, Top:=ActiveCell.Top, Height:=300) MyChart.Chart.SetSourceDataSource:=Rng MyChart.Chart.ChartType = xlPie End Sub […]<\/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":"\nCara Membuat Diagram Lingkaran di VBA (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan VBA, beserta contohnya.\" \/>\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-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Diagram Lingkaran di VBA (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan VBA, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T19:14:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbar1.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-lingkaran-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/\",\"name\":\"Cara Membuat Diagram Lingkaran di VBA (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T19:14:02+00:00\",\"dateModified\":\"2023-07-10T19:14:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan VBA, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat diagram lingkaran di vba (dengan contoh)\"}]},{\"@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 Diagram Lingkaran di VBA (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan VBA, beserta contohnya.","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-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Diagram Lingkaran di VBA (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan VBA, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-10T19:14:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbar1.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-lingkaran-vba\/","url":"https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/","name":"Cara Membuat Diagram Lingkaran di VBA (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T19:14:02+00:00","dateModified":"2023-07-10T19:14:02+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram lingkaran di Excel menggunakan VBA, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/diagram-lingkaran-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat diagram lingkaran di vba (dengan contoh)"}]},{"@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\/4477"}],"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=4477"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4477\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}