I have a graph that needs a lower control limit of 3 standard deviations of a certain group of data. I need to be able to select which data is used to determine the control limits, by placing an X in the adjacent column. How would I do this?
Thanks.
Solved: Choose data for use in control limits
I have a graph that needs a lower control limit of 3 standard deviations of a certain group of data. I need to be able to select which data is used to determine the control limits, by placing an X in the adjacent column. How would I do this?
Thanks.
No ideas?
If you posted a sample of what you have with detailed explanation I could attempt to follow what you're after. As it's 40+ years since I encountered Standard Deviations, my recollection it a bit hazy, and I'm not sure I understood them then!
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Attatched is an example file.
Thanks!
Like this?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Yep. Thanks!
Posting Permissions
Reply With Quote