{"id":4760,"date":"2023-07-08T05:45:04","date_gmt":"2023-07-08T05:45:04","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/"},"modified":"2023-07-08T05:45:04","modified_gmt":"2023-07-08T05:45:04","slug":"excel-memindahkan-sumbu-vertikal-ke-kiri","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/","title":{"rendered":"Excel: cara memindahkan sumbu vertikal ke kiri 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<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-horizontal-ke-bawah\/\" target=\"_blank\" rel=\"noopener\">Cara Memindahkan Sumbu Horizontal ke Bawah Grafik di Excel<\/a><\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 1: Masukkan datanya<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari masukkan kumpulan data berikut ke dalam Excel:<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37162 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axel1.png\" alt=\"\" width=\"447\" height=\"396\" 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>A2:B11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon bernama <strong>Sebar<\/strong> di grup <strong>Grafik<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16294 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/disperserexcel.png\" alt=\"\" width=\"551\" height=\"227\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul plot sebar berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37163 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axel2.png\" alt=\"\" width=\"570\" height=\"355\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara default, Excel menetapkan sumbu vertikal ke nilai x = 0.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Pindahkan sumbu vertikal ke kiri<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk memindahkan sumbu vertikal ke kiri bagan, klik kanan salah satu nilai sumbu vertikal, lalu klik <strong>Format Sumbu<\/strong> dari menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37164 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axel3.png\" alt=\"\" width=\"571\" height=\"396\" 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-37165 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axel4.png\" alt=\"\" width=\"310\" height=\"720\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu vertikal akan dipindahkan ke kiri grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37166 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axel5.png\" alt=\"\" width=\"574\" height=\"342\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda ingin memindahkan sumbu vertikal ke kanan grafik, Anda dapat memilih <strong>Tinggi<\/strong> dari menu drop-down <strong>Label Position<\/strong> .<\/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. Terkait: Cara Memindahkan Sumbu Horizontal ke Bawah Grafik di Excel Langkah 1: Masukkan datanya Pertama, mari masukkan kumpulan data berikut ke [&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 vertikal ke kiri grafik - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memindahkan sumbu vertikal ke kiri grafik di Excel, dengan contoh lengkap.\" \/>\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-vertikal-ke-kiri\/\" \/>\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 vertikal ke kiri grafik - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memindahkan sumbu vertikal ke kiri grafik di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T05:45:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axel1.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-vertikal-ke-kiri\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/\",\"name\":\"Excel: Cara memindahkan sumbu vertikal ke kiri grafik - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T05:45:04+00:00\",\"dateModified\":\"2023-07-08T05:45:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memindahkan sumbu vertikal ke kiri grafik di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara memindahkan sumbu vertikal ke kiri 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 vertikal ke kiri grafik - Statologi","description":"Tutorial ini menjelaskan cara memindahkan sumbu vertikal ke kiri grafik di Excel, dengan contoh lengkap.","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-vertikal-ke-kiri\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara memindahkan sumbu vertikal ke kiri grafik - Statologi","og_description":"Tutorial ini menjelaskan cara memindahkan sumbu vertikal ke kiri grafik di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/","og_site_name":"Statorials","article_published_time":"2023-07-08T05:45:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/axel1.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-vertikal-ke-kiri\/","url":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/","name":"Excel: Cara memindahkan sumbu vertikal ke kiri grafik - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T05:45:04+00:00","dateModified":"2023-07-08T05:45:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memindahkan sumbu vertikal ke kiri grafik di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-memindahkan-sumbu-vertikal-ke-kiri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara memindahkan sumbu vertikal ke kiri 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\/4760"}],"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=4760"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4760\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}