{"id":4676,"date":"2023-07-09T01:36:41","date_gmt":"2023-07-09T01:36:41","guid":{"rendered":"https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/"},"modified":"2023-07-09T01:36:41","modified_gmt":"2023-07-09T01:36:41","slug":"plot-deret-waktu-di-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/","title":{"rendered":"Cara merencanakan deret waktu di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara memplot deret waktu berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36516 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/serie4.png\" alt=\"\" width=\"599\" height=\"378\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 1: Masukkan data deret waktu<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nilai berikut untuk kumpulan data deret waktu ke dalam Google Spreadsheet:<\/span> <\/p>\n<h2><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36513 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/serie1-1.png\" alt=\"\" width=\"503\" height=\"536\" srcset=\"\" sizes=\"\"><\/h2>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Bagan Garis<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot nilai dalam rentang <strong>A2:B20<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>Bagan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Grafik garis berikut akan muncul secara default:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36514 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/serie2-1.png\" alt=\"\" width=\"573\" height=\"363\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Ubah Bagan Garis menjadi Plot Deret Waktu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Klik dua kali di mana saja pada bagan untuk menampilkan panel <strong>Editor Bagan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik pada tab <b>Konfigurasi<\/b> , lalu gulir ke bawah ke bagian bernama Lainnya dan klik ikon bernama <strong>Timeline Chart<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36515 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/serie3.png\" alt=\"\" width=\"270\" height=\"547\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Grafik deret waktu berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36516 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/serie4.png\" alt=\"\" width=\"599\" height=\"378\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x menunjukkan tanggal dan sumbu y menunjukkan penjualan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa pemilih rentang tanggal secara otomatis disertakan di bagian bawah diagram sehingga Anda dapat dengan mudah memperbesar rentang tanggal yang berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda memilih untuk menonaktifkan fitur ini, Anda dapat melakukannya di tab <strong>Kustomisasi<\/strong> pada panel <strong>Editor Bagan<\/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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/\" target=\"_blank\" rel=\"noopener\">Cara mengubah skala sumbu di plot Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memplot-beberapa-baris\/\" target=\"_blank\" rel=\"noopener\">Cara menggambar banyak garis di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/label-sebaran-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan label ke titik plot sebar di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial ini memberikan contoh langkah demi langkah tentang cara memplot deret waktu berikut di Google Spreadsheet: Ayo pergi! Langkah 1: Masukkan data deret waktu Mari kita mulai dengan memasukkan nilai berikut untuk kumpulan data deret waktu ke dalam Google Spreadsheet: Langkah 2: Buat Bagan Garis Selanjutnya, sorot nilai dalam rentang A2:B20 , lalu klik tab [&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 merencanakan deret waktu di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat deret waktu 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\/plot-deret-waktu-di-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara merencanakan deret waktu di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat deret waktu di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T01:36:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/serie4.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\/plot-deret-waktu-di-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/\",\"name\":\"Cara merencanakan deret waktu di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T01:36:41+00:00\",\"dateModified\":\"2023-07-09T01:36:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat deret waktu di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara merencanakan deret waktu di google spreadsheet\"}]},{\"@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 merencanakan deret waktu di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara membuat deret waktu 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\/plot-deret-waktu-di-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara merencanakan deret waktu di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara membuat deret waktu di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-09T01:36:41+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/serie4.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\/plot-deret-waktu-di-lembar-google\/","url":"https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/","name":"Cara merencanakan deret waktu di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T01:36:41+00:00","dateModified":"2023-07-09T01:36:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat deret waktu di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/plot-deret-waktu-di-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara merencanakan deret waktu di google spreadsheet"}]},{"@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\/4676"}],"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=4676"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4676\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}