Statistical Charts in Excel

Affordable, easy to use software to create charts right in Microsoft Excel.

You don't need to learn a separate software application or become a statistician to use SPC charts to monitor and improve your processes.

Just use the QI Macros Statistical Charts 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 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

This easy to use Statistical charting software installs a new menu on your Excel toolbar. To run a statistical test simply click and drag over your data to select it, and then select the test you want to run from the QI Macros menu.

statistial chart menu in the QI Macros

The QI Macros Statistical Chart Software for Excel Has Five Parts:

Click Links for Complete List of Tools and Info
View On-line Tutorials
1. 30+ 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?

The 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 
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.
Ishikawa fishbone diagram

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 Tools Video
2 minutes

Statistical Tools Tutorial
11 minutes


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

The 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.

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

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
Purchase QI Macros Statistical Chart Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!