combination chart in ms access 2019 secondary Axis problem

[masoud_sedighy]

I have made a combination chart (Modern Charts) in MS Access 2019. 2 line charts and 2 column charts as below picture. with sample data like below:

From_to Plan(Period) Actual (period) plan(C) Actual(C)

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

I have used Column chars for:
First issue plan (this period)
First issue actual (this period)


and line charts for
First issue plan(C)
First Issue actual(C)


now i want to use secondary axis for line charts but when i set secondary Axis for them in chart setting it does not show any chart so i have set on primary axis, I would like to know how i can solve this problem.

 

[Uncle Gizmo]

I've noticed it's been a while and you haven't had a reply to your post yet, so I thought I would bump it up the list!