Nirubiha has attended:
Excel Intermediate course
Control Chart
I made a graph i.e by Insert then column then choosing 2D-column. Now i would like the mean and the min and max values appears on the graph as it would be for a control chart. Please let me know how can i do this.
Kind Regards,
Nirubiha
RE: Control Chart
Hi Nirubiha
Can I check with you whether you are using Excel 2013 or 2010?
Here is an example created in Excel 2010 showing the mean, max and min values as line charts and the data as a 2D-column.
I used the following functions for the calculations
=AVERAGE($B$2:$B$13)
=MAX($B$2:$B$13)
=MIX($B$2:$B$13)
where the data is in B2:D13
Data Mean Max Min
Jan 74 57.75 100 12
Feb 61 57.75 100 12
Mar 47 57.75 100 12
Apr 100 57.75 100 12
May 57 57.75 100 12
Jun 22 57.75 100 12
Jul 99 57.75 100 12
Aug 80 57.75 100 12
Sep 12 57.75 100 12
Oct 22 57.75 100 12
Nov 73 57.75 100 12
Dec 46 57.75 100 12
Then create as a line chart and change the first series to Column 2D-Chart.
Please let me know if it is similar to what you want.
Regards
Doug
Best STL
RE: Control Chart
Hi,
would it be possible to send you my excel spread sheet so you can have a look what i really mean.
Thanks. It's quite urgent now.
Kind Regards,
Nirubiha
RE: Control Chart
Yes you can Nirubiha.
Click reply then look for the upload + link.
That allows you to send the file.
Any problems you can also send to infor@stl-training.co.uk
regards
Doug
