{"id":3002,"date":"2023-07-19T16:54:03","date_gmt":"2023-07-19T16:54:03","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/"},"modified":"2023-07-19T16:54:03","modified_gmt":"2023-07-19T16:54:03","slug":"google-sheet-beberapa-garis-tren","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/","title":{"rendered":"Bagaimana cara menambahkan beberapa garis tren ke grafik di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara membuat grafik di Google Spreadsheet dengan beberapa garis tren.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan beberapa nilai yang menunjukkan total penjualan dua produk berbeda di tahun berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25905 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance-multiple1.jpg\" alt=\"\" width=\"479\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat bagan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk membuat bagan guna memvisualisasikan penjualan setiap produk berdasarkan tahun, sorot nilai dalam rentang A1:C11. Kemudian klik pada tab <strong>Sisipkan<\/strong> lalu klik pada <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25906 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance-multiple2.jpg\" alt=\"\" width=\"482\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara default, Google Spreadsheet akan menyisipkan diagram garis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25907 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance-multiple3.jpg\" alt=\"\" width=\"547\" height=\"343\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengubahnya menjadi plot sebar, klik tab <strong>Penyetelan<\/strong> di panel <strong>editor bagan<\/strong> dan pilih <strong>Plot Sebar<\/strong> sebagai jenis bagan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25908 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance-multiple4.jpg\" alt=\"\" width=\"321\" height=\"413\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Grafik secara otomatis akan diubah menjadi diagram sebar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25909 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance-multiple5.jpg\" alt=\"\" width=\"557\" height=\"350\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Titik biru melambangkan penjualan produk A setiap tahunnya dan titik merah melambangkan penjualan produk B setiap tahunnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan Beberapa Garis Tren<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Chart Editor<\/strong> yang muncul di sisi kanan layar, lakukan hal berikut untuk menambahkan garis tren ke titik-titik biru:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Klik tab <strong>Sesuaikan<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kemudian klik pada daftar drop-down <strong>Seri<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Lalu pilih <strong>Produk A Penjualan<\/strong> dari daftar drop-down.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kemudian centang kotak di sebelah <strong>Trendline<\/strong> .<\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25910 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance-multiple6.jpg\" alt=\"\" width=\"316\" height=\"718\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ulangi proses ini, namun pilih <strong>Penjualan Produk B<\/strong> dari daftar drop-down:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25911 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance-multiple7.jpg\" alt=\"\" width=\"315\" height=\"716\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Garis tren untuk penjualan Produk A dan penjualan Produk B akan ditambahkan ke grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25913\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance-multiple8.jpg\" alt=\"Google Sheets beberapa garis tren\" width=\"588\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa di tab <strong>Kustomisasi<\/strong> , Anda juga dapat mengubah warna, ketebalan garis, dan opasitas setiap garis tren.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa Google Spreadsheet menggunakan garis tren linier secara default, namun di tab <strong>Sesuaikan<\/strong> Anda juga dapat memilih untuk menggunakan garis tren eksponensial, polinomial, atau lainnya.<\/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 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-gelembung-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Gelembung di Google Spreadsheet<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/diagram-lingkaran-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Diagram Lingkaran di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Pareto di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contoh langkah demi langkah berikut menunjukkan cara membuat grafik di Google Spreadsheet dengan beberapa garis tren. Langkah 1: Masukkan datanya Pertama, masukkan beberapa nilai yang menunjukkan total penjualan dua produk berbeda di tahun berbeda: Langkah 2: Buat bagan Untuk membuat bagan guna memvisualisasikan penjualan setiap produk berdasarkan tahun, sorot nilai dalam rentang A1:C11. Kemudian 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 menambahkan beberapa garis tren ke grafik di Google Spreadsheet \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet, 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-beberapa-garis-tren\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T16:54:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance-multiple1.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-beberapa-garis-tren\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/\",\"name\":\"Cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T16:54:03+00:00\",\"dateModified\":\"2023-07-19T16:54:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan beberapa garis tren ke grafik 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 menambahkan beberapa garis tren ke grafik di Google Spreadsheet \u2013 Statorial","description":"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet, 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-beberapa-garis-tren\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/","og_site_name":"Statorials","article_published_time":"2023-07-19T16:54:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance-multiple1.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-beberapa-garis-tren\/","url":"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/","name":"Cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T16:54:03+00:00","dateModified":"2023-07-19T16:54:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan beberapa garis tren ke grafik 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\/3002"}],"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=3002"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3002\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}