Access World Forums

Access World Forums (
-   Forms (
-   -   Chart value cut (

georg7 09-11-2019 12:20 AM

Chart value cut
1 Attachment(s)
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

CJ_London 09-11-2019 12:58 AM

Re: Chart value cut
similar in access, use the iif function

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

replace X1 with the name of your field

georg7 09-11-2019 01:20 AM

Re: Chart value cut
It worked Pretty well! Thank you CJ_London
Have a good one

All times are GMT -8. The time now is 08:00 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World