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.

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

rmellison wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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...b;en-us;213750
http://support.microsoft.com/default...kb;en-us;79972
http://support.microsoft.com/default...b;en-us;125178

Cheers
GeeDee
--
n'oubliez pas les FAQ :
http://www.excelabo.net http://dj.joss.free.fr/faq.htm
http://www.faqoe.com http://faqword.free.fr
--
Feed Back
http://viadresse.com/?94912042

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

Thanks to both for your help.

"Modeste" wrote:

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...b;en-us;213750
http://support.microsoft.com/default...kb;en-us;79972
http://support.microsoft.com/default...b;en-us;125178

Cheers
GeeDee
--
n'oubliez pas les FAQ :
http://www.excelabo.net http://dj.joss.free.fr/faq.htm
http://www.faqoe.com http://faqword.free.fr
--
Feed Back
http://viadresse.com/?94912042