{"id":3180,"date":"2023-07-18T19:58:56","date_gmt":"2023-07-18T19:58:56","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/"},"modified":"2023-07-18T19:58:56","modified_gmt":"2023-07-18T19:58:56","slug":"google-sheet-mengubah-skala-sumbu","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/","title":{"rendered":"Cara mengubah skala sumbu di plot google sheets"},"content":{"rendered":"

<\/p>\n

\n

Tutorial ini memberikan contoh langkah demi langkah tentang cara mengubah skala sumbu pada plot di Google Spreadsheet.<\/span><\/p>\n

Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n

Mari kita mulai dengan memasukkan sekumpulan data sederhana ke dalam Google Spreadsheet:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Buat Plot<\/strong><\/span><\/h3>\n

Selanjutnya, sorot sel dalam rentang A2:B16<\/strong> . Lalu klik tab Sisipkan<\/strong> di sepanjang pita atas, lalu klik Bagan<\/b> .<\/span><\/p>\n

Cloud titik berikut akan dibuat:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 3: Ubah Skala Sumbu<\/strong><\/span><\/h3>\n

Secara default, Google Spreadsheet akan memilih skala sumbu X dan Y yang berkisar dari nilai minimum hingga maksimum di setiap kolom.<\/span><\/p>\n

Untuk mengubah skala sumbu x, cukup klik dua kali nilai sumbu x mana pun.<\/span><\/p>\n

Ini akan memunculkan panel Chart Editor<\/strong> di sisi kanan layar.<\/span><\/p>\n

Di panel ini, Anda dapat mengklik tab Kustomisasi<\/strong> , lalu klik panah tarik-turun di samping Sumbu horizontal<\/strong> , lalu centang kotak di samping Skala logaritmik<\/strong> untuk mengubah sumbu X menjadi skala logaritmik:<\/span> <\/p>\n

\"Google<\/p>\n

Sumbu x secara otomatis akan diubah menjadi skala logaritmik:<\/span> <\/p>\n

\"\"<\/p>\n

Terkait:<\/strong> Kapan sebaiknya Anda menggunakan skala logaritmik dalam grafik?<\/a><\/span><\/p>\n

Anda juga dapat mengubah rentang nilai sumbu X.<\/span><\/p>\n

Misalnya, kita dapat memilih untuk menjadikan nilai maksimum pada sumbu x sama dengan 100:<\/span> <\/p>\n

\"Google<\/p>\n

Sumbu X pada grafik akan diperbarui secara otomatis:<\/span> <\/p>\n

\"\"<\/p>\n

Perhatikan bahwa dalam contoh ini kami memilih untuk hanya mengubah skala sumbu x.<\/span><\/p>\n

Namun, kita dapat dengan mudah mengubah skala sumbu Y dengan mengklik panah drop-down di sebelah sumbu vertikal<\/strong> di tab Kustomisasi<\/strong> pada panel Editor Bagan<\/strong> dan melakukan langkah yang sama seperti di bawah ini. -di atas.<\/span><\/p>\n

Sumber daya tambahan<\/strong><\/span><\/h3>\n

Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n

Bagaimana cara menambahkan label sumbu di Google Sheets<\/a>
Cara menggambar banyak garis di Google Sheets<\/a>
Bagaimana cara menambahkan label ke titik plot sebar di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Tutorial ini memberikan contoh langkah demi langkah tentang cara mengubah skala sumbu pada plot di Google Spreadsheet. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan sekumpulan data sederhana ke dalam Google Spreadsheet: Langkah 2: Buat Plot Selanjutnya, sorot sel dalam rentang A2:B16 . Lalu klik tab Sisipkan di sepanjang pita atas, lalu klik Bagan […]<\/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":"\nCara mengubah skala sumbu di plot Google Sheets \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah skala sumbu di plot Google Sheets, dengan sebuah 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\/google-sheet-mengubah-skala-sumbu\/\" \/>\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 Google Sheets \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah skala sumbu di plot Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T19:58:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-dechelle1.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\/google-sheet-mengubah-skala-sumbu\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/\",\"name\":\"Cara mengubah skala sumbu di plot Google Sheets \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T19:58:56+00:00\",\"dateModified\":\"2023-07-18T19:58:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah skala sumbu di plot Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengubah skala sumbu di plot google sheets\"}]},{\"@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 Google Sheets \u2013 Statorial","description":"Tutorial ini menjelaskan cara mengubah skala sumbu di plot Google Sheets, dengan sebuah 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\/google-sheet-mengubah-skala-sumbu\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengubah skala sumbu di plot Google Sheets \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara mengubah skala sumbu di plot Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/","og_site_name":"Statorials","article_published_time":"2023-07-18T19:58:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-dechelle1.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\/google-sheet-mengubah-skala-sumbu\/","url":"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/","name":"Cara mengubah skala sumbu di plot Google Sheets \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T19:58:56+00:00","dateModified":"2023-07-18T19:58:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah skala sumbu di plot Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengubah skala sumbu di plot google sheets"}]},{"@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\/3180"}],"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=3180"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3180\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}