Automatically change graph axis range according to data in cells

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.

Thank you, CK76. I've never learned VBA, and maybe it's time I did. Is it difficult to learn enough (for now) to do what I need to do? Can you recommend a good source I can learn VBA from?

Thanks again, CK76. Time for me to start reading up on this.

Thank you, Kokosek. Is this the VBA "script" (or whatever it's called) to accomplish what I need to do? How would I insert this into my sheet?

Hi, Kokosek.

Sorry for the delayed response, I've been on the road. I'm currently away from my system with Excel 2016 and only have access to Excel 2007. From the screen print you posted, I can't figure out how to import the script you wrote into my Excel 2007 spreadsheet. Could you provide some instructions for this?

Thanks very much.

Thank you, protonLeah, this was very helpful. With your instructions, I was able to paste Kokosek's script into my sheet.

Kokosek, thank you VERY much! I'll still try to start learning VBA, but you saved me a lot of time by writing the script that I could use.

Hello, Kokosek.

In September 2019, you had helped me with VBA for a quality control spreadsheet I've been working on. A problem I've encountered is this error message:

Microsoft Visual Basic
Run-time error '1004':
Unable to get the Min property of the WorksheetFunction class

In the error message window, there are buttons for End, Debug and Help.

This message continues to appear with every data entry until there are two rows of data. I suspect the macro is "crashing" until there are enough data to calculate the standard deviations. Is there a way to modify the macro so this message doesn't appear?

Thanks very much.