How to set Automatically secondary values axis minimum and Maximum

[masoud_sedighy]

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]

https://stackoverflow.com/questions/66714755/combination-chart-in-ms-access-2019-secondary-axis-problem

regards,
Masoud

[June7]

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.