Hello – I am using both Excel 2007 and 365. I am developing some spreadsheets for quality assurance of medical equipment. These sheets are to determine the baseline values of the equipment and the operator; after 20 - 25 sets of data are collected, the means, SD and CoVar will be used for ongoing quality assurance. During baseline data collection, the scaling of the Levy-Jennings graphs needs to change to reflect to the collected data. I would like these graphs to autoscale to +/- 4 SD from the mean. Setting these graphs in Excel to autoscale usually results in too large a range on these graphs; I'd like better resolution than this. Is it possible for the axis setting to look to cells on the sheet (O5:P6) to set the lower and upper limits of the graphs?
Thank you.
Bookmarks