Bubble Chart different color/value

Dear Community,

This is my first thread in this forum and I hope someone can help me (i attached the xls file):

I am trying to create from a table (Stakeholder-Analyse) a bubble chart which should represent 2 quantitative dimensions (y:Influence, z Impact(bubble size) and one dimension Type of Stakeholder (column G). I used a Template with a Macro.

Type of Stakeholder should be represented through the colors of the bubbles:
e.g. green for "sell"
yellow for "report"
orange for "join"
and blue for "tell"
and that from G8 until G20

but i dont know how to do it...Does anybody has a solution?

Thanks