How to Create a Histogram Chart in Excel

Here we will discuss how to create a statistical chart called a Pareto Chart inside of Microsoft Excel.

Disclaimer- No safety hazards are present in this project.

1. A computer supporting Microsoft Windows 10
2. A valid subscription to Microsoft 365 containing Microsoft Excel
3. Data

Turn on your computer and click on the search bar, then click Excel.

Once open, click on the new workbook button located on the top left corner of the screen.

Start with added the first data input needed to create the Pareto Chart. The first data input is considered the X axis input.

Next add the second data input needed to create the Pareto Chart. This is considered the Y axis input.

Now highlight the two data inputs including the titles of each column. Start with the first column or the X axis and sweep to the second column or the Y axis.

Next, Click on the insert tab at the top of the page. Within the insert tab, click on the Insert Statistic Chart box. Then click on the His

Enjoy the valuable data that the Pareto Chart can provide.