Hi all, I'm new to this forum and require a little bit of help if possible.
I currently have a control chart which I have linked to a worksheet that used a drop down menu to update the values on the Y axis. The drop down menu is linked to a vlookup data table.
Due to the values on the Y axis going over the % which excel calculates I end up with a Y Axis scale from 0 - 250 (for example)
I want to write some sort of code that with allow me to scale my Y axis based on the control limits that are returned from the vlookup function.
I have tried to use the same code as in the attached spreadsheet which I found on another thread, however due to my Max & Min values being returned from a look up function it is not working. I would imagine that I need to include this within the code somehow?
Any help would be appreciated as I am new to VB Editing.
Bookmarks