Monday 16 September 2013

How to make Run Chart using Excel



Run chart is used to understand the trends in a process or variation over time. Here I am making run chart for total production/shift of any components/items for a week.
Step1: Collect the data and enter it as shown below:

Step2: Make column ‘C’ for Average by using the formula (AVERAGE (B2:B13)) as shown below :

Step3: Now select A1:A13, B1:B13, C1:C13 as shown in fig. then go to insert tab and select line option as shown below:

Finally run chart will prepare and look like as below:

No comments:

Post a Comment