How to plot the Run Chart in Excel | Run Chart Excel Template:

How to plot the Run Chart in Excel?

A run chart is also termed a Line Chart. You can use it on the shop floor to monitor the Process variation. In the run chart, you could able to set up the mean value, upper specification limit, lower specification limit, Median & mode. A Run chart will not be able to give an idea about the control limits. It represents the variation in summarizing data of Process, or Product characteristics. However, it can show you how the process is running. Today we will discuss on how to plot a run chart in Excel. Download the Run Chart Excel template from the below link.

Download Template.

Step by Step guide on How to plot Run Chart in Excel:

Step-1: Enter the reading in the Excel sheet.

Step-2: Calculate the Mean, Median, and Mode values in Excel

Step-3: Put the USL & LSL in an Excel sheet.

Step-4: Select the Excel data table and then follow the below step to select the line chart;

“Insert>>Line graph”

Illustration with Example:

Step-1:

We are going to plot the run chart of the Permeability Number of green sand. Hence we have observed the readings four times per day; these readings are given below;

Step-2:

Calculate the mean, median, and mode of observed value;

Mean: Use the Excel formula to calculate the average value automatically. Details are described in the below figure.

Median: Select the Excel Median formula to calculate the Median value automatically. For better understanding, kindly go through the highlighted portion of the below figure.

Mode: use the Excel formula to calculate the mode value for the details formula, kindly go through the below figure highlighted portion.

Step-3:

Put USL and LSL values in Excel, if you would like to draw the line in the run chart. So here specification of Permeability is 200±10. USL is 210 and LSL is 190.

Step-4: To draw the run chart, kindly follow the sequence from “1” to “4” as per the below figure.

Sequence-1: Select the data table.

Sequence-2: Select the “Insert” option in the Excel sheet.

Sequence-3: Select the “Run Chart/ Line Chart” in Excel sheet.

Step-5: Run Chart:

[Run Chart]

(Click-Here to learn about the interpretation of the Run Chart)

Useful Links:

Internal Audit | Types | Types of Auditors | Manufacturing Example

How to Create a Drop Down List in Excel Template with Manufacturing Example

SDCA Cycle understanding with Manufacturing Example | PDCA vs SDCA

Normal Distribution Probability Formula, Calculation & Manufacturing Examples

DMAIC Tools | DMAIC Template | Six Sigma Methodologies | 30+ Free Tools

Six Sigma Project Examples | 15+ Project Examples

Six Sigma Project Charter Template

DPMO Calculation, Formula, Template & Manufacturing Example

Process Flow Diagram Template | Examples |Symbols |PFD

What is Visual Management? | Visual Management Board Examples

ABC Analysis of Inventory with Industrial Example

P Chart Excel Template | Formula |Example | Control Chart | Calculation

• 1
• 2
• 3
• …
• 10
• ›

Thank you for reading….Keep visiting Techiequality.Com

Popular Post: