{"id":4900,"date":"2023-07-06T16:08:50","date_gmt":"2023-07-06T16:08:50","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/"},"modified":"2023-07-06T16:08:50","modified_gmt":"2023-07-06T16:08:50","slug":"excel-menambahkan-garis-horizontal-ke-grafik-garis","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/","title":{"rendered":"Bagaimana cara menambahkan garis horizontal ke diagram garis di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menambahkan garis horizontal ke diagram garis di Excel untuk mewakili ambang batas atau batas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara cepat menambahkan garis horizontal ke diagram garis apa pun 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 menunjukkan total penjualan yang dilakukan oleh suatu perusahaan selama 20 tahun berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38268 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-supplementaire1.png\" alt=\"\" width=\"482\" height=\"493\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Tambahkan Nilai untuk Garis Horizontal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menambahkan kolom baru yang berisi nilai garis horizontal untuk ditempatkan di diagram garis kita.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, perusahaan mempunyai sasaran penjualan sebesar 100 total penjualan setiap tahunnya dan kita ingin menempatkan garis horizontal pada y = 100 pada bagan kita untuk mewakili sasaran ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menambahkan kolom berikut ke dataset kita yang hanya berisi nilai 100 di setiap baris:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38269 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-supplementaire2.png\" alt=\"\" width=\"479\" height=\"516\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Sisipkan diagram garis<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>B1:C21<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Garis<\/strong> 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=\"582\" height=\"257\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Grafik garis berikut akan dibuat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38270 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-supplementaire3.png\" alt=\"\" width=\"513\" height=\"321\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Garis biru menunjukkan penjualan aktual setiap tahunnya dan garis oranye menunjukkan target penjualan setiap tahunnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Sesuaikan bagan (opsional)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, silakan tambahkan judul, tambahkan label sumbu, dan sesuaikan warna dan lebar garis untuk membuat bagan lebih estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38271\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-supplementaire4.png\" alt=\"Excel menambahkan garis ke diagram garis\" width=\"568\" height=\"359\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan:<\/strong> Jika Anda ingin menambahkan beberapa garis horizontal ke satu bagan, cukup ulangi proses ini menggunakan nilai y yang berbeda.<\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-menambahkan-garis-rata-rata-ke-diagram-batang\/\" target=\"_blank\" rel=\"noopener\">Cara Menambahkan Garis Rata-Rata ke Diagram Batang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis regresi ke scatterplot di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menambahkan garis horizontal ke diagram garis di Excel untuk mewakili ambang batas atau batas. Tutorial ini memberikan contoh langkah demi langkah tentang cara cepat menambahkan garis horizontal ke diagram garis apa pun di Excel. Langkah 1: Masukkan datanya Pertama, mari buat kumpulan data berikut yang menunjukkan total penjualan yang dilakukan oleh [&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 garis horizontal pada diagram garis di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan garis horizontal pada diagram garis di Excel, beserta 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-garis-horizontal-ke-grafik-garis\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menambahkan garis horizontal pada diagram garis di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan garis horizontal pada diagram garis di Excel, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T16:08:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-supplementaire1.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-garis-horizontal-ke-grafik-garis\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/\",\"name\":\"Cara menambahkan garis horizontal pada diagram garis di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T16:08:50+00:00\",\"dateModified\":\"2023-07-06T16:08:50+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan garis horizontal pada diagram garis di Excel, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan garis horizontal ke diagram garis 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 menambahkan garis horizontal pada diagram garis di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menambahkan garis horizontal pada diagram garis di Excel, beserta 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-garis-horizontal-ke-grafik-garis\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menambahkan garis horizontal pada diagram garis di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menambahkan garis horizontal pada diagram garis di Excel, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/","og_site_name":"Statorials","article_published_time":"2023-07-06T16:08:50+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne-supplementaire1.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-garis-horizontal-ke-grafik-garis\/","url":"https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/","name":"Cara menambahkan garis horizontal pada diagram garis di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T16:08:50+00:00","dateModified":"2023-07-06T16:08:50+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan garis horizontal pada diagram garis di Excel, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menambahkan-garis-horizontal-ke-grafik-garis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan garis horizontal ke diagram garis 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\/4900"}],"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=4900"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4900\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}