Histogram Maker for Excel

Making Histograms Does Not Have to be That Hard

QI Macros is easier to use than Excel's data analysis tool and it creates more professional looking histograms. Save yourself time and frustration with QI Macros for Excel.

Excel's Histogram Tool Can be Confusing

Excel can create a Histogram from your data but its interfaces are difficult to understand. In Excel 2010, click on Data, then Data Analysis to open this window.

how to make a histogram using Excel Data Analysis tools

Then define your data range, bin range, output range, etc, etc to get a histogram:
excel histogram using data analysis toolpakhistogram chart made in Excel

QI Macros is Much Easier to Use Than Excel's Data Analysis Tools

The QI Macros Histogram Maker is much easier to use than out-of-the-box Excel and we have added a few additional calculations of our own. QI Macros creates a new menu on your Excel toolbar. Just click and drag over your data to select it, then click on QI Macros, Histograms and Capability and then Histogram with Cp Cpk.

histogram maker menu

QI Macros will prompt you for specification limits and number of bars and will draw the histogram for you. QI Macros also uses the spec limits to calculate process capability metrics Cp and Cpk.

Example of histogram made using QI Macros


If you only want the histogram and not the metrics, just hit "cancel" on the specification limit prompts.

In addition to the histogram, QI Macros also makes it easy to create control charts, pareto charts and box plots.