Results 1 to 2 of 2
  1. #1
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    78

    How to set Automatically secondary values axis minimum and Maximum

    Click image for larger version. 
<br /><script async src=
    Name: combination chart.jpg  Views: 14  Size: 120.9 KB  ID: 44766" class="thumbnail" style="float:CONFIG" />
    Hi

    i want to made a combination chart in Ms Access 2019 (modern Chart), 2 line charts and 2 column charts, value of column charts in comparing with line charts are very smaller, so i want to have a secondary axis chart for more visible showing charts,

    I was looking in the Net i was thinking if i could set Automatically secondary values axis minimum and Maximum (line Charts) it will be ok, it seems with Dmax() and Dmin() Function but i do not know in which event i have to use that and how?

    any help very appreciate, actually i do not know what is the problem and put my question in other forums and did not get answer.



    sample data is like below:

    [COLOR=var(--black-800)]From_to Plan(Period) Actual(period) plan(C) Actual(C) [/COLOR]
    FROM 01/03/2021 to 01/09/2021 0 1 12 2
    FROM 01/10/2021 to 01/16/2021 10 0 22 2
    FROM 01/17/2021 to 01/23/2021 0 0 22 2
    FROM 01/24/2021 to 01/30/2021 0 0 22 2
    FROM 01/31/2021 to 02/06/2021 0 1 22 3
    FROM 02/07/2021 to 02/13/2021 0 0 22 3
    FROM 02/14/2021 to 02/20/2021 0 4 22 7
    FROM 02/21/2021 to 02/27/2021 0 3 22 10
    FROM 02/28/2021 to 03/05/2021 0 0 22 10
    FROM 03/06/2021 to 03/12/2021 8 0 30 10
    FROM 03/13/2021 to 03/17/2021 0 0 30 10

    [COLOR=var(--black-800)]F[/COLOR]
    HTML Code:
    https://stackoverflow.com/questions/66714755/combination-chart-in-ms-access-2019-secondary-axis-problem




    regards,
    Masoud
    Last edited by masoud_sedighy; 03-23-2021 at 02:00 AM. Reason: format

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,819
    You posted URL as code, not as clickable link.

    I use Access2010 and only have classic MSGraph available. I use VBA to manage axes settings. Code is called from a button Click event on form and Format event of report detail section.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 08-09-2018, 07:52 PM
  2. Minimum & Maximum Row Value
    By Thompyt in forum Programming
    Replies: 8
    Last Post: 05-10-2016, 01:08 PM
  3. Replies: 1
    Last Post: 02-05-2015, 08:12 AM
  4. Minimum and Maximum Number
    By mohanmoni in forum Queries
    Replies: 3
    Last Post: 02-04-2015, 01:55 PM
  5. Can't see minimum or maximum buttons?!?
    By Felix_too in forum Forms
    Replies: 2
    Last Post: 12-29-2010, 10:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums