Data Point Label

Hi,

I am trying to create a scatter plot in excel based on the
following data set.

X-Axis: 1 2 3 4 5 6 7
8 9 10 11 12 13 14
15
Y-Axis: 10.5 11.5 12.5 13.5 14.5 15.5
16.5 17.5 18.5 19.5 20.5 21.5
22.5 23.5 24.5

Everything is fine upto this point, I get the plot with
points labeled by the values from Y-axis. But what I want
is to label them by the following:

Labels: A B C D E F G
H I J K L M N
O

I could not find any option to pass a set of labels in
excel charts. Any help is highly appreciated.

Thanks,
Sumanta

You can use Rob Bovey's XY Chart Labeler to add the labels. It's a free
add-in that you can download from his web site:

http://www.appspro.com/Utilities/ChartLabeler.htm


wrote:
Hi,

I am trying to create a scatter plot in excel based on the
following data set.

X-Axis: 1 2 3 4 5 6 7
8 9 10 11 12 13 14
15
Y-Axis: 10.5 11.5 12.5 13.5 14.5 15.5
16.5 17.5 18.5 19.5 20.5 21.5
22.5 23.5 24.5

Everything is fine upto this point, I get the plot with
points labeled by the values from Y-axis. But what I want
is to label them by the following:

Labels: A B C D E F G
H I J K L M N
O

I could not find any option to pass a set of labels in
excel charts. Any help is highly appreciated.

Thanks,
Sumanta


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html