{"id":3999,"date":"2023-07-14T06:24:40","date_gmt":"2023-07-14T06:24:40","guid":{"rendered":"https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/"},"modified":"2023-07-14T06:24:40","modified_gmt":"2023-07-14T06:24:40","slug":"grafik-dengan-3-variabel-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/","title":{"rendered":"Cara membuat grafik tiga variabel di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Ada dua cara umum untuk membuat bagan dengan tiga variabel di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. Buat diagram garis dengan tiga garis<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2. Buat diagram batang dengan batang yang dikelompokkan<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara membuat dua bagan ini menggunakan kumpulan data berikut di Excel yang memperlihatkan penjualan tiga produk berbeda di tahun berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18058 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignes1-1.png\" alt=\"\" width=\"493\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Buat Bagan Garis dengan Tiga Garis<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan langkah-langkah berikut untuk memplot setiap penjualan produk sebagai garis pada grafik yang sama:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Sorot sel dalam rentang <strong>B1:D8<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Di grup <strong>Bagan<\/strong> , klik opsi bagan pertama di bagian berlabel <strong>Sisipkan bagan garis atau area<\/strong> .<\/span> <\/li>\n<\/ul>\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=\"588\" height=\"260\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18057\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignes2-1.png\" alt=\"Gambar beberapa garis di Excel\" width=\"672\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap baris mewakili penjualan salah satu dari tiga produk selama setiap tahun.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Buat Diagram Batang dengan Batang yang Dikelompokkan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan langkah-langkah berikut untuk memplot setiap penjualan produk sebagai batang pada grafik yang sama:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Sorot sel dalam rentang <strong>B1:D8<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Di grup <strong>Charts<\/strong> , klik opsi grafik pertama di bagian berlabel <strong>Sisipkan Kolom atau Bagan Batang<\/strong> .<\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30237 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diagramme-a-bandes.jpg\" alt=\"\" width=\"599\" height=\"143\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31991 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troisvar1.jpg\" alt=\"\" width=\"668\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap batang mewakili penjualan salah satu dari tiga produk setiap tahunnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin mengubah sumbu X untuk menampilkan tahun, cukup klik kanan pada sumbu X dan klik <strong>Pilih Data<\/strong> dari daftar drop-down.<\/span><\/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-31992 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troisvar2.jpg\" alt=\"\" width=\"563\" height=\"330\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian pilih <strong>A2:A8<\/strong> sebagai rentang label sumbu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31993 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troisvar3.jpg\" alt=\"\" width=\"329\" height=\"122\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengeklik <strong>OK<\/strong> , label sumbu X akan diperbarui untuk menampilkan tahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31994 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troisvar4.jpg\" alt=\"\" width=\"532\" height=\"388\" 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 membuat bagan umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Batang dan Daun di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grafik-titik-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Titik di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/plot-kotak-berdampingan-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Kotak Berdampingan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Ogive di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ada dua cara umum untuk membuat bagan dengan tiga variabel di Excel: 1. Buat diagram garis dengan tiga garis 2. Buat diagram batang dengan batang yang dikelompokkan Contoh berikut memperlihatkan cara membuat dua bagan ini menggunakan kumpulan data berikut di Excel yang memperlihatkan penjualan tiga produk berbeda di tahun berbeda: Contoh 1: Buat Bagan Garis [&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 Grafik Tiga Variabel di Excel (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat grafik tiga variabel di Excel, 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\/grafik-dengan-3-variabel-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Grafik Tiga Variabel di Excel (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat grafik tiga variabel di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T06:24:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignes1-1.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-dengan-3-variabel-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/\",\"name\":\"Cara Membuat Grafik Tiga Variabel di Excel (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T06:24:40+00:00\",\"dateModified\":\"2023-07-14T06:24:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat grafik tiga variabel di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat grafik tiga variabel di excel (dengan contoh)\"}]},{\"@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 Grafik Tiga Variabel di Excel (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara membuat grafik tiga variabel di Excel, 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\/grafik-dengan-3-variabel-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Grafik Tiga Variabel di Excel (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara membuat grafik tiga variabel di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-14T06:24:40+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignes1-1.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-dengan-3-variabel-excel\/","url":"https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/","name":"Cara Membuat Grafik Tiga Variabel di Excel (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T06:24:40+00:00","dateModified":"2023-07-14T06:24:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat grafik tiga variabel di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grafik-dengan-3-variabel-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat grafik tiga variabel di excel (dengan contoh)"}]},{"@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\/3999"}],"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=3999"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3999\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}