Excel 2010- scattergraphs- data labels

[andrewjohnrose]

Help!!

I have plotted the age vs number of siblings in a scattergraph.
If I then hover over the bottom point, it gives me the value (2,1). Is there any way I can get it to show the name "George" instead?

Much appreciated!
[TABLE="width: 255"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Age
[/TD]
[TD]Number of siblings
[/TD]
[/TR]
[TR]
[TD]John
[/TD]
[TD="align: right"]12
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]James
[/TD]
[TD="align: right"]7
[/TD]
[TD="align: right"]2
[/TD]
[/TR]
[TR]
[TD]Jane
[/TD]
[TD="align: right"]8
[/TD]
[TD="align: right"]3
[/TD]
[/TR]
[TR]
[TD]Dorothy
[/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]2
[/TD]
[/TR]
[TR]
[TD]Ethel
[/TD]
[TD="align: right"]12
[/TD]
[TD="align: right"]3
[/TD]
[/TR]
[TR]
[TD]Fred
[/TD]
[TD="align: right"]9
[/TD]
[TD="align: right"]2
[/TD]
[/TR]
[TR]
[TD]George
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
</tbody>[/TABLE]

 

[BAlGaInTl]

What are your X and Y axis?

Are you plotting Age vs Siblings? Or are you plotting two data points per person?

 

[andrewjohnrose]

What are your X and Y axis?

Are you plotting Age vs Siblings? Or are you plotting two data points per person?

I have plotted the values from column B and from column C, so the x axis is age and the y axis is number of siblings.

 

[BAlGaInTl]

I was looking at this more closely, and I don't think there is any way to automate it easily short of using VBA to display the data labels. You can manually put data labels in, but if it is something that changes often, that can defeat the purpose.

 

[andrewjohnrose]

Thanks for your reply. I don't know where to go from here!