Coloring multiple series by group in scatter chart

In a scatter chart, is there a way to color multiple series points at once?

Please see attached. I would like all blood to be red dots, all ETBF to be olive green, etc. Is there a way to do this quickly?

I don't if this is what you are looking for but you can:

1-Copy your worksheet
2-Select the first column and DATA menu - Remove Duplicates
3-You should now have only 13 Rows
4-Enter =SUMIF(Sheet3!$A:$A;$A2;Sheet3!B:B) in B2 and copy this to the rest of the table
5- Select the table and create your scatter chart

I created the file but couldn't attach it