Chart value cut

[georg7]

Hi there,
I have a problem with my Chart. Sometimes the value is to big and my line goes out of the Chart. Does somebody know how to cut my value if ist bigger than 1,5?
So if it's 1,6 it will be cut to 1,5.
In Excel it's
(X1 > 1,5;1,5;X1)

Best regards
Georg

 

[CJ_London]

similar in access, use the iif function

iif(X1 > 1,5,1.5,X1)

replace X1 with the name of your field

 

[georg7]

It worked Pretty well! Thank you CJ_London
Have a good one