XmR Chart
Generation
Create Individuals and Moving Range charts directly in Microsoft Excel.
SPC XmR Charting Tool
Create XmR charts. Detect SPC signals. Improve with data.
An Excel-based Statistical Process Control XmR charting tool for Microsoft 365. Generate professional Individual SPC and Moving Range charts using Office Scripts, without VBA.
Script download: if the script opens as a text page, right-click the Download Script button and choose Save link as.
XmR Chart
Office Script
Automation
Run the tool in Excel for the Web without VBA or desktop macros.
SPC Signal
Detection
Detect limits, shifts, trends and two-of-three warning signals.
Summary
Statistics
Calculate means, moving ranges and process limit values automatically.
Intervention
Annotations
Add key events and process recalculation points to support interpretation.
Input-Led
Workbook
Structured worksheet inputs. Clear charts, calculations and outputs.
How To Use
Download The Files
Download the Excel workbook and the accompanying Office Script text file.
Install The Script
Open the workbook in Excel for the Web and paste the script into Automate.
Enter Chart Data
Add chart settings, dates, values and optional target information.
Add Annotations
Include interventions or process recalculation points where appropriate.
Run And Review
Run the Office Script, then review the XmR chart, moving range chart and signals.
Only edit the intended input areas. Outputs are analytical aids and should be reviewed before being used for operational, managerial or clinical decisions.
Resources & Links
Disclaimer
Important information, limitations and warnings.
Download Workbook
SPC XmR Tool v1.0.0 Excel workbook.
Download Script
Office Script text file for Excel for the Web.
Getting Started
Step-by-step guide for installing and using the tool.
Contributing
How to contribute, report issues and suggest improvements.
License
Custom non-commercial licence terms.
Readme
Overview, features and installation information.
Release Notes
Details of the latest release and changes included.
Changelog
Version history and project change record.
Security Policy
Security, privacy and safe use information.
Support
Get help, ask questions or raise an issue.
Technical Notes
Implementation details and technical reference.
View the project on GitHub
Source code, documentation and all project resources are available in the repository.
View On GitHub