X-Y axis scale auto-update

Hi,

I have the folowing in my spreadsheet:
in K5: =min(B5:B100)-50
in L5: =max(B5:B100)+50
in M5: =min(C5:C100)-50
in N5: =max(C5:C100)+50

I have a sepparate chart sheet (scattered) where I need a code to auto-update X and Y axis scale when new input data in the worksheet is copied and to take min and max from the above cells (B5:B100 is Y axis, C5:C100 is X), I've tried arround some codes but no success yet...
Appreciate your help (please mention where to copy the code: under modules, chart or the worksheet?)

Hi Ralem
have a look at teylyns example quadrant data
You will need find the Absolute maximum and minimum values then
plot them as both - and + values
http://spreadsheet-toolbox.com/libra...ith-quadrants/

Thanks for the reply but didn't help in my case, I've been trying the below code but couldn't make it work; please check:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Sorry, please check it now

Hi, I got the folowing code to work:

Please Login or Register  to view this content.

I assigned it to a button, how can I run it automatically when data is updated without using a macro button.
Appreciate help

Hi Ralem
what triggers the data to update?

Hi Pike,
The data range is balnk, and as the user copy and paste new data I want the macro to run.

Hi Ralem,
You culd use the worksheet events

Please Login or Register  to view this content.