How to Use Microsoft Excel to Draw Control Charts and Graphs

Excel 2007
1. Open a new file by clicking on the “Office” button and choosing “New.”
2. Type “control chart” into the ‘Search Microsoft Office Online for Templates’ box.
3. Click on the control chart that appears, then click the “Download” button. The file will download and automatically open. At this stage, you can tailor the control sheet to fit your needs, perhaps by changing the titles in the columns or by placing different totals in the boxes.
4. Graph the control chart. Highlight the text by left clicking at the top left corner of the data and then dragging the cursor to the bottom right. Choose “Insert->Chart” from the toolbar and choose your chart type. For example, click on “2D column graph.” Excel will insert your chart automatically.
Excel 2003
5. Go to the Microsoft Office Templates website and then type in 'Control Sheet' into the search box.
6. Click the 'Download' button. The template will download and install.
7. Click on 'File->Open' from Excel and locate the file you just downloaded. Press 'OK.' The control sheet template will open up. You can adjust the template to suit your needs (for example, different numbers in the rows).
8. Click on 'Insert->Chart' and follow the directions in the Chart Wizard to create a chart (for example, choose a column chart to display your data).