Skip to content

Home / Statistical Tools / Control Charts / Control Chart Wizard

Control Chart Wizard

The Control Chart Wizard is not implemented in this version. The entry is still on the menu, and clicking it opens a message box saying so. Nothing is created.

From Excel click...

QXL Stat Tools > Control Charts > Control Chart Wizard, the first entry on that menu.

What to use instead

Launch the chart you want from its own entry on the Control Charts menu. Every chart the wizard would have built has one, and so does every chart it could not reach.

The wizard asked two or three questions and picked a chart from the answers. The same decision, made by hand, is:

Your data The chart to launch
Measured on a scale, one value per time point I-MR
Measured on a scale, subgroups of 2 to 10 Xbar-R
Measured on a scale, subgroups larger than 10, or subgroups of varying size Xbar-S
Pass or fail per item, sample size varies p Chart
Pass or fail per item, sample size constant np Chart
Several defects possible per item, area of opportunity constant c Chart
Several defects possible per item, area of opportunity varies u Chart

Those seven were the wizard's whole range. The menu also offers fourteen the wizard never reached: I-MR-R/S, Levey-Jennings, Z-MR, EWMA, CUSUM, Laney P', Laney U', G, T, and the single-panel Xbar, R, S, Individuals and Moving Range variants. Control Charts lists all twenty-one with a short description of each, and Create Control Charts covers the data layout every one of them reads.

Two things that go with it

A chart launched from its own entry gets the Control Chart task pane, which is where the display window, the display switches, and the manual split editor live once the chart exists. The wizard's charts carried on-sheet sliders and check boxes instead. Those on-sheet controls were the one thing the older charts had that the current ones do not: they went on working for somebody who opened the workbook without Quantum XL installed.

Charts built by the wizard in an earlier version still open and still draw. This page is about the ribbon entry, not about workbooks you already have.

See Also