How Do I Create a Pareto Chart in Microsoft Excel?
According to QAProject.org, a Pareto chart displays the relative importance of events according to categories. A Pareto chart provides a tool to evaluate and set priorities because it presents the categories in order of frequency and the importance of the events as a line graph. You can organize and sort data in an Excel spreadsheet before preparing a combination chart containing bars and lines for a Pareto chart.
