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