Plot the 2nd and 3rd columns in a XY Scatter chart. Then add the 1st column
as data labels for the 3 points. You can do this by hand or automate the
process. See
Data Labels
http://www.tushar-mehta.com/excel/ne...els/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I have the following data in excel and want to create a scatter plot.

bread....7....24
drinks....9....29
foods....6....23

When I create this data as a scatterplot it plots the first set of data
as one dot and the second set of data as another dot, so 6 dots on
total.

I can get the scatter plot I require by leaving out the first column of
data, but this then does not allow me to label the dots.

Please see attachment for more details.

Any suggestions
Thanking you in advance.


+-------------------------------------------------------------------+
|Filename: Doc1.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4383 |
+-------------------------------------------------------------------+

--
elizkathjones
------------------------------------------------------------------------
elizkathjones's Profile: http://www.excelforum.com/member.php...o&userid=31756
View this thread: http://www.excelforum.com/showthread...hreadid=514813