How to Use Microsoft Excel to Draw Control Charts and Graphs

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Email

Control charts are used in statistical process control and demonstrates how a process changes over time. Usually, time is plotted on the X axis (the horizontal axis) and some other variable (the one you want to measure) is plotted on the Y Axis. They are sometimes called Shewhart charts or process-behaviour charts. Microsoft Excel can help you create a process chart. Because they are fairly complex to build from scratch, you will save time by downloading a template.

Skill level:


  1. 1

    Open a new file by clicking on the “Office” button and choosing “New.”

  2. 2

    Type “control chart” into the ‘Search Microsoft Office Online for Templates’ box.

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

  1. 1

    Go to the Microsoft Office Templates website and then type in "Control Sheet" into the search box.

  2. 2

    Click the "Download" button. The template will download and install.

  3. 3

    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).

  4. 4

    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).

Tips and warnings

  • Change any feature on your chart (for example, delete bars, change colours or rotate axes) by right-clicking on any chart element and selecting "Format."

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.