Create a Pareto Chart Use the excel template, Paretochart. to create the chart. Customer Complaints Frequency f Week Customer is on hold too long _ Customer gets transferred to wrong area or cut off Service rep cannot answer custom er's questions Service rep does not follow through as promised Compile your results on one sheet using excel, highlighnng the prots for each scenario and what your time is worth