Graphing data stored in single cells

[HS113]

Hello,

I'm trying to set up a chart or graph that will pull names from my table (that will be updated periodically) and display each name beside how many meetings they've been to and what type of meetings they were.

I've written out an example to more clearly see what I am dealing with. If this is possible I would appreciate any suggestions. Thanks!

Date	Time	Location	Participants	Meeting Type
05/01/2023	11:20:00 AM	Room 214	John, Kelsey, Aron, Garth, Megan, Erin, Rex	Safety
10/01/2023	2:00:00 PM	Room 213	Mark, Kelsey, Garth, Max, Ginny	Manager
13/01/2023	10:00:00 AM	Room 214	Aron, Ginny, Max, Rex, Brian, Tracy, Megan, Steve	Safety
15/01/2023	10:30:00 AM	Room 320	Mark, Kelsey, Brian, Max, Steve, Ginny, Garth, Erin, Brian, John	Sales
16/01/2023	4:00:00 PM	Room 213	Mark, Kelsey, John, Garth, Max, Ginny	Manager
23/01/2023	1:30:00 PM	Room 213	Malcom, Max, John, Rex, Megan, Steve, Timmothy, Sam, Kelsey	Safety

[#2]

Hello @HS113,

I've made a sample, and I think there maybe still some improvement here... but still it'll do what you're looking for...


Sample file is on the attached.