+ Reply to Thread
Results 1 to 4 of 4

XY Scatter Map with Test Labels

  1. #1
    Mike K.
    Guest

    XY Scatter Map with Test Labels

    Sorry if this is a repeated request, but I'm trying to show the distribution
    of 16 points (labelled A through P) using X-Y coordinates. When I turn on
    labels, I can show either the X-positions (label) or Y-positions (value), but
    I really want to show the text name "A" through "P". Can this be automated
    in Excel?
    Thanks for any advice.

  2. #2
    Andy Pope
    Guest

    Re: XY Scatter Map with Test Labels

    Hi Mike,

    The easiest thing to do is use a free addin utility to allow you to link
    data labels to cells.

    Try Rob Bovey's XY Chart Labeler add-in
    http://www.appspro.com/Utilities/ChartLabeler.htm

    Cheers
    Andy

    Mike K. wrote:
    > Sorry if this is a repeated request, but I'm trying to show the distribution
    > of 16 points (labelled A through P) using X-Y coordinates. When I turn on
    > labels, I can show either the X-positions (label) or Y-positions (value), but
    > I really want to show the text name "A" through "P". Can this be automated
    > in Excel?
    > Thanks for any advice.


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

  3. #3
    John Mansfield
    Guest

    RE: XY Scatter Map with Test Labels

    Mike,

    The technique described at the site below uses a VBA worksheet calculate
    event to automate the updating of XY chart labels. The example can be
    downloaded fom the site as well.

    http://www.pdbook.com/index.php/exce...t_data_labels/

    ----
    Regards,
    John Mansfield
    http://www.pdbook.com

    "Mike K." wrote:

    > Sorry if this is a repeated request, but I'm trying to show the distribution
    > of 16 points (labelled A through P) using X-Y coordinates. When I turn on
    > labels, I can show either the X-positions (label) or Y-positions (value), but
    > I really want to show the text name "A" through "P". Can this be automated
    > in Excel?
    > Thanks for any advice.


  4. #4
    Barb R.
    Guest

    RE: XY Scatter Map with Test Labels

    You can use Rob Bovey's XY Chart Labeler to do this.

    http://www.appspro.com/Utilities/ChartLabeler.htm

    "Mike K." wrote:

    > Sorry if this is a repeated request, but I'm trying to show the distribution
    > of 16 points (labelled A through P) using X-Y coordinates. When I turn on
    > labels, I can show either the X-positions (label) or Y-positions (value), but
    > I really want to show the text name "A" through "P". Can this be automated
    > in Excel?
    > Thanks for any advice.


+ 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