How to Build a Pareto Diagram in Excel
- 1). Visit the Microsoft Templates website and type "Pareto" into the "Search Templates" text box. Click "Search" to bring up a list of results.
- 2). Click the "Pareto Analysis" icon and then click the green "Download" button to the right of the page. Follow the prompts to download the Pareto chart to your computer.
- 3). Open Microsoft Excel.
- 4). Replace the data in the spreadsheet with your own data for the chart. To replace text, click a cell and type a data item. Enter one data item per cell. Data should be grouped in descending order. The Pareto chart will update the chart dynamically as you type.
- 5). Type category names into the "Category" cells. Enter one category per cell.
Source...