{"id":4747,"date":"2023-07-08T08:40:16","date_gmt":"2023-07-08T08:40:16","guid":{"rendered":"https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/"},"modified":"2023-07-08T08:40:16","modified_gmt":"2023-07-08T08:40:16","slug":"grafik-garis-ganda-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/","title":{"rendered":"Cara membuat bagan garis ganda di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin memplot dua garis dalam grafik yang sama di Excel untuk membandingkan dua kelompok berbeda dari waktu ke waktu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda mungkin ingin membandingkan penjualan dua produk berbeda dalam periode yang sama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37069 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dline7.png\" alt=\"\" width=\"570\" height=\"377\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan dengan tepat cara membuat bagan jenis ini di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data berikut yang berisi informasi total penjualan dua produk berbeda selama sepuluh tahun berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37063 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne1.png\" alt=\"\" width=\"461\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Sisipkan grafik garis<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat diagram garis ganda untuk memvisualisasikan penjualan setiap produk selama periode 10 tahun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, sorot sel dalam rentang <strong>B1:C11<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon bagan <strong>garis<\/strong> pertama di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27125 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/graphique-en-ligne.jpg\" alt=\"\" width=\"514\" height=\"227\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Akan muncul grafik garis berikut:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37064 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dline2.png\" alt=\"\" width=\"516\" height=\"320\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Garis biru menunjukkan penjualan tahunan produk A dan garis oranye menunjukkan penjualan tahunan produk B.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan Kutu Sumbu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Saat ini, tanda centang sumbu x berkisar antara <strong>1<\/strong> hingga <strong>10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, katakanlah kita ingin mereka menampilkan tahun <strong>2010<\/strong> hingga <b>2019<\/b> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengubah tanda centang, klik kanan salah satu nilai sumbu x, lalu klik <strong>Pilih Data<\/strong> dari menu drop-down:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37065 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dline3.png\" alt=\"\" width=\"520\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik tombol <strong>Edit<\/strong> di bawah <strong>Label Sumbu Horizontal<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37066 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dline4.png\" alt=\"\" width=\"606\" height=\"344\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, pilih <strong>A2:A11<\/strong> sebagai rentang label sumbu, lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37067 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dline5.png\" alt=\"\" width=\"391\" height=\"140\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x pada grafik akan diperbarui untuk menunjukkan tahun dari 2010 hingga 2019:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37068 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dline6.png\" alt=\"\" width=\"558\" height=\"344\" 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, silakan edit label judul dan sumbu, lalu klik masing-masing baris untuk mengubah warnanya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Seperti inilah tabel akhirnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37069 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dline7.png\" alt=\"\" width=\"570\" height=\"377\" 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> <a href=\"https:\/\/statorials.org\/id\/label-plot-sebar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menambahkan Label ke Scatterplot Point di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-excel-yang-paling-cocok\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Garis yang Paling Sesuai di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menambahkan-garis-target-ke-grafik\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis target ke grafik di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin memplot dua garis dalam grafik yang sama di Excel untuk membandingkan dua kelompok berbeda dari waktu ke waktu. Misalnya, Anda mungkin ingin membandingkan penjualan dua produk berbeda dalam periode yang sama: Contoh langkah demi langkah berikut ini memperlihatkan dengan tepat cara membuat bagan jenis ini di Excel. Langkah 1: Masukkan datanya [&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 Membuat Diagram Garis Ganda di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram garis ganda di Excel, 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\/grafik-garis-ganda-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Diagram Garis Ganda di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram garis ganda di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T08:40:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dline7.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\/grafik-garis-ganda-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/\",\"name\":\"Cara Membuat Diagram Garis Ganda di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T08:40:16+00:00\",\"dateModified\":\"2023-07-08T08:40:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram garis ganda di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bagan garis ganda di excel\"}]},{\"@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 Membuat Diagram Garis Ganda di Excel - Statorials","description":"Tutorial ini menjelaskan cara membuat diagram garis ganda di Excel, 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\/grafik-garis-ganda-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Diagram Garis Ganda di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara membuat diagram garis ganda di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-08T08:40:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dline7.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\/grafik-garis-ganda-excel\/","url":"https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/","name":"Cara Membuat Diagram Garis Ganda di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T08:40:16+00:00","dateModified":"2023-07-08T08:40:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram garis ganda di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grafik-garis-ganda-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bagan garis ganda di excel"}]},{"@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\/4747"}],"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=4747"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4747\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}