Data labels on scatter chart

[Guest]

In a scatter shart, if I seleect 'Show labels' from chart options, it shows
the x-axis label next to the data point. Is there a way of using a third
column of data as the data label???

Thanks.

 

[Andy Pope]

Hi,

Try one of these 2 free addin to connect data labels to cell content.

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com/ss

Cheers
Andy

 

[Modeste]

Hello rmellison :

In a scatter shart, if I seleect 'Show labels' from chart options, it
shows the x-axis label next to the data point. Is there a way of
using a third column of data as the data label???

Have also a look at :
How to use a macro to add labels to data points in an xy scatter chart or in
a bubble chart in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;213750
http://support.microsoft.com/default.aspx?scid=kb;en-us;79972
http://support.microsoft.com/default.aspx?scid=kb;en-us;125178

Cheers
GeeDee

 

[Guest]

Went with the Add-In as I'm not too hot on VBA!!

Thanks to both for your help.