Frequency Histogram in Excel

What is a Frequency Histogram?

Like a histogram, frequency histograms show the spread or dispersion of data. Rather than sort the values into bins, a frequency histogram has one bin per value.

frequency histogram excel

A frequency histogram uses variable data to determine process capability. The customer's upper specification (USL) and lower specification limits (LSL) determine how well the process delivers on customer requirements.

In the frequency histogram graph above, all measurements fall between the LSL and USL which means that the process always delivers on the customer's requirements.

Why Use a Frequency Histogram?

Use a frequency histogram whenever the data has a limited number of specific values (e.g., 0.65, 0.60, 0.55). This will show exactly how many of each value are in the sample.

Why Choose QI Macros to Perform Capability Analysis and Draw Histograms?



  • Only $249 USD - less with quantity discounts
  • No annual fees
  • Free Technical Support

easy to use

Easy to Use

  • Works Right in Excel
  • Calculates Cp Cpk Pp Ppk
  • Accurate Results Without Worry

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free