Home » Knowledge Base » Histograms & Capability Analysis » Between/Within Histogram

Between/Within Histogram in Excel

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)":

Next, 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:

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":

Once completed, a Between/Within Histogram is created:

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":

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

Lastly, input your data set in columns A through J, and enter your Upper and Lower Spec Limits in Q1 and Q2:

---

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