Histogram | One-Sided Tolerance

It's easy to run a Histogram, with a One-Sided / Unilateral Tolerance, using QI Macros SPC software.

To Create a One-Sided Tolerance Histogram, follow these steps:

  1. Run a Histogram and select "Cancel" when asked for either the USL or LSL, depending on what aspect of your data you wish to have one-sided. You may use the default spec limits or input your own.


    2. Histogram One-Side Tolerance Example 1

    -or-

    One Sided Tolerance Example 2

    (If you select, "Cancel" on both the USL and LSL prompts, you will receive a chart with minimal metrics)

  2. Next, name your chart, along with the x and y-axis.
  3. Below is an example of a One-Sided Histogram, created with the LSL cancelled. Notice the Cp, CpL, Cpm, Cr, Pp, and PpL metrics are not calculated; these are not included with one-sided Histograms, when the LSL is not included (vice versa when the USL is not included):

    4. One Sided Tolerance Example 3

And here's how to create a One-Sided / Unilateral Tolerance Histogram, using the QI Macros Template:

If you would like to create a One-Sided Histogram using the Lean Six Sigma Templates portion of QI Macros, simply delete the USL or LSL and leave the cell blank.

Do not put a "0" into the cell:

    One Sided Template Example 4

Learn More...

Create these charts and diagrams in just seconds using QI Macros for Excel...

Data Mining and Analysis
Download Free QI Macros Trial
Buy QI Macros for Excel Now