Cara Membuat Diagram Pareto Menggunakan MS Excel 2010

Analisis Pareto adalah teknik sederhana untuk memprioritaskan potensi penyebab dengan cara mengidentifikasi masalah. Artikel ini memberikan panduan cara membuat Diagram Pareto menggunakan MS Excel 2010.

Langkah

Unduh PDF

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a3\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-1-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a3\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-1-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

1
Identifikasi dan buat daftar masalah. Buat daftar seluruh elemen data/item kerja yang harus Anda prioritaskan menggunakan Prinsip Pareto. Hasilnya akan tampak seperti ini.
- Jika Anda tidak memiliki data untuk latihan, gunakan data yang tampak pada gambar dan cobalah membuat Diagram Pareto seperti yang ditunjukkan dalam gambar.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/19\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-2-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-2-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/19\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-2-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Dalam contoh ini, “ Hair Fall Reason ” (Penyebab Kerontokan Rambut) berdasarkan “ Frequency ” (Frekuensi).
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/19\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-3-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-3-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/19\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-3-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

3
Tambahkan kolom untuk Frekuensi Kumulatif atau “ Cumulative Frequency ”. Gunakan formula seperti yang ditunjukkan dalam gambar.
- Sekarang, tabel Anda seharusnya terlihat seperti ini.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3d\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-4-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-4-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3d\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-4-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

4
Hitung angka total pada “ Frequency ” (Frekuensi) dan tambahkan kolom “ Percentage ” (Persentase).
- Pastikan nilai total sama dengan nilai akhir dalam kolom Cumulative Frequency .
- Sekarang, tabel data Anda sudah lengkap dan Anda siap membuat Diagram Pareto. Data Anda seharusnya terlihat seperti ini.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fb\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-5-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-5-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fb\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-5-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8d\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-6-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-6-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8d\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-6-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-6-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Klik kanan pada area diagram dan “ Select Data ”.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e5\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-7-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-7-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e5\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-7-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

7
Pilih kolom B1 sampai C9. Tik koma (,) dan pilih kolom E1 sampai E9.
- Ini adalah salah satu langkah penting, Anda harus melakukannya dengan cermat untuk memastikan Anda telah memasukkan rentang data yang tepat ke dalam Diagram Pareto.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/16\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-8-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-8-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/16\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-8-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Frekuensi ditunjukkan dengan batang biru dan persentase digambarkan oleh batang merah.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/26\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-9-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-9-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/26\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-9-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

9
Pilih salah satu batang persentase dan klik kanan. Klin “ Change Series Chart Type ” menjadi “ Line with Markers ”.
- Layar seperti ini akan muncul.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/96\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-10-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-10-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/96\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-10-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

10
Sekarang, Diagram Anda akan tampak seperti ini.
- Batang persentase sekarang berubah menjadi diagram garis.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/97\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-11-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/97\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-11-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

11
Pilih dan klik kanan pada garis Merah untuk Persentase dan Klik “ Format Data Series ”.
- Layar Format Data Series akan terbuka, kemudian pilih " Secondary Axis ".
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/0f\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-12-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-12-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0f\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-12-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

12
Sumbu "Y" kedua akan muncul.
- Satu-satunya masalah dengan Diagram Pareto ini adalah Sumbu “Y” yang menunjukkan angka 120%. Isu ini perlu diperbaiki. Anda bisa saja tidak menemukan masalah ini.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/ed\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-13-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ed\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-13-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

13
Pilih Sumbu Y kedua. Klik kanan dan pilih " Format Axis ".
- Pilih “ Axis Options ” pada kotak dialog " Format Data Series " dan ubah nilai " Maximum " menjadi 1.0.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/be\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-14-Version-2.jpg\/v4-460px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/be\/Create-a-Pareto-Chart-in-MS-Excel-2010-Step-14-Version-2.jpg\/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

14
Diagram Pareto Anda telah selesai dibuat dan seharusnya tampak seperti ini.
- Namun, Anda tetap dapat menambahkan detail yang membuat Diagram Pareto Anda lebih menarik.
  Pilih “ Chart Tools ” --> “ Layout ”. Anda dapat menambahkan Chart Title atau Judul Diagram, Axis Title atau Nama Sumbu, Legend atau Legenda dan Data Tables atau Tabel Data jika Anda menginginkannya.
Iklan

Peringatan

Data yang ditunjukkan dalam Diagram Pareto ini hanyalah referensi.

Masuk

Cara Membuat Diagram Pareto Menggunakan MS Excel 2010

Langkah

Peringatan

wikiHow Terkait

Tentang wikiHow ini

Apakah artikel ini membantu Anda?

Artikel Terkait

Ikuti kami

Bagikan

Explore Categories