{"id":2839,"date":"2023-07-20T11:32:23","date_gmt":"2023-07-20T11:32:23","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/"},"modified":"2023-07-20T11:32:23","modified_gmt":"2023-07-20T11:32:23","slug":"google-sheet-sumbu-y-kedua","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/","title":{"rendered":"Bagaimana cara menambahkan sumbu y kedua di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan berikut di Google Spreadsheet dengan sumbu Y sekunder:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24863\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seconde1.jpg\" alt=\"sumbu Y kedua di Google Sheets\" width=\"566\" height=\"341\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan data berikut yang menunjukkan total penjualan dan total pengembalian berbagai produk:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24864 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seconde2.jpg\" alt=\"\" width=\"561\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat bagan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot sel dalam rentang <strong>A1:C8<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24865 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seconde3.jpg\" alt=\"\" width=\"495\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Google Sheets secara otomatis akan memasukkan diagram batang berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24866 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seconde4.jpg\" alt=\"\" width=\"583\" height=\"354\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan Sumbu Y Kedua<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Ikuti langkah-langkah berikut untuk menambahkan sumbu Y kedua ke sisi kanan bagan:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Klik panel <strong>Chart Editor<\/strong> di sisi kanan layar.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kemudian klik pada tab <strong>Kustomisasi<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kemudian klik menu tarik-turun <strong>Seri<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kemudian pilih \u201cReturns\u201d sebagai serinya.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Lalu klik panah tarik-turun di bawah <strong>Sumbu<\/strong> dan pilih <strong>Sumbu Kanan<\/strong> :<\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24867\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seconde5.jpg\" alt=\"Google Spreadsheet menambahkan sumbu Y kedua\" width=\"337\" height=\"699\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Sumbu berikut secara otomatis akan muncul di sisi kanan grafik:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24868 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seconde6.jpg\" alt=\"\" width=\"572\" height=\"347\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu kanan menunjukkan nilai <strong>pengembalian<\/strong> sedangkan sumbu kiri menunjukkan nilai <strong>penjualan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memperjelas sumbu mana yang mewakili seri data tertentu, klik dua kali sumbu kanan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Chart Editor<\/strong> , klik tombol &#8220;B&#8221; di bawah <strong>Label Format<\/strong> untuk membuat nilai sumbu menjadi tebal, lalu pilih warna merah sebagai <strong>warna teks<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24869 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seconde7.jpg\" alt=\"\" width=\"312\" height=\"556\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ulangi proses untuk sumbu kiri, tapi pilih biru sebagai <strong>warna teks<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Warna sumbu akan diperbarui secara otomatis pada grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24863\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seconde1.jpg\" alt=\"sumbu Y kedua di Google Sheets\" width=\"566\" height=\"341\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang jelas bahwa sumbu kiri mewakili nilai <strong>Penjualan<\/strong> sedangkan sumbu kanan mewakili nilai <strong>Pengembalian<\/strong> .<\/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 membuat visualisasi umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Kotak di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Pareto di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-area-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Area di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Gelembung di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan berikut di Google Spreadsheet dengan sumbu Y sekunder: Langkah 1: Buat datanya Pertama, masukkan data berikut yang menunjukkan total penjualan dan total pengembalian berbagai produk: Langkah 2: Buat bagan Selanjutnya, sorot sel dalam rentang A1:C8 , lalu klik tab Sisipkan , lalu Bagan : [&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 menambahkan sumbu Y kedua di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan sumbu Y kedua ke bagan di Google Spreadsheet, 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\/google-sheet-sumbu-y-kedua\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menambahkan sumbu Y kedua di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan sumbu Y kedua ke bagan di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T11:32:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seconde1.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-sumbu-y-kedua\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/\",\"name\":\"Cara menambahkan sumbu Y kedua di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T11:32:23+00:00\",\"dateModified\":\"2023-07-20T11:32:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan sumbu Y kedua ke bagan di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan sumbu y kedua di 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 menambahkan sumbu Y kedua di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menambahkan sumbu Y kedua ke bagan di Google Spreadsheet, 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\/google-sheet-sumbu-y-kedua\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menambahkan sumbu Y kedua di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menambahkan sumbu Y kedua ke bagan di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/","og_site_name":"Statorials","article_published_time":"2023-07-20T11:32:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seconde1.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-sumbu-y-kedua\/","url":"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/","name":"Cara menambahkan sumbu Y kedua di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T11:32:23+00:00","dateModified":"2023-07-20T11:32:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan sumbu Y kedua ke bagan di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan sumbu y kedua di 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\/2839"}],"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=2839"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2839\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}