{"id":3461,"date":"2023-07-17T09:01:04","date_gmt":"2023-07-17T09:01:04","guid":{"rendered":"https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/"},"modified":"2023-07-17T09:01:04","modified_gmt":"2023-07-17T09:01:04","slug":"label-data-khusus-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/","title":{"rendered":"Cara menambahkan label data khusus di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda sering kali ingin menambahkan label data khusus ke bagan di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dengan fitur <strong>Tambahkan Tag<\/strong> di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Tambahkan label data khusus ke Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut yang menunjukkan poin dan assist pemain bola basket dari tim berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28913 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laboratoire-personnalise1.jpg\" alt=\"\" width=\"523\" height=\"433\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin membuat diagram sebar dengan label khusus.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menyorot sel dalam rentang <strong>B2:C10<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>Bagan.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul grafik batang berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28914 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laboratoire-personnalise2.jpg\" alt=\"\" width=\"543\" height=\"344\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengubahnya menjadi diagram sebar, klik dua kali di mana saja pada grafik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>Chart Editor<\/strong> yang muncul, klik tab <strong>Configuration<\/strong> , lalu pilih <strong>Scatter Plot<\/strong> dari daftar drop-down di bawah <strong>Chart Type<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28915 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laboratoire-personnalise3.jpg\" alt=\"\" width=\"313\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Diagram batang akan diubah menjadi plot sebar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28916 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laboratoire-personnalise4.jpg\" alt=\"\" width=\"530\" height=\"332\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menambahkan label data khusus ke setiap titik, klik tiga titik vertikal di bawah <strong>Seri<\/strong> , lalu klik <strong>Tambahkan Label<\/strong> dari menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28917 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laboratoire-personnalise5.jpg\" alt=\"\" width=\"325\" height=\"575\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik kotak <strong>Label<\/strong> , lalu klik ikon kecil bertuliskan <strong>Select a data range<\/strong> , lalu ketik <strong>A2:A10<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28918 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laboratoire-personnalise6.jpg\" alt=\"\" width=\"579\" height=\"346\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , nama tim dalam rentang <strong>A2:A10<\/strong> akan digunakan sebagai label data untuk setiap titik pada plot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28919 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laboratoire-personnalise7.jpg\" alt=\"\" width=\"589\" height=\"382\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda mengubah nilai dalam rentang <strong>A2:A10<\/strong> , label data di plot juga akan berubah secara otomatis.<\/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 tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengubah-skala-sumbu\/\" target=\"_blank\" rel=\"noopener\">Cara mengubah skala sumbu di plot Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/label-sumbu-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan label sumbu di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-sumbu-y-kedua\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan sumbu Y kedua di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda sering kali ingin menambahkan label data khusus ke bagan di Google Spreadsheet. Untungnya, hal ini mudah dilakukan dengan fitur Tambahkan Tag di Google Spreadsheet. Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Tambahkan label data khusus ke Google Spreadsheet Katakanlah kita memiliki kumpulan data berikut yang menunjukkan poin dan assist pemain bola [&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 label data khusus di Google Spreadsheet \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan label data khusus pada bagan di Google Spreadsheet, beserta sebuah contoh.\" \/>\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\/label-data-khusus-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 label data khusus di Google Spreadsheet \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan label data khusus pada bagan di Google Spreadsheet, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T09:01:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laboratoire-personnalise1.jpg\" \/>\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\/label-data-khusus-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/\",\"name\":\"Cara menambahkan label data khusus di Google Spreadsheet \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T09:01:04+00:00\",\"dateModified\":\"2023-07-17T09:01:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan label data khusus pada bagan di Google Spreadsheet, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menambahkan label data khusus di google spreadsheet\"}]},{\"@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 label data khusus di Google Spreadsheet \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan label data khusus pada bagan di Google Spreadsheet, beserta sebuah contoh.","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\/label-data-khusus-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menambahkan label data khusus di Google Spreadsheet \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan label data khusus pada bagan di Google Spreadsheet, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-17T09:01:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laboratoire-personnalise1.jpg"}],"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\/label-data-khusus-google-sheet\/","url":"https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/","name":"Cara menambahkan label data khusus di Google Spreadsheet \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T09:01:04+00:00","dateModified":"2023-07-17T09:01:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan label data khusus pada bagan di Google Spreadsheet, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/label-data-khusus-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menambahkan label data khusus di google spreadsheet"}]},{"@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\/3461"}],"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=3461"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3461\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}