How to Create a Control Chart in Excel

Written by james highland
  • Share
  • Tweet
  • Share
  • Email

Control charts are a staple of the statistician's toolbox. They visualise the relationships between the variables of a process, including the number of observations, the process yield and other parameters. The flexible nature of a control chart allows for extensive customisation. While many programs exist to create complex control charts, Microsoft Excel is a versatile tool for creating charts of any kind. The software handles the requirements for control charting with ease. To be able to work with an Excel-based control chart is possible within just a few minutes.

Skill level:


  1. 1

    Download a control chart template for Microsoft Excel. A good free template is available from>

  2. 2

    Double-click the downloaded Excel template. The file will open in a Microsoft Excel window.

  3. 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. 4

    Click on the control chart tab most appropriate for your project.

  5. 5

    Type in the sample size, "n", and the "k" value control limit into the top of the worksheet in the labelled areas.

  6. 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 greyed-out columns or the "Sample" column.

  7. 7

    View the control chart for your data and parameters. The chart in the main worksheet window automatically updates based on your criteria.

Tips and warnings

  • If necessary, add or delete data rows to the data table at the bottom of the spreadsheet. To delete unused rows, right-click on the row number and choose the "Delete" option from the pop-up context menu.
  • To add rows, right-click on the grey row at the bottom of the data table and choose the "Insert" command.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.