# Create an Excel Control Chart to Analyze Data

In this article, we’ll show you how to construct an Excel control chart to analyze data and improve efficiency. Control charts are useful for monitoring any process that has a level of variation – for example, filling containers with a certain number of items. They can easily illustrate whether your process is operating within its intended parameters.

1. Gather and Format Your Data
Once you have the data gathered from your process, the first step in creating an Excel control chart is to ensure that it is correctly formatted. Your data set should be organized along a mean (average) – i.e. a target point that the data points are clustered around. If it’s not, your control chart will not be useful.

2. Organize Data Columns
Secondly, create columns to organize your data. Label them Range, Number, Data, Lower, Upper and Average. Fill the Data column with your organized data points, and fill the Number column with values ascending in numerical order, starting with 1.

3. Get Your Upper and Lower Limits
Here’s where your formula comes in. In the first cell of the Range column, enter the formula =Abs(C2-C3). Select the cell and drag it down to copy the formula to the end of your data. In the Lower column, do the same with the formula =Average(C:C)-2.66*Average(A:A), and in the Upper column use=Average(C:C)+2.66*Average(A:A).