{"id":4689,"date":"2023-07-08T22:39:13","date_gmt":"2023-07-08T22:39:13","guid":{"rendered":"https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/"},"modified":"2023-07-08T22:39:13","modified_gmt":"2023-07-08T22:39:13","slug":"grafik-excel-rata-rata-min-maks","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/","title":{"rendered":"Excel: cara membuat min max dan rata-rata grafik"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat bagan di Excel yang menampilkan nilai minimum, maksimum, dan rata-rata untuk grup berbeda,<\/span> <span style=\"color: #000000;\">mirip dengan bagan di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36618\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minmax7.png\" alt=\"Tabel rata-rata min maks Excel\" width=\"532\" height=\"344\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari kita masukkan dataset berikut yang berisi nilai poin minimum, maksimum, dan rata-rata pemain dari berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36612 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minmax1.png\" alt=\"\" width=\"494\" height=\"389\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Sisipkan bagan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Berikutnya, sorot cell range <strong>A1:F4<\/strong> , lalu klik tab <strong>Insert<\/strong> di sepanjang pita bagian atas, lalu klik ikon bernama <strong>Waterfall<\/strong> di grup <strong>Charts<\/strong> , lalu klik ikon bernama <strong>High-Low-Close<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36613 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minmax2.png\" alt=\"\" width=\"466\" height=\"317\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Grafik berikut akan dibuat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36614 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minmax3.png\" alt=\"\" width=\"544\" height=\"341\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Umumnya, jenis grafik ini digunakan untuk menampilkan harga tertinggi, terendah, dan penutupan harian suatu saham, namun kita dapat menggunakannya untuk menampilkan nilai minimum, maksimum, dan rata-rata untuk kelompok yang berbeda.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan grafik<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kemudian kita dapat menyesuaikan grafiknya agar lebih mudah dibaca.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, klik pada garis mana pun pada grafik. Di panel Format yang muncul di sisi kanan layar, klik daftar drop-down di sebelah <strong>Mulai Jenis Panah<\/strong> dan klik <strong>Panah Oval<\/strong> . Ulangi untuk <strong>tipe panah akhir<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Poin untuk nilai minimum dan maksimum akan lebih besar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36615 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minmax4.png\" alt=\"\" width=\"562\" height=\"349\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, klik salah satu lingkaran kecil yang berada di tengah salah satu garis.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Pada panel <strong>Format Data Series<\/strong> yang muncul di sisi kanan layar, klik ikon bernama <strong>Marker<\/strong> , lalu di bawah <strong>Marker Options<\/strong> , pilih kotak untuk <strong>Type<\/strong> dan ubah <strong>Size<\/strong> menjadi 6:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36616 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minmax5.png\" alt=\"\" width=\"334\" height=\"475\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lingkaran kecil di tengah tiap garis sekarang akan menjadi persegi yang lebih besar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36617 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minmax6.png\" alt=\"\" width=\"546\" height=\"340\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, sesuaikan nama judul, tambahkan label sumbu, dan hapus legenda di bagian bawah bagan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36618\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minmax7.png\" alt=\"Tabel rata-rata min maks Excel\" width=\"532\" height=\"344\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bagan sekarang lebih mudah dibaca dan diinterpretasikan.<\/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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/menggambar-banyak-garis-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menggambar banyak garis di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/diagram-batang-bertumpuk-berkerumun-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Batang Bertumpuk Berkelompok di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Scatter Plot dengan Beberapa Seri di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membuat bagan di Excel yang menampilkan nilai minimum, maksimum, dan rata-rata untuk grup berbeda, mirip dengan bagan di bawah ini: Contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Langkah 1: Masukkan datanya Pertama, mari kita masukkan dataset berikut yang berisi nilai poin minimum, maksimum, dan rata-rata pemain [&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>Excel: Cara Membuat Min Max dan Rata-Rata Grafik - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat grafik min maks dan rata-rata di Excel, termasuk 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\/grafik-excel-rata-rata-min-maks\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Membuat Min Max dan Rata-Rata Grafik - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat grafik min maks dan rata-rata di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T22:39:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minmax7.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-excel-rata-rata-min-maks\/\",\"url\":\"https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/\",\"name\":\"Excel: Cara Membuat Min Max dan Rata-Rata Grafik - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T22:39:13+00:00\",\"dateModified\":\"2023-07-08T22:39:13+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat grafik min maks dan rata-rata di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara membuat min max dan rata-rata grafik\"}]},{\"@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":"Excel: Cara Membuat Min Max dan Rata-Rata Grafik - Statorials","description":"Tutorial ini menjelaskan cara membuat grafik min maks dan rata-rata di Excel, termasuk 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\/grafik-excel-rata-rata-min-maks\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Membuat Min Max dan Rata-Rata Grafik - Statorials","og_description":"Tutorial ini menjelaskan cara membuat grafik min maks dan rata-rata di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/","og_site_name":"Statorials","article_published_time":"2023-07-08T22:39:13+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minmax7.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-excel-rata-rata-min-maks\/","url":"https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/","name":"Excel: Cara Membuat Min Max dan Rata-Rata Grafik - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T22:39:13+00:00","dateModified":"2023-07-08T22:39:13+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat grafik min maks dan rata-rata di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grafik-excel-rata-rata-min-maks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara membuat min max dan rata-rata grafik"}]},{"@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\/4689"}],"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=4689"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4689\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}