The Pareto diagram is a type of column graph that sorts numbers downwards to prioritize more frequent problems. In Excel, the diagram can be made in a few clicks, simply and quickly. The program also allows you to customize the elements that appear in the diagram.
In the following tutorial, learn how to graph Pareto in Excel. The procedure was performed in the latest version of Office 2016, but the tips are also valid for users of previous editions of the Microsoft program.
Seven Excel functions that few people know
Learn how to make Pareto diagram in Excel by PC Photo: Divulgao
Want to buy cell phones, TV and other discounted products? Meet Compare TechTudo
Step 1. Select the table in which you want to create the Pareto diagram. Then, open the "Insert" tab;
Select the table with the data Photo: Reproduo / Helito Beggiora
Step 2. In the "Graphs" section, press the histogram icon and, in the window that appears, select the "Pareto" option;
Inserting Pareto chart Photo: Reproduo / Helito Beggiora
Step 3. The diagram will be inserted in the table. If you want, you can customize the elements that appear in the graph on the "+" button, located in the upper right corner of the diagram.
Customizing the chart Photo: Reproduo / Helito Beggiora
Ready! Take advantage of the tips to easily create Pareto diagrams in Excel.
How to convert a PDF file to Excel? Ask questions in the TechTudo forum.
How to customize an Excel spreadsheet