Do you have a sample workbook that you can attach to look at.
I've updated the original post with a packaged workbook.
Sorry i have a older version and was not able to open the file
Ben Jones did an extensive blog on calculating UCL and LCL and colored points above and below the CL lines. Hope this helps. http://dataremixed.com/2011/09/tom-brady-and-control-charts-with-tableau/