[scatter][how to label different contexts]

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

Thank you
But this doesn't work for me since I must run the addin for EACH label every time I do this.

Hey found it !

http://www.youtube.com/watch?v=4GOsq9bRDB0

Cheers,
Bye

Originally Posted by Andy Pope

Not sure what you mean. You will need to apply labels to the 2 series.

That's exatcly what I wanted !

Thank you,