SPC Charts in Excel

Affordable, easy-to-use, add-in creates SPC charts in seconds

You don't need to learn a separate software application or become a statistician to create SPC charts!

Just use the QI Macros SPC Software for Excel to draw pareto charts, control charts with stability analysis (c, np, p, u, XmR, XbarR, XbarS), histograms with Cp Cpk, scatter plot diagrams, box and whisker plots and more.

I just made my first SPC charts and the QI Macros were very easy and user friendly. This is going to be a great tool.

– Jim Welsh
Lennox Industries

I really love the QI Macros SPC Software! It really saves non-mathematicians / non-statisticians like myself a lot of grief. When I first tried the free trial and saw what it could do (and how much work it would save me) you could hear me shout clear down the hall! I like the software so much I was able to get our corporate office to buy it too.

– Vickie Smith

QI Macros installs on Excel's menu. To create a SPC chart, simply click and drag over your data to select it, and then select the chart you want to run from QI Macros menu.

SPC charts menu in the QI Macros

QI Macros SPC Chart Software for Excel Has Five Parts:

Click Links for Complete List of Tools and Info
View On-line Tutorials
1. 40+ Charts you can draw instantly from Excel data including paretos, control charts, histograms, box and whisker, scatter, and many more.

Do you find it hard to choose the chart?

QI Macros is the only SPC toolkit that has a Chart Wizard and a Control Chart Wizard that can choose the right chart automatically based on your data.
control chart
Control Chart
Pareto Chart Excel for Six Sigma
Pareto Chart

Create Charts Video
3 minutes

Charts Tutorial
18 minutes


100+ Lean Six Sigma Tools and Templates that provide paint-by-numbers simplicity and consistency to Lean Six Sigma tools like fishbones, flowcharts, Gage R&R, PPAP and SPC Charts.

Do you find monthly reporting a manual nightmare? There are over 30 chart templates that make monthly reporting as simple as adding new data points.
Fishbone Diagram Excel

Templates Video
4 minutes

Templates Tutorial
16 minutes


QI Macros is the only SPC toolkit that has a Statistics Wizard that can automate hypothesis testing based on your data.

Statistical Tools like Anova, normality test, f-test, t-test, regression and more that make hypothesis testing and statistical analysis a breeze.

statistical tests

Statistical Tools Video
2 minutes

Statistical Tools Tutorial
11 minutes


Data Mining and Analysis Tools - To help stack, restack, aggregate and analyze your data.

QI Macros is the only tool that includes a PivotTable Wizard to instantly aggregate line-by-line transaction data like ERP, error logs or financial data into actionable improvement stories.

QI Macros is the only tool that has a Word Count Wizard that analyzes service rep comments to find pareto patterns in the notes.
pivot table

Data Mining Video
3 minutes

Data Mining Tutorial
14 minutes


Do you struggle with the Control Phase of DMAIC?

Control Chart Dashboards for Monthly Reporting and Monitoring of Key Indicators - just drop your data into these XmR, c, np, p, or u chart templates and click on the Create Dashboards icon.

Control Chart Dashboard Tutorial
6 minutes