+ Reply to Thread
Results 1 to 3 of 3

Labelling a Scatter Plot

  1. #1
    Registered User
    Join Date
    07-17-2008
    Location
    sd
    Posts
    2

    Labelling a Scatter Plot

    I have a series of points that I'm plotting on an XY (Scatter) chart. The data is in columns (column B and C), and there is a label to the left of each set of points (column A). I'd like to label each of the points using the value in column A. For example

    Name Value1 Value2
    a 1 1
    b 2 1
    c 3 2
    d 1 3

    So I would have 4 points on the chart, with each one labelled with its name. I can get the chart to display the points, but can't figure out how to label them.

    Thanks in advance.

  2. #2
    Registered User
    Join Date
    07-17-2008
    Location
    sd
    Posts
    2
    ... I was able to get them to label if each set of points is it's own series, but I've got over 100 points so that doesn't work well as a long term solution (and there was a limit to the number of series that it let me add anyway).

    Thanks.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,440
    Try this free addin
    http://www.appspro.com/Utilities/ChartLabeler.htm
    Cheers
    Andy
    www.andypope.info

+ 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