Need suggestion on creating a chart.

[ListO]

Greetings all.
I want to make a chart and I can't see how to accomplish what I want. I'm seeking suggestions about the best approach.
I have a query with a list of selected names which I want to use.
I have a query with a list of events. Each event has a start time and end time field, and the record ID of the name.
I have a query with names and events made from the two previous queries.

I want a chart which shows the events in a timeline, listed by the name attached to those events.

Is this possible, and what is a good approach to creating it? None of the chart types I've looked at seems appropriate.

 

[June7]

Review https://www.accessforums.net/showthread.php?t=18459&highlight=busdriver

 

[ListO]

YES! That's great. I can see exactly how to adapt that to what I need.
I was stuck thinking about how to adapt the built-in charting, but this is relatively simple.
Thank you.

 

[isladogs]

You might find it worth attending next week's Access Europe presentation: Interactive Gantt Chart Scheduler in Access.
See https://www.access-programmers.co.u...ctive-gantt-chart-scheduler-in-access.328056/