{"id":4798,"date":"2023-07-07T20:06:58","date_gmt":"2023-07-07T20:06:58","guid":{"rendered":"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/"},"modified":"2023-07-07T20:06:58","modified_gmt":"2023-07-07T20:06:58","slug":"diagram-batang-pengurutan-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/","title":{"rendered":"Excel: cara mengurutkan batang di bagan bart"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin mengurutkan batang dalam diagram batang di Excel dalam urutan menaik atau menurun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan menggunakan opsi pengurutan bawaan di Excel dan contoh berikut menunjukkan cara melakukannya.<\/span><\/p>\n<h2> <strong>Contoh: Cara mengurutkan batang pada diagram batang di Excel<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data berikut yang menunjukkan total penjualan yang dilakukan di berbagai wilayah untuk sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37452 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbar1.png\" alt=\"\" width=\"459\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, mari buat diagram batang untuk memvisualisasikan total penjualan berdasarkan wilayah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, sorot rentang sel <strong>A1:B7<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon bagan pertama di bawah <strong>Kolom 2D<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30237 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diagramme-a-bandes.jpg\" alt=\"\" width=\"611\" height=\"146\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Diagram batang akan muncul yang menunjukkan penjualan untuk setiap wilayah sesuai urutan kemunculannya di kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37453 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbar2.png\" alt=\"\" width=\"670\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin mengurutkan batang dari yang terkecil ke terbesar, cukup klik salah satu sel di kolom <strong>Penjualan<\/strong> di kumpulan data asli, lalu klik tab <strong>Data<\/strong> di sepanjang pita atas dan klik ikon yang bertuliskan <strong>Urutkan dari yang Terkecil ke Terbesar<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37454 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier-par-ordre-croissant.png\" alt=\"\" width=\"609\" height=\"143\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kumpulan data dan batang pada diagram batang akan diurutkan dari terkecil hingga terbesar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37455\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbar3.png\" alt=\"Grafik batang keluaran Excel dari terkecil hingga terbesar\" width=\"649\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin mengurutkan batang dari yang terbesar ke terkecil, klik salah satu sel di kolom <strong>Penjualan<\/strong> di kumpulan data asli, lalu klik tab <strong>Data<\/strong> di sepanjang pita atas dan klik ikon yang bertuliskan <strong>Urutkan dari yang terbesar ke terkecil<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37456 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier-par-ordre-decroissant.png\" alt=\"\" width=\"609\" height=\"155\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kumpulan data dan batang pada diagram batang akan diurutkan dari yang terbesar hingga yang terkecil:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37457\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbar4.png\" alt=\"Bagan Batang Urutkan Excel dari Terbesar ke Terkecil\" width=\"656\" height=\"390\" 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> <span style=\"color: #000000;\"><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\/excel-menambahkan-garis-rata-rata-ke-diagram-batang\/\" target=\"_blank\" rel=\"noopener\">Cara Menambahkan Garis Rata-Rata ke Diagram Batang di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin mengurutkan batang dalam diagram batang di Excel dalam urutan menaik atau menurun. Untungnya, hal ini mudah dilakukan menggunakan opsi pengurutan bawaan di Excel dan contoh berikut menunjukkan cara melakukannya. Contoh: Cara mengurutkan batang pada diagram batang di Excel Pertama, mari buat kumpulan data berikut yang menunjukkan total penjualan yang dilakukan di [&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 mengurutkan batang dalam bagan Bart - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan batang pada diagram batang di Excel, dengan beberapa 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-pengurutan-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mengurutkan batang dalam bagan Bart - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan batang pada diagram batang di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T20:06:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbar1.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-batang-pengurutan-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/\",\"name\":\"Excel: Cara mengurutkan batang dalam bagan Bart - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T20:06:58+00:00\",\"dateModified\":\"2023-07-07T20:06:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan batang pada diagram batang di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengurutkan batang di bagan bart\"}]},{\"@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 mengurutkan batang dalam bagan Bart - Statologi","description":"Tutorial ini menjelaskan cara mengurutkan batang pada diagram batang di Excel, dengan beberapa 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-pengurutan-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengurutkan batang dalam bagan Bart - Statologi","og_description":"Tutorial ini menjelaskan cara mengurutkan batang pada diagram batang di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-07T20:06:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sbar1.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-batang-pengurutan-excel\/","url":"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/","name":"Excel: Cara mengurutkan batang dalam bagan Bart - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T20:06:58+00:00","dateModified":"2023-07-07T20:06:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan batang pada diagram batang di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengurutkan batang di bagan bart"}]},{"@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\/4798"}],"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=4798"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4798\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}