{"id":2709,"date":"2023-07-21T02:03:56","date_gmt":"2023-07-21T02:03:56","guid":{"rendered":"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/"},"modified":"2023-07-21T02:03:56","modified_gmt":"2023-07-21T02:03:56","slug":"skala-sumbu-perubahan-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/","title":{"rendered":"Cara mengubah skala sumbu di plot excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah cara mengubah skala sumbu X dan Y pada plot di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan sekumpulan data sederhana ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23866 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echelle1.jpg\" alt=\"\" width=\"473\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat diagram sebar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot sel dalam rentang <strong>A2:B16<\/strong> . Kemudian klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, dan klik opsi <strong>Sebar<\/strong> di grup <strong>Grafik<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23867 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echelle2.jpg\" alt=\"\" width=\"463\" height=\"456\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Point cloud berikut akan otomatis dibuat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23868 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echelle3.jpg\" alt=\"\" width=\"639\" height=\"468\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Ubah Skala Sumbu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Secara default, Excel akan memilih skala untuk sumbu X dan Y yang berkisar dari nilai minimum hingga maksimum di setiap kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, kita dapat melihat bahwa <strong>sumbu x<\/strong> dari <strong>0 hingga 20<\/strong> dan <strong>sumbu y<\/strong> dari <strong>0 hingga 30<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengubah skala sumbu x, cukup klik kanan pada salah satu nilai sumbu x. Di menu tarik-turun yang muncul, klik <strong>Format Sumbu<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23869 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echelle4.jpg\" alt=\"\" width=\"395\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Format Axis<\/strong> yang muncul di sisi kanan layar, ubah nilai pada kotak Minimum dan Maksimum untuk mengubah skala sumbu X.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat mengubah nilai maksimum sumbu x menjadi <strong>50<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23870 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echelle5.jpg\" alt=\"\" width=\"305\" height=\"513\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita menekan <strong>Enter<\/strong> , skala sumbu x akan otomatis diperbarui pada plot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23871\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echelle6.jpg\" alt=\"Contoh excel mengubah skala sumbu\" width=\"529\" height=\"372\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sumbu x sekarang berkisar antara <strong>0 hingga 50<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sumbu y tetap tidak berubah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Daripada mengubah batas minimum dan maksimum, kita juga dapat memilih untuk menggunakan skala logaritmik untuk sumbunya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>Format Axis<\/strong> , cukup centang kotak di sebelah <strong>Skala logaritmik<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23872 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echelle7.jpg\" alt=\"\" width=\"286\" height=\"485\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x akan otomatis diperbarui untuk menggunakan skala logaritmik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23873\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echelle8.jpg\" alt=\"Skala logaritmik Excel\" width=\"483\" height=\"354\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/kapan-harus-menggunakan-skala-logaritmik\/\" target=\"_blank\" rel=\"noopener\">Kapan sebaiknya Anda menggunakan skala logaritmik dalam grafik?<\/a><\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini kami memilih untuk hanya mengubah skala sumbu x.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, kita dapat dengan mudah mengubah skala sumbu y dengan mengklik kanan salah satu nilai sumbu y dan melakukan langkah yang sama seperti di atas.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/menggambar-banyak-garis-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menggambar banyak garis di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/plot-kotak-berdampingan-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Kotak Berdampingan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Ogive di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial ini memberikan contoh langkah demi langkah cara mengubah skala sumbu X dan Y pada plot di Excel. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan sekumpulan data sederhana ke dalam Excel: Langkah 2: Buat diagram sebar Selanjutnya, sorot sel dalam rentang A2:B16 . Kemudian klik tab Sisipkan di sepanjang pita atas, dan klik [&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 Mengubah Skala Sumbu di Plot Excel (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah skala sumbu pada plot 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\/skala-sumbu-perubahan-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengubah Skala Sumbu di Plot Excel (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah skala sumbu pada plot di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T02:03:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echelle1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/\",\"name\":\"Cara Mengubah Skala Sumbu di Plot Excel (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T02:03:56+00:00\",\"dateModified\":\"2023-07-21T02:03:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah skala sumbu pada plot di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengubah skala sumbu di plot excel (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 Mengubah Skala Sumbu di Plot Excel (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara mengubah skala sumbu pada plot 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\/skala-sumbu-perubahan-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengubah Skala Sumbu di Plot Excel (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara mengubah skala sumbu pada plot di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-21T02:03:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/echelle1.jpg"}],"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\/skala-sumbu-perubahan-excel\/","url":"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/","name":"Cara Mengubah Skala Sumbu di Plot Excel (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T02:03:56+00:00","dateModified":"2023-07-21T02:03:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah skala sumbu pada plot di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/skala-sumbu-perubahan-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengubah skala sumbu di plot excel (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\/2709"}],"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=2709"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2709\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}