Hello all,

I'm having a hard time with this:
I have two suppliers, Adam and George. They sell me the same products monthly with different configurations and different quantities.

Please see the graph below.
excel.jpg

The problem is that the products already have difficult names (letters) and it's difficult to report to my boss this chart because it's very confusing and I don't have the time to do it manually.

What I want to do:
Make every Adam products look the same (e.g. a green ball) and the same for George (e.g. red square).
The second thing I want to do is to label every dot with their correspondent name.

Please find the excel file attached below.
Adam and George.xlsx

Can anyone help me???

THANK YOU VERY MUCH ! :D