Add text data labels to scatterplot

[Stu Dapples]

Hi,

I am developing an Impact Matrix sheet utilising the scatterplot chart function. I have it working nicely except I cannot label the points to identify which point is which opportunity....

To the uninitiated, an impact matrix plots 2 variable against a series of ideas, projects etc and allows easy visual identification of which opportunity will have the biggest impact, e.g out of our 20 projects, which will be the quickest to implement at the least cost, you then rate each individual project in terms of how much and how long, run the graph and which ever is closest to the top left is the one you do first....

Enough Black Belt malarky! Anyone got any ideas how to label the dots on teh scatterplot? Even if they were just numbered as at present, it is impossible to see which is which!

Thanks in anticipation,

Stu

 

[VoG]

This may help you http://www.appspro.com/Utilities/ChartLabeler.htm

 

[Stu Dapples]

Superb! Fantastic little add in which will certainly do what is needed, many thanks...