Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 565

Moving Range Charts

The StatPlus>QC Charts>Moving Range Chart command creates a Moving

Range chart of quality-control data where there is no subgroup available. The

quality-control values must be placed in a single column. The Moving Range

chart can be sent to an embedded chart on a worksheet or to its own chart sheet.

XBAR Charts

The StatPlus>QC Charts>XBAR Chart command creates an XBAR chart of

quality-control data. The subgroups can be arranged in rows across separate

columns or within a single column of data values alongside a column of

subgroup levels. The user can use known values of μ and s or create the

XBAR chart with unknown μ and s values. The XBAR chart can be sent to

an embedded chart on a worksheet or to its own chart sheet.