Excel Functions Tutorials
- Excel Charts
- Types of Charts in Excel
- Area Chart in Excel
- Bubble Chart in Excel
- Chart Templates in Excel
- Change Chart Style in Excel
- Calendar Template in Excel
- Inventory Template in Excel
- Clustered Bar Chart in Excel
- Clustered Column Chart in Excel
- Column Chart in excel
- Combination Charts in Excel (Combo)
- Excel Combo Chart
- Control Charts in Excel
- Doughnut Chart in Excel
- Dynamic Chart in Excel
- Excel Chart Wizard
- Flow Chart in Excel
- Flowchart Excel Examples
- Funnel Chart in Excel
- Gantt Chart in Excel
- Gantt Chart Example
- Gauge Chart in Excel (Speedometer)
- Graphs vs Charts
- Histogram Excel Chart
- How to Make Graph / Chart in Excel?
- Legends in Excel Chart
- Line Graphs / Charts in Excel
- Line Chart Examples
- Marimekko Chart in Excel (Mekko)
- Normal Distribution Graph in Excel
- Organization Chart in Excel
- Pareto Chart in Excel
- Pie Chart in Excel
- Make Pie Chart in Excel
- Pivot Chart in Excel
- Radar Chart in Excel (Spider Chart)
- Stacked Chart in Excel (Column, Bar & 100% Stacked)
- Stacked Bar Chart in Excel
- Stacked Column Chart
- Stock Chart in Excel
- Scatter Plot in Excel (Chart)
- Tornado Chart in Excel
- Dot Plots in Excel
- 3D Plot in Excel
- 3D Scatter Plot in Excel
- Standard Deviation Graph in Excel
- S Curve in Excel
- Waterfall Chart in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
Control chart is a type of chart which is used to analyze how the data changes in time to time, it is also known as behavioral chart or Shewhart chart in excel, it is used in statistics in business which helps user or the viewers to analyze how any process changes, its components are control line and upper and lower control line and the means of making it is with the help of calculations of average and standard deviation of the data.
Control Charts in Excel (Table of Contents)
What are Control Charts in Excel?
“Control Chart” is the visual graph used to analyze the change of process over a period of time. To plot this excel graph we need to arrange the data in chronological order with current data sets. To create a control chart in excel we need to have what is the average of the data, what is the upper control limit of the data, and what is the lower control limit of the data.
All these lines or drawn by using historical data sets and we compare the current set of data with average, upper limit, and lower limit lines in the graph to draw conclusions whether the process variation is consistent or inconsistent and also to understand whether the data is unpredictable. If all the data points come within the control limit lines (average, upper, lower) then variations may be due to general cause and process said to be in control. Similarly, if the data points are plotting above or below the limit line then variations may be due to special cases and process said to out control”.
Types of Control Charts in Excel
We have four kinds of Control Chart with excel. Below are the types of Control Chart with excel.
- High – Low – Close
- Open – High – Low – Close
- Volume- High – Low – Close
- Volume – Open – High – Low – Close
Each chart requires a specific set of data. Let us have a look at how each type of control chart is created.
Top 4 Types of Control Chart in Excel
We will see examples for each type in the below section of the article.
Type #1 – High – Low – Close Control Chart
To create this type of Control Chart we need to have three sets of data i.e. what is the high price in the day or high-value point, what is the low-value point and what is the actual closing number.
Copy and paste the above data sets to your worksheet.
Once you have copied the data to the worksheet, select the data and go to Insert tab.
In the insert, go to charts area > Stock Chart > High-Low-Close Chart.
We will have a chart like below.
We cannot identify anything with this chart, so we need to color each line in our own way. By selecting the chart to go to “Format” > Current Selection > and from drop down select “Series High”.
This would select the high line from the chart. So, now again under FORMAT choose “Shape Outline” and choose the color as per your wish.
Now we can see High line is colored with a green color.
Now we need to repeat the same task for the other two lines as well i.e. “Low” & “Close”.
So, this shows how “High, Low, and Close” points fared in each day.
Example #2 – Open – High – Low – Close Control Chart
To create this we need copy table to the worksheet.
This time insert Open – High – Low – Close chart.
Now we will have below chart.
Example #3 – Volume – High – Low – Close Control Chart
To create this we need to have one additional data point i.e. “Volume” data.
Copy above table to worksheet, this time insert Volume – High – Low – Close chart.
Now we will have below chart.
Example #4 – Volume – Open – High – Low – Close
The final type of control chart is this. For this, we need one more additional data i.e. what is the opening value of data point.
Copy above table to worksheet, this time insert Volume-Open-High-Low-Close chart.
So, now we will have below designed chart like the below.
You can do all the settings, formatting and many other things as per your wish.
This has been a guide to Control Charts in Excel. Here we discuss the top 4 types of control chart in excel along with how they are created with practical examples and downloadable excel template. You can learn more about excel functions from the following articles –