How to customize an Excel spreadsheet

How to make Pareto chart in Excel

The Pareto diagram is a type of column chart that sorts numbers downwards to prioritize more frequent problems. In Excel, the diagram can be done 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 carried out in the latest version of Office 2016, but the tips also apply to users of previous editions of the Microsoft program.

Seven Excel functions that few people know

1 of 4 Learn how to make Pareto diagram in Excel from PC – Photo: Disclosure

Learn how to make Pareto diagram in Excel by PC – Photo: Disclosure

Want to buy cell phones, TV and other discounted products? Discover Compare

Step 1. Select the table in which you want to create the Pareto diagram. Then, open the “Insert” tab;

2 of 4 Select the table with the data – Photo: Reproduction / Helito Beggiora

Select the table with the data – Photo: Reproduction / Helito Beggiora

Step 2. In the “Graphics” section, press the histogram icon and, in the window that appears, select the “Pareto” option;

3 of 4 Inserting Pareto chart – Photo: Reproduction / Helito Beggiora

Inserting Pareto chart – Photo: Reproduction / Helito Beggiora

Step 3. The diagram will be inserted in the table. If you want, you can customize the elements that appear on the graph in the “+” button, located in the upper right corner of the diagram.

4 of 4 Customizing the graphic – Photo: Reproduction / Helito Beggiora

Customizing the graphic – Photo: Reproduction / 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 Forum.

How to customize an Excel spreadsheet

How to customize an Excel spreadsheet