Chart for a scatter diagram with labels?

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I have three columns:
A- Site name is a text label (NYC, Paris, London, etc)
B- Number of employees (between 1 and 10,000)
C- Size of Network Resource (between 50 and 50,000)

I am trying to plot a scatter diagram of the sites with column B
as abscissa (X-coord), and column C as Y-value.

So far no problem, works fine. I get my data points with little diamonds neatly
scattered.

My problem is that I need the name of the site (column A) as a label near each
data point. I haven't found a way to do this in Excel 2000.

Any pointers would be much appreciated.


Pat.
 
Bernard said:
Here is Frank Kabel's reply to another post today in the Charting newsgroup:
Have a look at the following add-ins which will do this for you:
http://j-walk.com/ss/excel/files/charttools.htm
http://www.appspro.com/utilities/Labeler.asp
Click to expand...

Thanks, Bernard.

I tried the first one J-walk ad-in and it works like a charm.
I also like the simple approach with a zip file and a simple .xla,
no installer. Safe, clear, clean.

I still can't believe that Excel does not have this capability. I went crazy
trying every menu looking for it. Oh well, at least it's not me :)

Thanks again,
Pat.
 
Back
Top