Hi,

Here are a couple of free addins that allow you to link data labels to
cells.

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

Cheers
Andy

Penny wrote:
I have a set of x-y coordinate data set and i would like to plot them showing
the respective series name. Is there an automatic way of doing this without
haing to plot the data points separately. eg

Name x y
A 1 6
B 2 3
C 3 4
D 4 2
E 5 5
. . .
. . .
. . .

I will like to have a plot of x and y with A, B, C as series name without
having to plot the points one after the other.

--

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