Trouble selecting correct data for bubble charts.

Hello everyone, I was wondering whether anybody could offer some help with bubble charts. I have attached a file with example data (and my failed bubble chart).

I am trying to get:
- A linear time x axis with bubbles at the correct given date (to show reverse distance in time from the origin, which should be =today)
- A y axis that reflects the "RAG Rating", with 10 being closest to the origin
- Bubble size to reflect the "CT Rating" column, where 10 is the biggest bubble
- Bubble labels that would contain the columns for name and contact title

Is there any way to do this easily in excel? The only helpful post I have found online so far is one that calls for VBA programming, which I'm not familiar with at all.

The problem is, I would like to do this for different companies with different amounts of bubbles, so I'm not sure how to make it scale either.

Any help would be greatly appreciated! Thanks in advance,

MC

Thank you very much!
The x,y,z made me understand, so after some tinkering I got the hang of how manually inputting data works.
I now managed to make separate series to make the bubbles conditionally formatted too, which is a plus.
Also, the add-in you pointed me to is super useful!
Thank you very much again!