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.
Then define your data range, bin range, output range, etc, etc to get a histogram:
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.
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.
If you only want the histogram and not the metrics, just hit "cancel" on the specification limit prompts.