Chart value cut (1 Viewer)

georg7

Registered User.
Local time
Today, 00:50
Joined
Sep 3, 2019
Messages
84
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
 

Attachments

  • a1.JPG
    a1.JPG
    24.3 KB · Views: 43

CJ_London

Super Moderator
Staff member
Local time
Today, 07:50
Joined
Feb 19, 2013
Messages
16,553
similar in access, use the iif function

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

replace X1 with the name of your field
 

georg7

Registered User.
Local time
Today, 00:50
Joined
Sep 3, 2019
Messages
84
It worked Pretty well! Thank you CJ_London
Have a good one
 

Users who are viewing this thread

Top Bottom