{"id":4809,"date":"2023-07-07T17:08:19","date_gmt":"2023-07-07T17:08:19","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/"},"modified":"2023-07-07T17:08:19","modified_gmt":"2023-07-07T17:08:19","slug":"excel-menambahkan-beberapa-garis-tren","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/","title":{"rendered":"Cara menambahkan beberapa garis tren di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menambahkan beberapa garis tren ke bagan di Excel untuk meringkas tren beberapa rangkaian.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda mungkin ingin membuat bagan berikut dengan beberapa garis tren yang merangkum tren dua penjualan produk berbeda dari waktu ke waktu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37541 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mtrend6.png\" alt=\"\" width=\"626\" height=\"423\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara membuat plot yang tepat dengan beberapa garis tren.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data berikut yang menunjukkan total penjualan dua produk berbeda selama 10 tahun berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37536 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance1.png\" alt=\"\" width=\"458\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Masukkan titik cloud<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>A1:C11<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Sebar<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16294 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/disperserexcel.png\" alt=\"\" width=\"566\" height=\"233\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara otomatis akan muncul point cloud berikut ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37537 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tendance2-1.png\" alt=\"\" width=\"525\" height=\"344\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Titik biru melambangkan penjualan tahunan produk A dan titik oranye melambangkan penjualan produk B setiap tahunnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Tambahkan Garis Tren<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik salah satu titik biru di jalur tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik tanda plus kecil berwarna hijau yang muncul di pojok kanan atas grafik, lalu klik panah drop-down di samping <strong>Garis Tren<\/strong> , lalu klik <strong>Opsi Lainnya<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37538 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mtend3.png\" alt=\"\" width=\"462\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Format Trendline<\/strong> yang muncul, klik tombol di samping <strong>Linear<\/strong> , lalu centang kotak di samping <strong>Show Equation on Chart<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37539 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mtend4.png\" alt=\"\" width=\"302\" height=\"558\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ulangi proses yang sama untuk titik oranye.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dua garis tren beserta persamaannya kini akan ditampilkan pada grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37540 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mtend5.png\" alt=\"\" width=\"541\" height=\"365\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Sesuaikan tampilan grafik<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, klik masing-masing label dalam legenda bernama <strong>Linear (Produk A)<\/strong> dan <strong>Linear (Produk B)<\/strong> dan hapus keduanya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian tambahkan judul bagan khusus, tambahkan label sumbu khusus, dan buat warna font persamaan garis tren menjadi tebal agar lebih mudah dibaca.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tabel terakhir akan terlihat seperti ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37541 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mtrend6.png\" alt=\"\" width=\"626\" height=\"423\" srcset=\"\" sizes=\"\"><\/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 Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/persamaan-garis-tren-excel-tanpa-grafik\/\" target=\"_blank\" rel=\"noopener\">Cara mencari persamaan garis tren tanpa grafik di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kemiringan-garis-tren-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menemukan Kemiringan Garis Tren di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-tren-kuadrat-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis tren kuadrat di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menambahkan beberapa garis tren ke bagan di Excel untuk meringkas tren beberapa rangkaian. Misalnya, Anda mungkin ingin membuat bagan berikut dengan beberapa garis tren yang merangkum tren dua penjualan produk berbeda dari waktu ke waktu: Contoh langkah demi langkah berikut menunjukkan cara membuat plot yang tepat dengan beberapa garis tren. Langkah [&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 di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke plot di Excel, termasuk contoh lengkapnya.\" \/>\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\/excel-menambahkan-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 di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke plot di Excel, termasuk contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T17:08:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mtrend6.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\/excel-menambahkan-beberapa-garis-tren\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/\",\"name\":\"Cara Menambahkan Beberapa Garis Tren di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T17:08:19+00:00\",\"dateModified\":\"2023-07-07T17:08:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke plot di Excel, termasuk contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menambahkan beberapa garis tren di 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 Menambahkan Beberapa Garis Tren di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke plot di Excel, termasuk contoh lengkapnya.","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\/excel-menambahkan-beberapa-garis-tren\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menambahkan Beberapa Garis Tren di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke plot di Excel, termasuk contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/","og_site_name":"Statorials","article_published_time":"2023-07-07T17:08:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mtrend6.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\/excel-menambahkan-beberapa-garis-tren\/","url":"https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/","name":"Cara Menambahkan Beberapa Garis Tren di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T17:08:19+00:00","dateModified":"2023-07-07T17:08:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan beberapa garis tren ke plot di Excel, termasuk contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menambahkan-beberapa-garis-tren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menambahkan beberapa garis tren di 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\/4809"}],"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=4809"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4809\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}