{"id":4408,"date":"2023-07-11T08:28:00","date_gmt":"2023-07-11T08:28:00","guid":{"rendered":"https:\/\/statorials.org\/id\/diagram-batang-vba\/"},"modified":"2023-07-11T08:28:00","modified_gmt":"2023-07-11T08:28:00","slug":"diagram-batang-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/diagram-batang-vba\/","title":{"rendered":"Cara membuat bar chart di vba (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

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

 SubCreateBarChart<\/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 bar chart<\/span>\n    Set<\/span> MyChart = Worksheets(\" Sheet1<\/span> \").ChartObjects.Add(Left:=ActiveCell.Left, _\n    Width:=400, Top:=ActiveCell.Top, Height:=300)\n    MyChart.Chart.SetSourceDataSource:=Rng\n    MyChart.Chart.ChartType = xlColumnClustered\n\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini akan meminta pengguna untuk memasukkan rentang masukan dan kemudian secara otomatis menghasilkan diagram batang menggunakan rentang masukan dan memasukkannya ke dalam lembar bernama Sheet1<\/strong> dengan sudut kiri atas diagram terletak di sel yang sedang aktif.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan makro ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara Membuat Bar Chart 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><\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin menggunakan VBA untuk menghasilkan diagram batang menggunakan kumpulan data ini.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubCreateBarChart<\/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 bar chart<\/span>\n    Set<\/span> MyChart = Worksheets(\" Sheet1<\/span> \").ChartObjects.Add(Left:=ActiveCell.Left, _\n    Width:=400, Top:=ActiveCell.Top, Height:=300)\n    MyChart.Chart.SetSourceDataSource:=Rng\n    MyChart.Chart.ChartType = xlColumnClustered\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 CreateBarChart<\/strong> lalu klik Run<\/strong> :<\/span> <\/p>\n
\"\"<\/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 batang berikut secara otomatis akan dibuat dan ditampilkan dengan sudut kiri atas diagram terletak di sel yang sedang aktif, yaitu sel D1<\/strong> :<\/span> <\/p>\n
\"Bagan<\/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 batang.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara menemukan baris yang terakhir digunakan<\/a>
 VBA: Cara menghitung jumlah baris dalam jangkauan<\/a>
 VBA: Cara menghitung jumlah kolom yang digunakan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk membuat diagram batang di Excel menggunakan VBA: SubCreateBarChart () Dim MyChart As ChartObject ‘ get input range from user Set Rng = Application.InputBox(Prompt:=” Select chart input range “, Type:=8) ‘create bar chart Set MyChart = Worksheets(” Sheet1 “).ChartObjects.Add(Left:=ActiveCell.Left, _ Width:=400, Top:=ActiveCell.Top, Height:=300) MyChart.Chart.SetSourceDataSource:=Rng MyChart.Chart.ChartType = xlColumnClustered 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 Bar Chart di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram batang di VBA, dengan sebuah contoh.\" \/>\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-batang-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Bar Chart di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram batang di VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/diagram-batang-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T08:28:00+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-batang-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/diagram-batang-vba\/\",\"name\":\"Cara Membuat Bar Chart di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T08:28:00+00:00\",\"dateModified\":\"2023-07-11T08:28:00+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram batang di VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/diagram-batang-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/diagram-batang-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/diagram-batang-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bar chart 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 Bar Chart di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara membuat diagram batang di VBA, dengan sebuah contoh.","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-batang-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bar Chart di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat diagram batang di VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/diagram-batang-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-11T08:28:00+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-batang-vba\/","url":"https:\/\/statorials.org\/id\/diagram-batang-vba\/","name":"Cara Membuat Bar Chart di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T08:28:00+00:00","dateModified":"2023-07-11T08:28:00+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram batang di VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/diagram-batang-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/diagram-batang-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/diagram-batang-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bar chart 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\/4408"}],"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=4408"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4408\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}