I agree, that is what I said in my response.

I just don't understand this bit

.... but there some logic hide behind hide the code, or what's logic the code
rely on? and maybe some knowledge about axis scale modify principle.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"fujing1003" wrote in message
...
On Dec 11, 4:53 pm, "Bob Phillips" wrote:
Not sure that I really understand your question, but it seems to be just
a
simple bit of code to work out the min and max axis scales.

Thanks for your answer. line 42 seems to be redundant. line 40 always
result out an integer by use"\".
Yes, its purpose is to get the appropriate min axis scale. the code is
simple,
but there some logic hide behind hide the code, or what's logic the
code rely on? and maybe some knowledge about axis scale modify
principle.
'--------------------------------------------------------------------

35 dbMaxScale = Round(dbMax * 1.1) + 1
36 dbMinScale = dbMin - dbMax * 0.1
37 If dbMinScale < 0 Then
38 dbMinScale = 0
39 Else
40 dbMinScale = (dbMinScale \ 5) * 5
41 End If
42 dbMinScale = Round(dbMinScale, i_intDecimal)
'--------------------------------------------------------------------