secondary Axis problem

[Masoud1313]

I have put my question in several forums but i did not get answer, one of them replied they do not support Access 2019.

I have made a combination (Modern Chart)  in MS Access 2019. 2 line charts and 2 column charts as below picture.

with below sample data:

From_To	First Issue Plan (This Perid)	First Issue Actual (This Perid)	First Issue Plan (C)	First Issue 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.

[#2]

Good morning! Microsoft has a nice writeup on modern charts with descriptions on how to use a secondary axis. I recommend taking a look at https://support.microsoft.com/en-us/office/create-a-chart-on-a-form-or-report-1a463106-65d0-4dbb-9d6... and if this does not fix your issue, reply back with screen shots of what your chart setup is.