Labelling points in a plot in Excel with customized label

3

I want to label a plot's points in excel with neither the x nor the y variable but a label that is in a cell where the row happens to be. So for example, if I have the following table data:

1   1   a
2   4   b
3   8   c
4   16  d
5   32  e

I want the point (1,1) in the chart to be labeled as a in the plot, and the point (5,32) labelled as "e".

Flethuseo

Posted 2011-05-17T14:40:27.047

Reputation: 959

Answers

0

Microsoft Support has a solution (article) exactly for your case:

How to use a macro to add labels to data points in an xy scatter chart or in a bubble chart in Excel

Mehper C. Palavuzlar

Posted 2011-05-17T14:40:27.047

Reputation: 51 093