Excel Heat Map - Issue with multiple id's (data label) in a bubble chart

Firstly, I have minimal to no coding experience.

I started building a heat map that would automatically update when a table of data is completed.
The purpose of this chart was for different areas of the business to identify their risks, enter it into a table (A68:Q84) then the chart would automatically update and they could see their risks in a visual format. The risks are based on consequence and likelihood, which have been pre-defined and drop down lists were created to make the selection easy.

Each row of the table (A68:Q84) is a risk and I have labelled them C1 (current risk 1) C3 (current risk 3) T3 (treatment risk 3), T5 (treatment risk 5) etc.

After selecting the drop down list of consequence and likelihood, another table (A1:G51) of chart data automatically updates. The top table (A1:G51) will be the information that updates the ID's in the bubble chart.

My issues are...

If the same consequence and likelihood is selected twice, only one ID shows on the label.

Things I have tried, but not quite succeeded in addressing the above issue.
1. Cell BP2. I tried listing all the IDs for same bubble chart coordinates, then concatenating the ids. issues with this was that I have big gaps between the ID and they didn't fit within the bubble.

Ideally i would like to see the bubble chart (data point selected multiple times) with an ID such as...

C1, C5

Thank you so much for your input

Hi Alyceh,

Do you mind share it with us.
Greatly appreciate.

Thx