{"id":4759,"date":"2023-07-08T05:47:27","date_gmt":"2023-07-08T05:47:27","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/"},"modified":"2023-07-08T05:47:27","modified_gmt":"2023-07-08T05:47:27","slug":"excel-memindahkan-sumbu-horizontal-ke-bawah","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/","title":{"rendered":"Excel: cara memindahkan sumbu horizontal ke bawah grafik"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat dengan cepat memindahkan sumbu horizontal ke bawah bagan di Excel dengan mengubah nilai <strong>Posisi Label<\/strong> di panel <strong>Format Sumbu<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini dalam praktik.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 1: Masukkan datanya<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan kumpulan data berikut ke dalam Excel yang memperlihatkan pertumbuhan penjualan perusahaan selama 10 periode penjualan berturut-turut:<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37153 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axeb1.png\" alt=\"\" width=\"467\" height=\"437\" srcset=\"\" sizes=\"\"><\/strong><\/span><\/h2>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat bagan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot nilai dalam rentang <strong>B2:B11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon yang disebut <strong>Kolom Dikelompokkan<\/strong> dalam 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=\"553\" height=\"132\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Grafik berikut akan otomatis muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37152 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axeb2.png\" alt=\"\" width=\"553\" height=\"304\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara default, Excel menetapkan sumbu horizontal ke nilai y = 0.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Pindahkan sumbu horizontal ke bagian bawah grafik<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Jika grafik memiliki nilai negatif seperti ini, biasanya yang terbaik adalah memindahkan sumbu horizontal ke bawah agar label sumbu lebih mudah dibaca.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik kanan salah satu nilai sumbu horizontal, lalu klik <strong>Format Sumbu<\/strong> dari menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37154 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axeb3.png\" alt=\"\" width=\"552\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Format Axis<\/strong> yang muncul, klik panah drop-down di samping <strong>Labels<\/strong> , lalu klik panah drop-down di samping <strong>Label Position<\/strong> , lalu klik <strong>Low<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37155 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axeb4.png\" alt=\"\" width=\"277\" height=\"622\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu horizontal akan dipindahkan ke bagian bawah grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37156 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axeb5.png\" alt=\"\" width=\"577\" height=\"319\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa sekarang lebih mudah untuk membaca label sumbu dan label tidak lagi tumpang tindih dengan batang dengan nilai negatif.<\/span><\/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 melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/label-sumbu-rotasi-excel\/\" target=\"_blank\" rel=\"noopener\">Cara memutar label sumbu di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Mengubah Skala Sumbu di Plot Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tambahkan-grafik-excel-dengan-garis-vertikal\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis vertikal ke grafik di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat dengan cepat memindahkan sumbu horizontal ke bawah bagan di Excel dengan mengubah nilai Posisi Label di panel Format Sumbu . Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini dalam praktik. Langkah 1: Masukkan datanya Pertama, masukkan kumpulan data berikut ke dalam Excel yang memperlihatkan pertumbuhan penjualan perusahaan selama 10 periode penjualan [&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 memindahkan sumbu horizontal ke bawah pada grafik - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memindahkan sumbu horizontal ke bawah grafik 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\/excel-memindahkan-sumbu-horizontal-ke-bawah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara memindahkan sumbu horizontal ke bawah pada grafik - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memindahkan sumbu horizontal ke bawah grafik di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T05:47:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axeb1.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\/excel-memindahkan-sumbu-horizontal-ke-bawah\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/\",\"name\":\"Excel: Cara memindahkan sumbu horizontal ke bawah pada grafik - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T05:47:27+00:00\",\"dateModified\":\"2023-07-08T05:47:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memindahkan sumbu horizontal ke bawah grafik di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara memindahkan sumbu horizontal ke bawah grafik\"}]},{\"@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 memindahkan sumbu horizontal ke bawah pada grafik - Statologi","description":"Tutorial ini menjelaskan cara memindahkan sumbu horizontal ke bawah grafik 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\/excel-memindahkan-sumbu-horizontal-ke-bawah\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara memindahkan sumbu horizontal ke bawah pada grafik - Statologi","og_description":"Tutorial ini menjelaskan cara memindahkan sumbu horizontal ke bawah grafik di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/","og_site_name":"Statorials","article_published_time":"2023-07-08T05:47:27+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axeb1.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\/excel-memindahkan-sumbu-horizontal-ke-bawah\/","url":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/","name":"Excel: Cara memindahkan sumbu horizontal ke bawah pada grafik - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T05:47:27+00:00","dateModified":"2023-07-08T05:47:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memindahkan sumbu horizontal ke bawah grafik di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara memindahkan sumbu horizontal ke bawah grafik"}]},{"@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\/4759"}],"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=4759"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4759\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}