Select the numerical columns (B & C) and make your XY chart. Use one of
these two free utilities to add the labels range as labels to the chart:
Rob Bovey's Chart Labeler,
http://appspro.com
John Walkenbach's Chart Tools,
http://j-walk.com
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"JayK" wrote in message
...
Hi,
I have data in 3 columns as follows:
First column is the category
Second column is X value
Third column is Y value.
Now I want to draw an XY scatter plot with X & Y values, with the
categories
in column A as legends/labels.
How do I do it? Excel creates 2 series instead :(