{"id":1947,"date":"2023-10-26T16:23:45","date_gmt":"2023-10-26T16:23:45","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/diagram-piramida\/"},"modified":"2023-12-06T06:13:17","modified_gmt":"2023-12-06T06:13:17","slug":"diagram-piramida","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/diagram-piramida\/","title":{"rendered":"Bagaimana cara membuat bagan piramida penduduk di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1513530047\"><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>Bagan piramida penduduk adalah bagan khusus yang membantu kita menyajikan dan menganalisis populasi kedua jenis kelamin menggunakan kelompok umur.<\/p><blockquote class=\"wp-block-quote\"><p> Piramida penduduk, disebut juga piramida penduduk atau gambar umur, adalah ilustrasi grafis yang menunjukkan sebaran kelompok umur berbeda dalam suatu penduduk, yang berbentuk piramida seiring dengan bertambahnya jumlah penduduk. Di Excel, kita bisa membuat diagram piramida penduduk menggunakan diagram batang, seperti di bawah ini.<\/p> <cite>Wikipedia<\/cite> <\/blockquote><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-graphique-pyramidal-des-ages-dans-Excel-de-differentes-manieres-1.gif\" sizes=\"\" srcset=\"\" alt=\"buat bagan piramida usia di Excel dengan berbagai cara\"><\/figure><\/div><p> Masukkan diagram batang, lalu lakukan sedikit penyesuaian, itu saja.<\/p><p> Tapi inilah twistnya. Saya menemukan bahwa selain metode tradisional ini, kita juga dapat menggunakan dua metode berbeda. Dan hari ini di artikel ini, saya ingin berbagi tiga metode [langkah tepat] ini dengan Anda. Jadi, mari kita mulai.<\/p><h2 class=\"wp-block-heading\"> Langkah Sederhana Membuat Bagan Piramida Penduduk Menggunakan Bagan Batang<\/h2><p> Sebelum membuat grafik ini, kita perlu menyiapkan datanya. Pada tabel jumlah penduduk, penduduk perempuan bernilai negatif dan penduduk laki-laki bernilai positif. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-de-donnees-pour-creer-un-diagramme-de-pyramide-des-ages-dans-excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"tabel data untuk membuat diagram piramida penduduk di excel\"><\/figure><\/div><p class=\"qt-tip\"> <strong><span style=\"color: #000000; background-color: #ffff00;\">Catatan:<\/span><\/strong> Kolom total populasi tidak wajib diisi tetapi pastikan Anda memiliki populasi perempuan negatif.<\/p><ol><li> <strong>Pertama<\/strong> kita perlu memasukkan diagram batang. Untuk melakukannya, pilih kolom data kelompok umur, perempuan dan laki-laki dan sisipkan diagram batang dari tab Sisipkan \u279c Bagan \u279c Batang 2D \u279c Batang yang Dikelompokkan.<\/li><li> Sekarang kita memiliki grafik seperti di bawah ini dan selanjutnya kita perlu menyesuaikannya untuk membuat piramida penduduk. <br><img decoding=\"async\" title=\"masukkan diagram batang untuk membuat diagram piramida populasi di Excel-min\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-un-graphique-a-barres-pour-creer-un-graphique-en-pyramide-des-ages-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"insert a bar chart to create a population pyramid chart in excel\"><\/li><li> Dari sini kita perlu membuat sumbu vertikal dalam urutan terbalik dan dari sana pergi ke Format Sumbu \u279c Opsi Sumbu \u279c Posisi Sumbu \u279c centang \u201cKategori dalam Urutan Terbalik\u201d. <br><img decoding=\"async\" title=\"terapkan-urutan-terbalik-untuk-membuat-bagan-piramida-populasi-di-excel-min\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-lordre-inverse-pour-creer-un-graphique-de-pyramide-des-ages-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"apply reverse order to create a population pyramid chart in excel\"><\/li><li> Setelah itu, masuk ke Format Axis \u279c Axis Options \u279c Labels \u279c ubah posisi label menjadi \u201cLow\u201d. <br><img decoding=\"async\" title=\"ubah-tabel-untuk-membuat-grafik-piramida-populasi-di-excel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/changer-letiquette-pour-creer-un-graphique-pyramidal-des-ages-dans-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"change label to create a population pyramid chart in excel\"><\/li><li> Selanjutnya, kita perlu mengubah Series Overlap menjadi 100% dan Gap width menjadi 0%. Untuk melakukan ini, buka Format Sumbu \u279c Opsi Seri. <br><img decoding=\"async\" title=\"ubah-lebar-untuk-membuat-bagan-piramida-populasi-di-excel-min\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modifier-la-largeur-pour-creer-un-graphique-pyramidal-des-ages-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"change width to create a population pyramid chart in excel\"><\/li><li> Pada akhirnya, kita perlu mengubah label data negatif untuk bilah data perempuan menjadi label positif. Untuk ini, pilih label data dan buka Format Label Data \u279c Opsi Label \u279c Pilih Nomor Kustom dari kategori dan tambahkan dalam format \u201c#,##0.00;#,##0.00\u201d. <br><img decoding=\"async\" title=\"format-data-label-sebagai-angka-positif-dalam-bagan-piramida-populasi-excel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formater-letiquette-de-donnees-sous-forme-de-nombres-positifs-dans-le-graphique-de-la-pyramide-des-ages-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"format data label as positive numbers in excel population pyramid chart\"><\/li><\/ol><p> <strong><span style=\"color: #000000; background-color: #ffff00;\">Selamat!<\/span><\/strong> Bagan piramida kami siap beraksi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/diagramme-de-pyramide-des-ages-pret-a-lemploi-dans-excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"diagram piramida usia siap pakai di excel\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gunakan Pemformatan Bersyarat untuk Membuat Bagan Piramida di Excel<\/h2><p> Kita juga dapat membuat bagan piramida menggunakan pemformatan bersyarat dan berikut langkah-langkah yang harus diikuti.<\/p><ol><li> Pertama, buatlah tabel berisi data penduduk laki-laki dan perempuan beserta kelompok umur. <br><img decoding=\"async\" title=\"tabel-data-untuk-membuat-bagan-piramida-populasi-di-excel-dengan-format-bersyarat\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-de-donnees-pour-creer-un-graphique-en-pyramide-des-ages-dans-Excel-avec-mise-en-forme-conditionnelle.png\" sizes=\"\" srcset=\"\" alt=\"data table to create a population pyramid chart in excel with conditional formatting\"><\/li><li> Selanjutnya, pilih satu kolom pria atau wanita dan terapkan bilah data pemformatan bersyarat dari tab Beranda \u279c Gaya \u279c Bilah Data \u279c Aturan Lainnya.<\/li><li> Setelah itu, dalam dialog pemformatan baru, centang kotak &#8220;Tampilkan bilah saja&#8221;, tambahkan batas padat dan ubah arah bilah (bilah betina dan jantan harus berada di arah yang berlawanan). <br><img decoding=\"async\" title=\"tampilkan-bar-hanya-untuk-membuat-bagan-piramida-populasi-di-Excel-dengan-format-bersyarat\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/afficher-les-barres-uniquement-pour-creer-un-graphique-en-pyramide-des-ages-dans-Excel-avec-une-mise-en-forme-conditionnelle.png\" sizes=\"\" srcset=\"\" alt=\"show bars only to create a population pyramid chart in excel with conditional formatting\"><\/li><li> Sekarang pilih kolom data kedua dan tambahkan bilah data ke dalamnya dengan cara yang sama, dan Anda akan mendapatkan diagram piramida seperti di bawah ini. <br><img decoding=\"async\" title=\"tabel-piramida-populasi-sederhana-di-excel-dengan-format-bersyarat\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/graphique-de-pyramide-des-ages-simple-dans-excel-avec-mise-en-forme-conditionnelle-1.png\" sizes=\"\" srcset=\"\" alt=\"simple population pyramid chart in excel with conditional formatting\"><\/li><li> Pada akhirnya, untuk sentuhan akhir, tambahkan dua kolom di kedua sisi bagan untuk menambahkan label data.<\/li><\/ol><p> <strong><span style=\"color: #000000; background-color: #ffff00;\">Ledakan!<\/span><\/strong> Meja kami sudah siap. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/graphique-pyramidal-des-ages-final-dans-excel-avec-mise-en-forme-conditionnelle-1.png\" sizes=\"\" srcset=\"\" alt=\"bagan piramida usia akhir di excel dengan format kondisional\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Buat Bagan Piramida Populasi di Sel di Excel<\/h2><p> Saya penggemar berat REPT dan hal terbaiknya adalah Anda dapat menggunakannya untuk membuat piramida populasi sederhana.<\/p><ol><li> Pertama, buat tabel seperti di bawah ini. <br><img decoding=\"async\" title=\"tabel-data-untuk-digunakan-untuk-membuat-bagan-piramida-populasi-di-excel-menggunakan-fungsi-rept\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-a-utiliser-pour-creer-un-graphique-pyramidal-des-ages-dans-Excel-a-laide-de-la-fonction-rept-1.png\" sizes=\"\" srcset=\"\" alt=\"data table to use to create population pyramid chart in excel using rept function\"><\/li><li> Sekarang tambahkan rumus di bawah ini pada kolom perempuan dan laki-laki dan seret ke bawah.<pre> Female Column: =IFERROR(REPT(\u201c|\u201d,C5*4),\u201d\u201d)<\/pre><pre> Male Column: =IFERROR(REPT(\u201c|\u201d,F5*4),\u201d\u201d)<\/pre><\/li><li> Setelah itu ubah gaya font menjadi Playbill (Font Size \u2013 10) atau bisa juga menggunakan Stencil (Font Size \u2013 10).<\/li><li> Terakhir, ubah warna font untuk kedua kolom dan ratakan kolom perempuan di kanan dan kolom laki-laki di kiri.<\/li><\/ol><p> Papan sudah siap. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/diagramme-de-pyramide-des-ages-simple-dans-excel-utilisant-la-fonction-rept-1.png\" sizes=\"\" srcset=\"\" alt=\"bagan-piramida-populasi-sederhana-di-excel-menggunakan-fungsi-rept\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Contoh berkas<\/h2><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/diagramme-pyramidal-2.zip\" rel=\"nofollow\">Unduh file contoh ini di sini<\/a><\/p><h2 class=\"wp-block-heading\"> Kesimpulan<\/h2><p> Anda mungkin bertanya-tanya bahwa bagan piramida hanya untuk demografi, namun kenyataannya Anda dapat menggunakannya untuk semua jenis data.<\/p><p> Kapan pun Anda perlu membandingkan titik data yang berbeda untuk dua periode berbeda, sebaiknya gunakan diagram piramida, misalnya data penjualan produk berbeda selama dua tahun.<\/p><p> Ini adalah salah satu daftar <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/grafis-tingkat-lanjut\/\">tabel dan bagan Excel tingkat lanjut<\/a> saya. Saya harap tip ini bermanfaat bagi Anda, tetapi beri tahu saya satu hal.<\/p><p> <strong>Pernahkah Anda menggunakan diagram piramida?<\/strong> Atau, apakah Anda punya cara lain untuk membuatnya?<\/p><p> Bagikan pemikiran Anda dengan saya di bagian komentar, saya ingin mendengar pendapat Anda. Dan jangan lupa untuk membagikan tip ini kepada teman-teman Anda.<\/p><div class=\"gb-container gb-container-a61970aa gb-container-mt\"> <a class=\"gb-button gb-button-b4293c6c gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/grafik-excel\/\">Jenis Bagan Excel<\/a><h2 class=\"gb-headline gb-headline-5bf2e581 gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-9b70abf1 gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-97a95c29\"><div class=\"gb-container gb-container-97a95c29\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/grafis-wafel\/\">PAPAN TIMBUL<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bagan-corong\/\">Bagan corong<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/grafik-gantt\/\">Bagan Gantt<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/papan-peluru\/\">Bagan peluru<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/peta-panas\/\">Peta panas<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","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-1947","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>Bagaimana cara membuat diagram piramida penduduk di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara membuat diagram piramida penduduk di Excel dalam 8 langkah sederhana.\" \/>\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\/diagram-piramida\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membuat diagram piramida penduduk di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara membuat diagram piramida penduduk di Excel dalam 8 langkah sederhana.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/diagram-piramida\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-graphique-pyramidal-des-ages-dans-Excel-de-differentes-manieres-1.gif\" \/>\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=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/diagram-piramida\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/diagram-piramida\/\",\"name\":\"Bagaimana cara membuat diagram piramida penduduk di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/diagram-piramida\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/diagram-piramida\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-graphique-pyramidal-des-ages-dans-Excel-de-differentes-manieres-1.gif\",\"datePublished\":\"2023-10-26T16:23:45+00:00\",\"dateModified\":\"2023-12-06T06:13:17+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara membuat diagram piramida penduduk di Excel dalam 8 langkah sederhana.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/diagram-piramida\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/diagram-piramida\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/diagram-piramida\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-graphique-pyramidal-des-ages-dans-Excel-de-differentes-manieres-1.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-graphique-pyramidal-des-ages-dans-Excel-de-differentes-manieres-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/diagram-piramida\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat bagan piramida penduduk 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":"Bagaimana cara membuat diagram piramida penduduk di Excel?","description":"Dalam tutorial ini, kita akan mempelajari cara membuat diagram piramida penduduk di Excel dalam 8 langkah sederhana.","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\/diagram-piramida\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membuat diagram piramida penduduk di Excel?","og_description":"Dalam tutorial ini, kita akan mempelajari cara membuat diagram piramida penduduk di Excel dalam 8 langkah sederhana.","og_url":"https:\/\/exceladvisor.org\/id\/diagram-piramida\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:17+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-graphique-pyramidal-des-ages-dans-Excel-de-differentes-manieres-1.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/diagram-piramida\/","url":"https:\/\/exceladvisor.org\/id\/diagram-piramida\/","name":"Bagaimana cara membuat diagram piramida penduduk di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/diagram-piramida\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/diagram-piramida\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-graphique-pyramidal-des-ages-dans-Excel-de-differentes-manieres-1.gif","datePublished":"2023-10-26T16:23:45+00:00","dateModified":"2023-12-06T06:13:17+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara membuat diagram piramida penduduk di Excel dalam 8 langkah sederhana.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/diagram-piramida\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/diagram-piramida\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/diagram-piramida\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-graphique-pyramidal-des-ages-dans-Excel-de-differentes-manieres-1.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-graphique-pyramidal-des-ages-dans-Excel-de-differentes-manieres-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/diagram-piramida\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat bagan piramida penduduk 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\/1947","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=1947"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1947\/revisions"}],"predecessor-version":[{"id":2278,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1947\/revisions\/2278"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}