Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding names to points in scatter plot (Excel 2000)

    I am plotting data in an XY scatter plot. Each point has three values associated with it: a name, the x- coordinate and the y-coordinate. When I place the mouse on top of a point, a little pop-up window comes up with information about that point, for example: Series "Age" Point "14.0" (14.0, 31.5). The numbers in parentheses are the x-coordinate and y-coordinate of the point. Currently the Point name is the x-coordinate of the point. Is there a way that I can specify what the name of each point should be (i.e., the point names would be in a column adjacent to the x-coordinates)?

  2. #2
    New Lounger
    Join Date
    Feb 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding names to points in scatter plot (Excel 2000)

    Jan Karel,

    Thank you very much for the suggestion. However, Rob's application doesn't do exactly what I'm looking for. I don't necessarily want to label the points on the graph. I am plotting thousands of data points, and I want to be able to point to a particular data point to find out what it's name is. Currently, I have to write down the x- and y-coordinates and then search through my table to find the name associated with those data points. What I want is for the name of a given point to be displayed in the pop-up window (i.e., instead of the pop-up window showing Point "x-coordinate" it would show Point "name".

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding names to points in scatter plot (Excel 2000)

    Apart from using a mousemove event on the chart in question I think that is impossible.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding names to points in scatter plot (Excel 2000)

    Download the xychartlabeller from Rob Bovey at
    http://www.bmsltd.ie/mvp
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •