Access 2016 - Chart of Key Date

Posts: 293
Joined: 04 May 2010, 15:18

Access 2016 - Chart of Key Date

Post by iksotof »


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?


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
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...