Comparing Two Histograms in Excel
View Before and After Histograms Side by Side
It's hard enough to create one histogram using Excel's Data Analysis Toolpack much less two histograms side by side. But its easy with the QI Macros Excel Histogram Template
Creating Side by Side Histograms is Easy Using QI Macros
- Just click on the QI Macros Menu in Excel and select Capability Templates, Histogram with Cp Cpk.
- Then select the second worksheet tab "Compare 2 Histograms."
- To switch between estimators, change cell V2 to 1) Pooled SD, 2) Sbar or 3) Rbar estimators,
- Input the data and spec limits for both histograms in the yellow shaded input areas.
- Histogram 1: data in columns A to E and spec limits in P1 and P2.
- Histogram 2 : data in columns F to J and spec limits in Z1 and Z2.
- The histograms with bell curves are created to the right. Right click on the Y axis to change minimum or maximun values if you want the scales to be the same.
- Process capability metrics Cp Cpk Pp Ppk are also calculated for comparison.
Learn More About Histograms
Create these charts and diagrams in just seconds using QI Macros for Excel...
Join 100,000+ Users
in 80 Countries
Why Choose QI Macros ?
Ease of Use
- Works Right in Excel XL2007-2016
- Save Time vs Excel Histograms
Additional Features
- Calculates Cp Cpk Pp Ppk
- 20 Other Metrics
- Bell Curve
- Change USL/LSL, Bins, # of bars
Affordable - Just $ 249 per license and less with Quantity Discounts
Read What Others Say
- CNET Five Star Review
- Industry Leaders
