{"id":1487,"date":"2023-11-22T08:15:52","date_gmt":"2023-11-22T08:15:52","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/grafik-excel\/"},"modified":"2023-12-06T06:20:19","modified_gmt":"2023-12-06T06:20:19","slug":"grafik-excel","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/grafik-excel\/","title":{"rendered":"Jenis bagan di excel"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2201957729\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Microsoft Excel menawarkan berbagai tipe bagan yang bisa Anda gunakan untuk mewakili data Anda secara visual. Berikut adalah beberapa jenis bagan umum yang tersedia di Excel:<\/p><h2> Jenis grafik Excel <\/h2><p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13432\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel.jpg\" alt=\"Jenis grafik Excel\" width=\"2050\" height=\"1177\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel.jpg 2050w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel-300x172.jpg 300w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel-1024x588.jpg 1024w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel-768x441.jpg 768w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel-1536x882.jpg 1536w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel-2048x1176.jpg 2048w\" sizes=\"auto, (max-width: 2050px) 100vw, 2050px\"><\/p><h3> Bagan kolom:<\/h3><ul><li> Menampilkan data dalam kolom vertikal. Cocok untuk membandingkan nilai dari berbagai kategori.<\/li><\/ul><h3> Grafik batang:<\/h3><ul><li> Mirip dengan histogram tetapi menampilkan data dalam bentuk batang horizontal.<\/li><li> Berguna untuk membandingkan nilai dari berbagai kategori.<\/li><\/ul><h3> Grafik daring:<\/h3><ul><li> Mewakili titik data dengan garis, berguna untuk menunjukkan tren selama periode waktu tertentu.<\/li><li> Biasa digunakan untuk data deret waktu.<\/li><\/ul><h3> Diagram lingkaran:<\/h3><ul><li> Menampilkan data sebagai potongan diagram lingkaran.<\/li><li> Cocok untuk menunjukkan proporsi bagian terhadap keseluruhan.<\/li><\/ul><h3> Meja donat:<\/h3><ul><li> Mirip dengan diagram lingkaran tetapi dengan lubang di tengahnya.<\/li><li> Berguna untuk membandingkan proporsi di beberapa seri data.<\/li><\/ul><h3> Bagan wilayah:<\/h3><ul><li> Mirip dengan diagram garis tetapi mengisi area di bawah garis.<\/li><li> Berguna untuk menampilkan total kuantitas yang berjalan dari waktu ke waktu.<\/li><\/ul><h3> Awan titik:<\/h3><ul><li> Menampilkan titik data individual pada grafik dua dimensi.<\/li><li> Berguna untuk menunjukkan hubungan antara dua variabel.<\/li><\/ul><h3> Bagan gelembung:<\/h3><ul><li> Mirip dengan plot sebar tetapi mencakup dimensi ketiga, yang diwakili oleh ukuran gelembung.<\/li><li> Berguna untuk memvisualisasikan tiga set data.<\/li><\/ul><h3> Peta radar:<\/h3><ul><li> Menampilkan titik data pada kisi melingkar.<\/li><li> Berguna untuk membandingkan beberapa kumpulan data dalam kategori berbeda.<\/li><\/ul><h3> Grafik saham:<\/h3><ul><li> Dirancang khusus untuk menampilkan data pasar saham, menunjukkan harga tertinggi, terendah, pembukaan dan penutupan dari waktu ke waktu.<\/li><\/ul><h3> Grafik luas:<\/h3><ul><li> Mewakili data dalam format tiga dimensi, berguna untuk memvisualisasikan hubungan antara tiga kumpulan data.<\/li><\/ul><h3> Bagan gabungan:<\/h3><ul><li> Memungkinkan Anda menggabungkan berbagai jenis bagan pada bagan yang sama.<\/li><\/ul><h3> Histogram:<\/h3><ul><li> Mewakili distribusi data dalam satu set.<\/li><li> Berguna untuk menampilkan frekuensi data dalam rentang yang telah ditentukan.<\/li><\/ul><h3> Bagan Gantt:<\/h3><ul><li> Menampilkan garis waktu proyek, menampilkan tugas dan ketergantungannya dari waktu ke waktu.<\/li><\/ul><h3> Bagan air terjun:<\/h3><ul><li> Mengilustrasikan bagaimana nilai awal dipengaruhi oleh serangkaian nilai antara positif atau negatif.<\/li><\/ul><p> Untuk membuat bagan di Excel, pilih data Anda, buka tab \u201cSisipkan\u201d dan pilih jenis bagan yang paling sesuai dengan kebutuhan Anda. Excel kemudian akan menghasilkan grafik berdasarkan data Anda.<\/p><h2> Panduan Bagan Excel Ilustratif<\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/grafis-wafel\/\">Buat BAGAN WAFFLE di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/salin-format-bagan\/\">Salin format bagan<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/bagan-corong\/\">Bagan corong di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/grafik-gantt\/\">Bagan Gantt di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/tambahkan-garis-horizontal\/\">Garis horizontal dalam bagan di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/tambahkan-garis-vertikal\/\">Garis vertikal dalam bagan di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/papan-peluru\/\">Bagan Peluru di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/rentang-grafik-dinamis\/\">Rentang grafik dinamis di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/judul-grafik-dinamis\/\">Judul bagan dinamis di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/peta-panas\/\">Peta panas di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/bagan-tonggak-sejarah\/\">Tabel langkah-langkah di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/diagram-piramida\/\">Bagan piramida populasi di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/tabel-langkah\/\">Tabel langkah-langkah di Excel<\/a><\/li><\/ul><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/grafik-tornado\/\">Bagan Tornado di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/grafik-interaktif\/\">Bagan interaktif di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/bagan-orang\/\">Bagan Orang di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/grafis-tingkat-lanjut\/\">Bagan Excel Tingkat Lanjut<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/\" data-wpil=\"url\">Tambahkan sumbu sekunder ke bagan di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/histogram\/\">Histogram di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/piktogram\/\">Piktogram di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/speedometer\/\" data-wpil=\"url\">Bagan SPEEDOMETER di Excel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/meja-termometer\/\">Tabel termometer di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tabel-pivot-2\/\">Tabel Pivot di Excel<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1487","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Jenis-Jenis Chart di Excel (Panduan Lengkap 2023)<\/title>\n<meta name=\"description\" content=\"Microsoft Excel menawarkan berbagai tipe bagan yang bisa Anda gunakan untuk mewakili data Anda secara visual.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/grafik-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Jenis-Jenis Chart di Excel (Panduan Lengkap 2023)\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel menawarkan berbagai tipe bagan yang bisa Anda gunakan untuk mewakili data Anda secara visual.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/grafik-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/grafik-excel\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/grafik-excel\/\",\"name\":\"\u25b7 Jenis-Jenis Chart di Excel (Panduan Lengkap 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/grafik-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/grafik-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel.jpg\",\"datePublished\":\"2023-11-22T08:15:52+00:00\",\"dateModified\":\"2023-12-06T06:20:19+00:00\",\"description\":\"Microsoft Excel menawarkan berbagai tipe bagan yang bisa Anda gunakan untuk mewakili data Anda secara visual.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/grafik-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/grafik-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/grafik-excel\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel.jpg\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/grafik-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jenis bagan di excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Jenis-Jenis Chart di Excel (Panduan Lengkap 2023)","description":"Microsoft Excel menawarkan berbagai tipe bagan yang bisa Anda gunakan untuk mewakili data Anda secara visual.","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:\/\/exceladvisor.org\/id\/grafik-excel\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Jenis-Jenis Chart di Excel (Panduan Lengkap 2023)","og_description":"Microsoft Excel menawarkan berbagai tipe bagan yang bisa Anda gunakan untuk mewakili data Anda secara visual.","og_url":"https:\/\/exceladvisor.org\/id\/grafik-excel\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:19+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/grafik-excel\/","url":"https:\/\/exceladvisor.org\/id\/grafik-excel\/","name":"\u25b7 Jenis-Jenis Chart di Excel (Panduan Lengkap 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/grafik-excel\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/grafik-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel.jpg","datePublished":"2023-11-22T08:15:52+00:00","dateModified":"2023-12-06T06:20:19+00:00","description":"Microsoft Excel menawarkan berbagai tipe bagan yang bisa Anda gunakan untuk mewakili data Anda secara visual.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/grafik-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/grafik-excel\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/grafik-excel\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel.jpg","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/Type-de-graphiques-Excel.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/grafik-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Jenis bagan di excel"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1487"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1487\/revisions"}],"predecessor-version":[{"id":2911,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1487\/revisions\/2911"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}