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?
Thank you Darren
Access 2016 - Chart of Key Date
-
- 3StarLounger
- Posts: 315
- Joined: 04 May 2010, 15:18
Access 2016 - Chart of Key Date
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
Reason: to replace the attached Word document with the picture that it contained
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Access 2016 - Chart of Key Date
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...
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 315
- Joined: 04 May 2010, 15:18
Re: Access 2016 - Chart of Key Date
Thanks for this, sorry I haven't been in for while :)