[SOLVED] How do I add labels to a bubble chart?

[Patrick1974]

I have created a bubble chart based on following data-table
Score 1 Score 2 Score 3
Customer A 1 4 5
Customer B 3 3 2
Customer C 5 1 1

Score 1 = X-axis / Score 2 = Y-axis / Score 3 = bubble size

I cannot get excel to add the customer names as labels to individual
bubbles. When I try to add names, it adds all names to all bubbles. Off
course I can manually change the names, however isn't there an easier way?

[Andy Pope]

Hi,

Either of these free addins will make the task of linking data labels to
cells easier.

Rob Bovey's Chart Labeler
http://appspro.com

Or John Walkenbach's Chart Tools
http://j-walk.com

Cheers
Andy

Patrick1974 wrote:
> I have created a bubble chart based on following data-table
> Score 1 Score 2 Score 3
> Customer A 1 4 5
> Customer B 3 3 2
> Customer C 5 1 1
>
> Score 1 = X-axis / Score 2 = Y-axis / Score 3 = bubble size
>
> I cannot get excel to add the customer names as labels to individual
> bubbles. When I try to add names, it adds all names to all bubbles. Off
> course I can manually change the names, however isn't there an easier way?

--

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