Scatter Graph

**keithwalder** · 02-05-2009, 07:11 PM

Apologies if this question is in the wrong forum.

I am trying to create a scatter graph, with ‘Name’, ‘Weight’ & ‘Height’ in it. I am able to plot weight and height on an x and y axis fine. What I want is when I place my mouse over a point it tells weight, height and the persons name.
Name Weight Height
Keith 180 5.95
Ross 165 6
Stuart 145 5.8
Obehi 130 5.6
Dad 200 5.11
Alison 120 5.5

This is an example chart is above. I would like Weight on the x axis and Height on the y axis just as a normal scatter graph. Also I want the persons name weight and height belong to, to be added as well. For my real application I have 500 names so labelling each point would not be possible.
Any help would be very much appreciated!!

Cheers

**Andy Pope** · 02-06-2009, 07:14 AM

Simplest way is to use this free addin which links data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm

**keithwalder** · 02-06-2009, 04:05 PM

Thanks very much. It seems to be doing the trick. A little problem with labels being on the wrong data when you filter data. ie if there is 100 name labels and i filter weight down to a value, the labeler does not take the name for that weight it just takes the first name in the 100 names.

I will look at the help options.

Thanks again!!