Trying to Create Between/Within Histograms in Excel?

QI Macros can create them for you!

Create a Between/Within Histogram using QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Histogram & Capability > Histogram Between/Within.
  3. QI Macros will do the math and draw the chart for you.

Go Deeper: How do you create a Between/Within Histogram using QI Macros?

Used to represent the Potential Process Tolerance, you can create a Histogram Cp Cpk (Between/Within) chart within Excel by selecting your data set and clicking on the "Histograms & Capability" drop-down menu > "Histogram Cp Cpk (Between/Within)":

between/within histogram menu

If you have a single-column set of data, you will receive the following "Subgroup Size" prompt - enter "2", as it is required to have a minimum of 2 subgroups of data to perform a Between/Within Histogram:

between-within-subgroup-size-prompt

If you have multiple columns of data and receive the following prompt, select "Values" if your first column of data is NOT a label:

labels-values-prompt

Then, input your Upper and Lower Specification Limits when prompted. If you do not have one, USL/LSL will be calculated for you - select "OK" for each prompt:

histogram usl prompt histogram lsl prompt

You will also be asked for the "Approximate Number of Bars." If you do not know the approximate number of bars you would like on your Histogram, press "OK":

histogram number of bars prompt

Once completed, a Between/Within Histogram is created:

between within histogram output

NOTE: The Between/Within Histogram uses between/within-subgroup standard deviation, instead of overall standard deviation.


Between/Within Histogram Template

Or you can use our Histogram template to create a Between/Within Histogram! To do so, click on the "Capability Templates" drop-down menu > "Histogram with Cp Cpk":

Histogram Template Menu

Next, select the "Histogram Between/Within" tab to open the template:

Histogram Template Tabs

Lastly, input your data set in columns A through J, and enter your Upper and Lower Spec Limits in Q1 and Q2 (It is required to have a minimum of 2 columns of data to perform a Between/Within Histogram):

Between/Within Histogram Template

NOTE: The Estimator is defaulted to Pooled Standard Deviation (1) in cell S2, however you can change the Estimator to Sbar (2) or Rbar (3).


Stop Struggling with Between/Within Histograms!
Start creating your Between/Within Histograms in just minutes.

Download a free 30-day trial. Get Between/Within Histograms now!


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 $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support