{"id":4891,"date":"2023-07-06T18:37:35","date_gmt":"2023-07-06T18:37:35","guid":{"rendered":"https:\/\/statorials.org\/id\/bagan-timbul-excel\/"},"modified":"2023-07-06T18:37:35","modified_gmt":"2023-07-06T18:37:35","slug":"bagan-timbul-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bagan-timbul-excel\/","title":{"rendered":"Cara membuat bump chart di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Bagan tambahan<\/strong> adalah jenis bagan yang menunjukkan peringkat berbagai grup dari waktu ke waktu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan bump berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38205 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bosse6.png\" alt=\"\" width=\"609\" height=\"347\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari kita masuk ke dataset berikut yang menunjukkan klasemen 5 tim bola basket berbeda dalam 8 pertandingan berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38198 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bosse1.png\" alt=\"\" width=\"675\" height=\"284\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Masukkan Grafik Bump<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang <strong>A1:I6<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon bernama <strong>Garis dengan Penanda<\/strong> di grup <strong>Grafik<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38200 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bosse0.png\" alt=\"\" width=\"459\" height=\"236\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut grafik relief yang akan dibuat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38201 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bosse2.png\" alt=\"\" width=\"616\" height=\"352\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pertandingan ditampilkan pada sumbu x dan peringkat tim pada saat setiap pertandingan ditampilkan pada sumbu y.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan grafik benjolan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu membalik urutan sumbu y sehingga peringkat 1 muncul di bagian atas grafik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, klik kanan pada salah satu nilai sumbu Y dan klik <strong>Format Axis<\/strong> dari menu drop-down.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Format Sumbu<\/strong> yang muncul di sisi kanan layar, centang kotak di samping <strong>Nilai dalam urutan terbalik<\/strong> , lalu masukkan <strong>1<\/strong> untuk Batas <strong>Minimum<\/strong> , <strong>5<\/strong> untuk Batas <strong>Maksimum<\/strong> , dan <strong>1<\/strong> untuk Satuan <strong>utama<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38202 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bosse3.png\" alt=\"\" width=\"309\" height=\"600\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan nilai sumbu X dan klik <strong>Format Axis<\/strong> dari menu drop-down.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Format Axis<\/strong> , pilih <strong>High<\/strong> untuk <strong>posisi label<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38203 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bosse4.png\" alt=\"\" width=\"283\" height=\"623\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu akan ditampilkan sesuai:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38204 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bosse5.png\" alt=\"\" width=\"606\" height=\"338\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, silakan tambahkan judul, ubah warna garis, dan tambahkan label pada sumbu Y agar diagram lebih mudah dibaca:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38205 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bosse6.png\" alt=\"\" width=\"609\" height=\"347\" 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 membuat visualisasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-divergen-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Membuat Bagan Batang Bertumpuk Divergen<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grafik-excel-menunjukkan-perbedaan-antara-dua-seri\/\" target=\"_blank\" rel=\"noopener\">Excel: Buat bagan untuk memperlihatkan perbedaan antara dua rangkaian<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/diagram-batang-pengurutan-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengurutkan batang di bagan Bart<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bagan tambahan adalah jenis bagan yang menunjukkan peringkat berbagai grup dari waktu ke waktu. Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan bump berikut di Excel: Ayo pergi! Langkah 1: Masukkan datanya Pertama, mari kita masuk ke dataset berikut yang menunjukkan klasemen 5 tim bola basket berbeda dalam 8 pertandingan berbeda: Langkah [&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 Bump Chart di Excel (Langkah demi Langkah) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram bump di Excel, dengan 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-timbul-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Bump Chart di Excel (Langkah demi Langkah) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram bump di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bagan-timbul-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T18:37:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bosse6.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-timbul-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/bagan-timbul-excel\/\",\"name\":\"Cara Membuat Bump Chart di Excel (Langkah demi Langkah) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T18:37:35+00:00\",\"dateModified\":\"2023-07-06T18:37:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram bump di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bagan-timbul-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bagan-timbul-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bagan-timbul-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bump chart di excel (langkah demi langkah)\"}]},{\"@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 Bump Chart di Excel (Langkah demi Langkah) - Statologi","description":"Tutorial ini menjelaskan cara membuat diagram bump di Excel, dengan 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-timbul-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bump Chart di Excel (Langkah demi Langkah) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat diagram bump di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/bagan-timbul-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-06T18:37:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bosse6.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-timbul-excel\/","url":"https:\/\/statorials.org\/id\/bagan-timbul-excel\/","name":"Cara Membuat Bump Chart di Excel (Langkah demi Langkah) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T18:37:35+00:00","dateModified":"2023-07-06T18:37:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram bump di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bagan-timbul-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bagan-timbul-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bagan-timbul-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bump chart di excel (langkah demi langkah)"}]},{"@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\/4891"}],"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=4891"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4891\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}