Hello, I am facing a problem about charting in Excel. I have a table as
below
rank name Xvalue Yvalue

1 Aron 10 20
2 Bran 10 30
3 Keny 20 40
4 Sally 30 60

I want to plot a graph of Yvalue against Xvalue,
and at each data point, it need to show the respective rank and name,
i.e. at data pt. (10,20), '1 Aron' should be show on the point.

So how can I do it.


--
hurriance
------------------------------------------------------------------------
hurriance's Profile: http://www.excelforum.com/member.php...o&userid=30882
View this thread: http://www.excelforum.com/showthread...hreadid=510962

Hi,

You can do this by linking the data label to a cell.
Rob Bovey's free addin will make the process very easy.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

hurriance wrote:
Hello, I am facing a problem about charting in Excel. I have a table as
below
rank name Xvalue Yvalue

1 Aron 10 20
2 Bran 10 30
3 Keny 20 40
4 Sally 30 60

I want to plot a graph of Yvalue against Xvalue,
and at each data point, it need to show the respective rank and name,
i.e. at data pt. (10,20), '1 Aron' should be show on the point.

So how can I do it.



--

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