+ Reply to Thread
Results 1 to 3 of 3

Scatter graphs - How do you label points?

  1. #1
    Registered User
    Join Date
    11-24-2006
    Location
    Bristol, UK
    Posts
    34

    Scatter graphs - How do you label points?

    Hi

    I'm trying to add labels to a scatter graph, referring to the 'point' name.

    For example, I have:

    Name: x y
    Keith 55 66
    Barry 48 82
    Sean 63 32

    How do I get the words Keith, Barry and Sean to appear next to the respective points on the scatter graph? Seems simple but is driving me nuts, just can't do it.

    Any help much appreciated. I attach my spreadsheet if anyone would like to take a look...

    Many thanks

    Nick
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-24-2006
    Location
    Bristol, UK
    Posts
    34
    Answered my own question. Turns out you have to program VBA to do it, there's no functionality. If anyone's interested please see:

    Microsoft help on the subject

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819
    There's Rob Bovey's XY chart labeler add in that you can download for free. I forget the web site, but it's appspro.com or something like that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1