Legends in scatter plot

[Nup]

Hi,

This is my first question in this 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 competency score in X axis and performance 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. I am uploading an excel file I made. In the excel file the Plus sign is currently assigned 1 in the legend. I want it baron.Please let me know how this can be done.

Regards,
Anup

 

[Chihiro]

Cross post.
http://www.excelforum.com/showthread.php?t=1172314&highlight=scatter+plot

Please Don't

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

Read:
http://chandoo.org/forum/threads/new-users-please-read.294/

 

[NARAYANK991]

Hi ,

The uploaded file contains a macro named AddChart ; running this macro will add a chart and all the 200 series so that the legend contains the names.

This macro has a call to your PutShapes macro ; since I do not have these image files , I cannot add the shapes , but running it at your end should replace the markers with the appropriate pictures.

I have defined some named ranges , which you will have to modify to cater to the 200 points.

Narayan

 

[Nup]

Cross post.
http://www.excelforum.com/showthread.php?t=1172314&highlight=scatter plot

Please Don't

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

Read:
http://chandoo.org/forum/threads/new-users-please-read.294/

Hi Chihiro,

As you might have seen in other forums, This is my first question in any forum. I likened it to asking directions when you are lost. You dont ask one person and wait for an answer. You ask many ppl in the hope that atleast one of them gives you the directions. But yes maybe, I should have posted it here that I have posted it in other forums.

However I do agree that I should have posted the answers in all the forums I asked. I would have done it today anyways because I had to submit the project by Friday

So here goes:
I find this link real good when it comes to legends.This kind of approach is illustrated here (http://peltiertech.com/double-legend-in-a-single-chart/ ) So the trick is we need to create two graphs in the same sheet. One plot will have name and competency as parameters and the other will have competency and performance as parameters. We hide the legend of the first plot and hide the plot area of the second plot. this can be done by brining in transparency of legend as 0% and putting in solid fill.