Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-11-2019, 12:20 AM   #1
georg7
Newly Registered User
 
Join Date: Sep 2019
Posts: 16
Thanks: 8
Thanked 0 Times in 0 Posts
georg7 is on a distinguished road
Chart value cut

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
Attached Images
File Type: jpg a1.JPG (24.3 KB, 6 views)

georg7 is offline   Reply With Quote
Old 09-11-2019, 12:58 AM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,238
Thanks: 40
Thanked 3,645 Times in 3,515 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
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
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
georg7 (09-11-2019)
Old 09-11-2019, 01:20 AM   #3
georg7
Newly Registered User
 
Join Date: Sep 2019
Posts: 16
Thanks: 8
Thanked 0 Times in 0 Posts
georg7 is on a distinguished road
Re: Chart value cut

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

georg7 is offline   Reply With Quote
Reply

Tags
charts , form , values

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Guidance on writing query for chart or pivot chart digitalshepard Queries 0 02-14-2012 12:32 PM
Excel Chart - Macro to globally change multiple chart titles? parodytx Excel 1 04-30-2011 06:54 AM
Converting Excel Data&Chart to Access07 Table/Chart SMay Tables 0 01-19-2009 07:42 AM
Protecting a chart but allowing chart data to change? scott-atkinson Excel 2 09-07-2007 06:18 AM
Can form useMicrosoft Excel Chart instead of Microsoft Chart Wizard wordsmith Forms 1 03-22-2006 07:04 AM




All times are GMT -8. The time now is 06:06 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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