Hi,

This is my first question in excel forum. I have a table of data which I plan to plot in a scatter plot as follows

Name Competency Performance
baron 1 1
davis 2 2
dingan 2 2
sarin 4 1

I am plotting the happiness score in X axis and personality in Y axis. I need to name each plot. The data set has close to 200 names. If I name each data point then the graph becomes too cluttered. I am planning to name each data point in the legend which means the name of each data point in the legend shall be taken from a different column i.e name. Please let me know how this can be done. I have attached a screenshot of an example

Regards,
Anup



excel.gif