How to create world map with hover text to show who is attending events in given countries?

Hello all,

I am a beginner Excel user (I thought I was intermediate until this!) and am looking for a hand with creating a map widget to help my team members know, at a glance, who is attending events and where. I am using Excel 365 (Version 2512) and have PowerMaps enabled.

My goal is to enable my colleagues to enter basic info in a table (Columns: Employee Name, Event Name, Team Name, Country) and, based on that table, generate a map chart where hovering over the country produces hover text with Employee Name, Event Name. In other words, people want to know who is attending X event, know what country it's in, and hover over that country on a map to see if anyone has logged that they will be there.

Where I'm stuck is the last part/hover text, especially when there are multiple employees and/or events happening in the same country. I have considered adding City as an extra location line for when there's multiple events in the same country, but I run into the same issue, namely that the hover text can't seem to include the full range of info, only an Employee Name OR Event Name.

For example, using the test table below:

I don't fully understand how to select the data, because all I've managed to do is define each row as a series, which doesn't quite work since a) that means manually adding each one as a new series, and b) tends to return hover text that looks like [Series "Employee Name" Point "Australia" Event1" rather than something like [Anne, Event1].

I did find this post and solution which got me closer, but I am not sure how to alter the formula to fit my table/dataset, since I don't have the ABROAD yes/no filter.

My full dataset will be <200 rows, and most likely <100, so I don't anticipate major issues with lag or anything of the sort.

If this isn't doable in Excel, I would also appreciate that intel, since I don't want to go in circles if it ultimately isn't doable! TIA!