Defect/call log pareto

MrClean760

New Member
Joined
Apr 25, 2020
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
I am in charge of all customer service. The business I work for has gone from 2000 units a year to 10000 a month over the weekend. You can imagine how many people I have calling a day. The boss wants a Pareto chart with numbers of defected parts for a week, I have those numbers I just don’t know how to do this cumulative percentage...He also wants to know how many people call, email, or submit tickets online and wanted to know of which did we fix over phone, fix by sending part, couldn’t fix had to replace.
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,396
Office Version
  1. 365
Platform
  1. MacOS
do you have the data in a spreadsheet and can you give an idea of layout
making a Parato chart is reasonably straight forward and quite a few tutorial on the web

How is this infor collated on a spreadsheet
again reasonably straight forward to setup and create a dashboard

He also wants to know how many people call, email, or submit tickets online and wanted to know of which did we fix over phone, fix by sending part, couldn’t fix had to replace.

If you can show the layout of data captured then we can setup some formulas
Countif() countifs() sumif() sumifs() maybe key functions to use
 

MrClean760

New Member
Joined
Apr 25, 2020
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
I’m not at my computer right now, but I do have a picture of the spreadsheet. Would that work?
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,396
Office Version
  1. 365
Platform
  1. MacOS
yes, can try and we can see how we get on
 

Watch MrExcel Video

Forum statistics

Threads
1,122,472
Messages
5,596,353
Members
414,060
Latest member
hermanseck

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top