{"id":2278,"date":"2023-07-22T23:29:26","date_gmt":"2023-07-22T23:29:26","guid":{"rendered":"https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/"},"modified":"2023-07-22T23:29:26","modified_gmt":"2023-07-22T23:29:26","slug":"bagan-kandil-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/","title":{"rendered":"Membuat bagan lilin di google spreadsheet (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/en.wikipedia.org\/wiki\/Candlestick_chart\" target=\"_blank\" rel=\"noopener\">Grafik candlestick<\/a> adalah jenis grafik keuangan yang menampilkan pergerakan harga sekuritas dari waktu ke waktu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara membuat grafik kandil di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan harga dari kumpulan data yang menunjukkan harga terendah, pembukaan, penutupan, dan tertinggi suatu saham selama periode 8 hari:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20739 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cand1.png\" alt=\"\" width=\"554\" height=\"443\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kolom Tanggal harus dalam format Plain Text. Jika tidak, cukup sorot kolom Tanggal, lalu klik tab <strong>Format<\/strong> , lalu <strong>Nomor<\/strong> , lalu <strong>Teks Biasa<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat grafik kandil<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot semua nilai pada rentang A1:E9 sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20740 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cand2.png\" alt=\"\" width=\"562\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik pada tab <strong>Sisipkan<\/strong> lalu klik pada <strong>Bagan<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20741 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cand3.png\" alt=\"\" width=\"555\" height=\"484\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Secara default, Google Spreadsheet harus membuat diagram kandil berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20742 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cand4.png\" alt=\"\" width=\"670\" height=\"509\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika Google Sheets membuat jenis bagan yang berbeda karena alasan tertentu, cukup klik tab <strong>Jenis Bagan<\/strong> di <strong>Editor Bagan<\/strong> dan gulir ke bawah hingga Anda melihat opsi <strong>Bagan Lilin<\/strong> dan klik di atasnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Edit Grafik Candlestick<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Silakan gunakan tab <strong>Kustomisasi<\/strong> pada <strong>Editor Bagan<\/strong> untuk mengedit judul bagan dan mengubah warna latar belakang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat mengubah judul menjadi &#8220;Harga Saham Harian&#8221; dan mengubah warna latar belakang menjadi abu-abu terang:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20743 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cand5.png\" alt=\"\" width=\"605\" height=\"376\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara membuat bagan 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\/bagan-pareto-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Pareto di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Grafik candlestick adalah jenis grafik keuangan yang menampilkan pergerakan harga sekuritas dari waktu ke waktu. Contoh langkah demi langkah berikut menunjukkan cara membuat grafik kandil di Google Spreadsheet. Langkah 1: Masukkan datanya Pertama, masukkan harga dari kumpulan data yang menunjukkan harga terendah, pembukaan, penutupan, dan tertinggi suatu saham selama periode 8 hari: Catatan : Kolom [&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>Membuat Bagan Lilin di Google Spreadsheet (Langkah demi Langkah) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat grafik candlestick di Google Sheets, 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\/bagan-kandil-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Membuat Bagan Lilin di Google Spreadsheet (Langkah demi Langkah) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat grafik candlestick di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T23:29:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cand1.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\/bagan-kandil-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/\",\"name\":\"Membuat Bagan Lilin di Google Spreadsheet (Langkah demi Langkah) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T23:29:26+00:00\",\"dateModified\":\"2023-07-22T23:29:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat grafik candlestick di Google Sheets, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Membuat bagan lilin di google spreadsheet (langkah demi langkah)\"}]},{\"@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":"Membuat Bagan Lilin di Google Spreadsheet (Langkah demi Langkah) - Statorial","description":"Tutorial ini menjelaskan cara membuat grafik candlestick di Google Sheets, 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\/bagan-kandil-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Membuat Bagan Lilin di Google Spreadsheet (Langkah demi Langkah) - Statorial","og_description":"Tutorial ini menjelaskan cara membuat grafik candlestick di Google Sheets, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-22T23:29:26+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cand1.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\/bagan-kandil-lembar-google\/","url":"https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/","name":"Membuat Bagan Lilin di Google Spreadsheet (Langkah demi Langkah) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T23:29:26+00:00","dateModified":"2023-07-22T23:29:26+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat grafik candlestick di Google Sheets, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bagan-kandil-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Membuat bagan lilin di google spreadsheet (langkah demi langkah)"}]},{"@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\/2278"}],"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=2278"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2278\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}