Tired of Trying to Make Histograms in Excel?

Save time with QI Macros easy-to-use add-in for Excel

Let's face it. Excel's Data Analysis Toolpak is cumbersome and the output is fairly basic. It's missing a curve line, spec limits (aka goalposts) and process capability metrics that provide insights into your data.

Up your data analysis game using QI Macros histogram maker.


What is a Histogram? Why Do They Matter?

Histograms show the spread, or dispersion, of variable data. They are most valuable when they display your customer's requirements as goal posts. Does your data fit or not? Is it centered?

anatomy of a histogram created by QI Macros in Excel 2016

Go Deeper

Experts refer to these goal posts as specification limits. There can be both an upper spec limit (USL) and a lower spec limit (LSL) or just one of the two. Data points outside of the spec limits represent products or processes that don't meet customer requirements.

The best histogram maker's will also calculate process capability metrics Cp, Cpk and Pp Ppk. These are numeric values that tell you how well your process is meeting customer requirements.


How Does QI Macros Histogram Maker Work?

QI Macros adds a new tab to Excel's menu:

  1. Point – Just select your data in an Excel worksheet.
  2. Click – on QI Macros menu in Excel and choose Histograms & Capability, then Histogram with Cp Cpk.
  3. Analyze and Improve – QI Macros will prompt you for spec limits, do the histogram calculations and draw the histogram with a curve for you.
qi macros excel add-in

What is Cool about QI Macros Histogram Maker in Excel?

  • Calculates more than 20 process capability analysis metrics including Cp Cpk and Pp Ppk.
  • Draws a bell curve.
  • It is interactive:
    • Calculations can be viewed and updated in the Excel worksheet created by QI Macros.
    • Allows you to experiment with how spec limits impact Cp Cpk by changing them in the histogram calculations worksheet.
    • Allows you to adjust histogram bin intervals and the approximate number of bars.

Which Histogram do you want to send to your boss or customer?

QI Macros Histogram with spec limits and metrics
QI Macros histogram
Histogram Made with Excel's Data Analysis Tool pak
Excel histogram

I am very impressed with QI Macros Software. I work with Excel eight hours a day and thought that I had written macros that made me efficient. The Control Charting and Histogram macros in QI Macros alone have saved me hours of work and allowed me to present data to management in a format that is meaningful.

- Kyle Dopp
First Choice Solutions


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

easy to use

Fast and Easy to Use

  • Works Right in Excel
  • Calculates Cp Cpk Pp Ppk
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

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

affordable

Affordable

  • Only $329 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support