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
Examples
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

2.

90+ Fill-in-the-blank Templates and Tools 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 
Histogram

Templates Video
4 minutes

Templates Tutorial
16 minutes

3.

The 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

4.

Data Transformation 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 Transformation Video
3 minutes

Data Transformation Tutorial
14 minutes

5.

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!
How We Can Help Download Free QI Macros Trial Buy QI Macros for Excel Now