contador web Saltar al contenido

How to make Pareto chart in Excel | Productivity

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: DivulgaoLearn how to make Pareto diagram in Excel by PC Photo: Divulgao

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 BeggioraSelect the table with the data Photo: Reproduo / Helito Beggiora

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 BeggioraInserting Pareto chart Photo: Reproduo / Helito Beggiora

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 BeggioraCustomizing the chart Photo: Reproduo / Helito Beggiora

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

How to customize an Excel spreadsheet