Produce a Pareto Chart using Excel
springbird
paretochartfoodservicecomplaints.xlsxSheet1
| Complaint type | Count | Cumulative Count | Cumulative % |
| Wait time | 60 | 60 | 47 |
| Soup not hot | 30 | 90 | 71 |
| Food too salty | 10 | 100 | 79 |
| Food portion too small | 5 | 105 | 83 |
| Food items overpriced | 6 | 111 | 87 |
| Salad not fresh | 7 | 118 | 93 |
| Staff not well trained | 9 | 127 | 100 |
0 0 0 0 60 0 30 0 10 0 5 0 6 0 7 0 9 5 0 47.244094488188978 70.866141732283467 78.740157480314963 82.677165354330711 87.4015748031496 92.913385826771659 100 0
