Create a histogram and Pareto chart in Excel:

1. Open Microsoft Excel
2. Enter data into the cells of a spreadsheet. Select the data to be used in the chart from the cells.
3. Click Insert tab at the top of the window and select Histogram or Pareto from the Charts group.
4. The Histogram or Pareto chart will appear in the spreadsheet window.
5. Choose Chart Tools tab from the top of the window if additional changes are required.