Text labels on x-axis in a bubble chart?

[Exxel]

Hi,

I am trying to create a bubble chart that compares prices (Y-axis) of several products across vendors (X-axis) with the bubble sizes representing market share. Each notch on the x-axis represents a vendor (Samsung, LG etc). I have a chart that makes sense, the only thing I am unable to figure out is how to replace the 1,2,3 etc..on the x-axis with vendor names.
For eg, 1 = Samsung, 2= LG, 3 = Nokia etc.

How do I go about doing this? I have tried all (I think) options in excel 2007, but with no avail.

Can someone please help? Thanks in advance.

Regards
-Laxman

 

[Andy Pope]

Have a look at my reply to your post over at the other forum you posted your question on.

http://www.excelforum.com/excel-gen...-chart-to-non-numeric-values.html#post2335520