Right. I am using MS Access 2016. It used to be you could double click the chart area and manipulate individual items, I can no longer do that only the 'chart setting' window is available. In this case, I want the x axis to have vertical values and horizontal group labels. I can't for the life of me figure out how to get MS access to do this through the charting tool I can only get both labels to be vertical or horizontal. Can anyone help me navigate this obstacle? I've fiddled with the properties for over an hour and I can't see how the primary and secondary axis labels can be altered independently of one another.
This is my dataset
2018 - Test 1 Test AAAAAAAAA 68 2018 - Test 1 Test B 2 2018 - Test 1 Test C 133 2018 - Test 1 Test D 93 2018 - Test 1 Test E 68 2018 - Test 1 Test F 25 2018 - Test 1 Test G 21 2018 - Test 1 Test H 16 2018 - Test 2 Test A 28 2018 - Test 2 Test B 2 2018 - Test 2 Test C 59 2018 - Test 2 Test D 10 2018 - Test 2 Test E 17 2018 - Test 2 Test F 4 2018 - Test 2 Test G 2 2018 - Test 2 Test H 7 2019 - Test 1 Test A 68 2019 - Test 1 Test B 1 2019 - Test 1 Test C 151 2019 - Test 1 Test D 46 2019 - Test 1 Test E 71 2019 - Test 1 Test F 38 2019 - Test 1 Test G 38 2019 - Test 1 Test H 10 2019 - Test 2 Test A 28 2019 - Test 2 Test B 1 2019 - Test 2 Test C 73 2019 - Test 2 Test D 18 2019 - Test 2 Test E 24 2019 - Test 2 Test F 9 2019 - Test 2 Test G 9 2019 - Test 2 Test H 1
This is how I want my graph to appear