Access 2016 - Chart of Key Date

iksotof
3StarLounger
Posts: 293
Joined: 04 May 2010, 15:18

Access 2016 - Chart of Key Date

Post by iksotof »

Hello

I am looking to create a chart in a report whereby I have students and dates for when he passed exams. Lets say Jon, Maths = 21/05/21, Jon, History = 17/06/21 where thee chart on the x axis shows the subject and a line for jon (in y axis) with the date lable on the line above the subject? Any ideas of pointers to a tutorial to assist pleasE?

My data is arranged in tbales stude, exam type, wiht progress table where dates are contained witht he subject as the foeign key. I attach a graphic for my idea?

2021-07-20_124950.jpg

Thank you Darren
You do not have the required permissions to view the files attached to this post.
Last edited by HansV on 20 Jul 2021, 10:51, edited 1 time in total.
Reason: to replace the attached Word document with the picture that it contained

User avatar
HansV
Administrator
Posts: 71500
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Access 2016 - Chart of Key Date

Post by HansV »

It would be difficult, if at all possible, to create that chart in Access. It might be possible in Excel, but if I'm honest, it appears to be a very uninformative chart to me. The points on the lines don't have any relationship with the actual dates. A chart doesn't look like a useful way to display the data to me...
Regards,
Hans