How to Create a Control Chart in Excel

1. Download a control chart template for Microsoft Excel. A good free template is available from www.vertex42.com/ExcelTemplates/control-chart.html.
2. Double-click the downloaded Excel template. The file will open in a Microsoft Excel window.
3. Choose the desired control chart format for your project. The two common control chart designs are listed as separate tabs at the bottom of the Excel window. The 'XbarR' worksheet tab creates a control chart for mean and range calculations. The 'XbarS' spreadsheet works with a control chart for mean and standard deviation.
4. Click on the control chart tab most appropriate for your project.
5. Type in the sample size, 'n', and the 'k' value control limit into the top of the worksheet in the labeled areas.
6. Paste or type the X-bar and standard deviation or range values for your data set into the worksheet's table located below the control chart display. Do not alter the grayed-out columns or the 'Sample' column.
7. View the control chart for your data and parameters. The chart in the main worksheet window automatically updates based on your criteria.