Hi,

You can make the link manually if you don't want to, or work won't allow
you, to use an addin. I have some instructions for the chart title but
the technique applies to data labels as well.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

Mary Ann wrote:
Thank you for this. If I don't use an add-on is the only alternative to
create manual text boxes?

"Jon Peltier" wrote:


Mary Ann -

There are a couple free third party Excel add-ins you can use to apply
text from cells as data labels in a chart:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Mary Ann wrote:

I have created a bubble chart which shows % Growth on the X axis, % Profit on
the Y axis and turnover value as the size of the bubble.

How do I label each bubble so that I know which product each one refers to?
I have seen from previous posts that I cant select the labels when I select
the data for the chart.

I am using Excel 2003


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info