{"id":780,"date":"2023-07-28T19:04:29","date_gmt":"2023-07-28T19:04:29","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-piramida-umur\/"},"modified":"2023-07-28T19:04:29","modified_gmt":"2023-07-28T19:04:29","slug":"excel-piramida-umur","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-piramida-umur\/","title":{"rendered":"Cara membuat piramida penduduk di excel"},"content":{"rendered":"

<\/p>\n

\n

Piramida penduduk<\/strong> adalah grafik yang menunjukkan sebaran umur dan jenis kelamin suatu penduduk. Hal ini berguna untuk memahami komposisi penduduk dan tren pertumbuhan penduduk.<\/span><\/p>\n

Tutorial ini menjelaskan cara membuat piramida penduduk berikut di Excel:<\/span> <\/p>\n

\"Piramida<\/p>\n

Contoh: Piramida usia di Excel<\/strong><\/span><\/h3>\n

Gunakan langkah-langkah berikut untuk membuat piramida populasi di Excel.<\/span><\/p>\n

Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n

Pertama, masukkan angka penduduk (menurut kelompok umur) laki-laki dan perempuan pada kolom terpisah:<\/span> <\/p>\n

\"Data<\/p>\n

Langkah 2: Hitung persentasenya.<\/strong><\/span><\/p>\n

Kemudian gunakan rumus berikut untuk menghitung persentase pria dan wanita:<\/span> <\/p>\n

\"Format<\/p>\n

Langkah 3: Sisipkan diagram batang bertumpuk 2D.<\/strong><\/span><\/p>\n

Selanjutnya, sorot sel D2:E:11. Di grup Charts<\/strong> pada tab Insert<\/strong> , klik opsi yang bertuliskan 2D Stacked Bar Chart<\/strong> :<\/span> <\/p>\n

\"Opsi<\/p>\n

Grafik berikut akan otomatis muncul:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 4: Ubah tampilan piramida penduduk.<\/strong><\/span><\/p>\n

Terakhir, kita akan mengubah tampilan piramida usia agar terlihat lebih baik.<\/span><\/p>\n

Hapus lebar ruang.<\/strong><\/span><\/p>\n

    \n
  • Klik kanan bilah mana pun pada grafik. Lalu klik Format Seri Data\u2026<\/strong><\/span><\/li>\n
  • Ubah Lebar Celah<\/strong> menjadi 0%.<\/span> <\/li>\n<\/ul>\n

    \"\"<\/p>\n

    Tambahkan batas hitam ke setiap bilah.<\/strong><\/span><\/p>\n

      \n
    • Klik pada ikon ember cat.<\/span><\/li>\n
    • Klik Perbatasan<\/strong> . Kemudian klik Garis Berkelanjutan<\/strong> .<\/span><\/li>\n
    • Ubah warnanya menjadi hitam.<\/span> <\/li>\n<\/ul>\n

      \"\"<\/p>\n

      Tampilkan label sumbu X sebagai angka positif.<\/strong><\/span><\/p>\n

        \n
      • Klik kanan pada sumbu x. Lalu klik Format Sumbu\u2026<\/strong><\/span><\/li>\n
      • KlikNomor<\/strong> .<\/span><\/li>\n
      • Di bawah Format Code<\/strong> , ketik 0.0;[Black]0.0<\/strong> dan klik Add<\/strong> .<\/span> <\/li>\n<\/ul>\n

        \"\"<\/p>\n

        Pindahkan sumbu vertikal ke kiri grafik.<\/strong><\/span><\/p>\n

          \n
        • Klik kanan pada sumbu Y. Kemudian klik Format Sumbu\u2026<\/strong><\/span><\/li>\n
        • Klik Label<\/strong> . Atur posisi label<\/strong> ke Rendah<\/strong> .<\/span> <\/li>\n<\/ul>\n

          \"\"<\/p>\n

          Ubah judul dan warna bagan sesuai kebutuhan. Klik juga salah satu garis kisi vertikal dan klik Hapus.<\/strong><\/span><\/p>\n

          Hasil akhirnya akan terlihat seperti ini:<\/span> <\/p>\n

          \"Piramida<\/p>\n","protected":false},"excerpt":{"rendered":"

          Piramida penduduk adalah grafik yang menunjukkan sebaran umur dan jenis kelamin suatu penduduk. Hal ini berguna untuk memahami komposisi penduduk dan tren pertumbuhan penduduk. Tutorial ini menjelaskan cara membuat piramida penduduk berikut di Excel: Contoh: Piramida usia di Excel Gunakan langkah-langkah berikut untuk membuat piramida populasi di Excel. Langkah 1: Masukkan datanya. Pertama, masukkan angka […]<\/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":"\nCara Membuat Piramida Penduduk di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat piramida penduduk 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\/excel-piramida-umur\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Piramida Penduduk di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat piramida penduduk di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-piramida-umur\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T19:04:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poppyramideexcel8.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\/excel-piramida-umur\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-piramida-umur\/\",\"name\":\"Cara Membuat Piramida Penduduk di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T19:04:29+00:00\",\"dateModified\":\"2023-07-28T19:04:29+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat piramida penduduk di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-piramida-umur\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-piramida-umur\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-piramida-umur\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat piramida penduduk di excel\"}]},{\"@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 Piramida Penduduk di Excel - Statologi","description":"Penjelasan sederhana cara membuat piramida penduduk 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\/excel-piramida-umur\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Piramida Penduduk di Excel - Statologi","og_description":"Penjelasan sederhana cara membuat piramida penduduk di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/excel-piramida-umur\/","og_site_name":"Statorials","article_published_time":"2023-07-28T19:04:29+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poppyramideexcel8.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\/excel-piramida-umur\/","url":"https:\/\/statorials.org\/id\/excel-piramida-umur\/","name":"Cara Membuat Piramida Penduduk di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T19:04:29+00:00","dateModified":"2023-07-28T19:04:29+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat piramida penduduk di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-piramida-umur\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-piramida-umur\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-piramida-umur\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat piramida penduduk di excel"}]},{"@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\/780"}],"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=780"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/780\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=780"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=780"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}