{"id":1449,"date":"2023-07-26T08:38:21","date_gmt":"2023-07-26T08:38:21","guid":{"rendered":"https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/"},"modified":"2023-07-26T08:38:21","modified_gmt":"2023-07-26T08:38:21","slug":"tambahkan-garis-horizontal-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/","title":{"rendered":"Bagaimana cara menambahkan garis horizontal ke grafik di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Terkadang Anda mungkin ingin menambahkan garis horizontal ke bagan di Google Spreadsheet untuk mewakili garis target, garis rata-rata, atau metrik lainnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara menambahkan garis horizontal dengan cepat ke bagan di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk contoh ini, kami akan membuat kumpulan data palsu berikut yang menunjukkan total penjualan dan total target penjualan di lima wilayah berbeda untuk perusahaan tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14333 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilleslignehorizontale1.png\" alt=\"\" width=\"431\" height=\"374\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Bagan Kombo<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menyorot sel <strong>A1:C6<\/strong> sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-14334 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilleslignehorizontale2.png\" alt=\"\" width=\"398\" height=\"337\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <b>Sisipkan<\/b> . Kemudian klik <strong>Bagan<\/strong> di menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-14335 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontallinesheets3.png\" alt=\"\" width=\"438\" height=\"464\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada <strong>Chart Editor<\/strong> yang muncul di sebelah kanan, klik <strong>Chart Type<\/strong> dan pilih <strong>Combo Chart<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14336 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilleslignehorizontale4.png\" alt=\"\" width=\"263\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut akan muncul grafik yang menampilkan bar penjualan tiap wilayah dan garis horizontal yang menampilkan target penjualan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14337 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilleslignehorizontale5.png\" alt=\"Tambahkan garis horizontal ke bagan di Google Spreadsheet\" width=\"512\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bagan ini memungkinkan kita melihat dengan cepat wilayah mana yang memenuhi (atau melampaui) sasaran penjualan dan wilayah mana yang gagal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga dapat menyesuaikan warna dan gaya garis pada grafik. Misalnya, kita bisa mengubah garis menjadi ungu dan putus-putus:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14339 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilleslignehorizontale7.png\" alt=\"\" width=\"281\" height=\"482\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberikan baris berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14340 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontallinesheets8.png\" alt=\"\" width=\"515\" height=\"312\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Ubah Nilai Garis Horizontal (Opsional)<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Jika kita mengubah nilai pada kolom <strong>Goal<\/strong> , otomatis garis horizontal merah pada chart akan berubah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya kita mengubah target penjualan menjadi 45 pada kolom Target, maka garis merah otomatis berubah menjadi 45 pada grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14338 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horizontallinesheets6.png\" alt=\"Garis horizontal di Google Sheets dengan diagram batang\" width=\"660\" height=\"364\" srcset=\"\" sizes=\"\"><\/p>\n<hr>\n<h3> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tambahkan-garis-vertikal-google-sheet\/\">Bagaimana cara menambahkan garis vertikal ke grafik di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan bilah kesalahan ke bagan di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-tren-google\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis tren ke grafik 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>Terkadang Anda mungkin ingin menambahkan garis horizontal ke bagan di Google Spreadsheet untuk mewakili garis target, garis rata-rata, atau metrik lainnya. Tutorial ini memberikan contoh langkah demi langkah tentang cara menambahkan garis horizontal dengan cepat ke bagan di Google Spreadsheet. Langkah 1: Buat datanya Untuk contoh ini, kami akan membuat kumpulan data palsu berikut yang [&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 ke grafik di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan garis horizontal ke bagan 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\/tambahkan-garis-horizontal-google-sheet\/\" \/>\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 ke grafik di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan garis horizontal ke bagan di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T08:38:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilleslignehorizontale1.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\/tambahkan-garis-horizontal-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/\",\"name\":\"Cara menambahkan garis horizontal ke grafik di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T08:38:21+00:00\",\"dateModified\":\"2023-07-26T08:38:21+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan garis horizontal ke bagan di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan garis horizontal ke grafik di google sheets\"}]},{\"@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 ke grafik di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menambahkan garis horizontal ke bagan 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\/tambahkan-garis-horizontal-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menambahkan garis horizontal ke grafik di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menambahkan garis horizontal ke bagan di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-26T08:38:21+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilleslignehorizontale1.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\/tambahkan-garis-horizontal-google-sheet\/","url":"https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/","name":"Cara menambahkan garis horizontal ke grafik di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T08:38:21+00:00","dateModified":"2023-07-26T08:38:21+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan garis horizontal ke bagan di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tambahkan-garis-horizontal-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan garis horizontal ke grafik di google sheets"}]},{"@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\/1449"}],"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=1449"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1449\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}