See Figure 3.Ĭhoose the first Histogram option. On the Insert tab ribbon, click the Insert Statistical Chart button. Let’s say that you have certification exam scores for a team of employees. For example, you can have a list of employees and their sales commissions, a list of grades or scores, or even percentages. If you would like, Excel can even choose your intervals. You just need the list of data points and the ranges (or bin numbers) that show the interval for Excel to measure. The resulting histogram or Pareto appears as a column chart. Sometimes a histogram is called a Pareto, which is a sorted histogram. A histogram is used to show frequency within groups. Have you ever had data in Excel from a survey or sales commissions? You can analyze them by displaying the data in a histogram.
