Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: nigh on impossible charting question - now answered

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Three lines of data:
    1:US state
    2:Numeral one
    3:Numeral two

    Chart required - scatter showing the state on the chart next to the point with x-value numeral one and y-value numeral two. Should be easy, but isn't obvious to me.
    Thanks,
    Mike

    [ This Message was edited by: sann0638 on 2002-04-08 03:56 ]

    [ This Message was edited by: sann0638 on 2002-04-08 07:54 ]

  2. #2
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On the chart, right click, and select "Chart Options." Go to "Data Labels" tab, select "Show Value" and then at the bottom select "Legend Key next to Label."

    HTH
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry - should have been clearer. Doing what 'Shades' suggests only works (as far as I can tell) for putting labels next to two separately plotted lines of data - not for points that have an x and y value and a label. I may be missing a step, and would appreciate it if someone could fill me in.

  4. #4
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just to bring attention to this tough question.
    Is there any way to attach automatically text labels to each points in x,y chart ?



    [ This Message was edited by: eliW on 2002-04-06 10:49 ]

  5. #5
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    sann0638,
    It seems that it can't be done.

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There's a blow. A colleague did it in Lotus, but I would rather not resort to this! Perhaps Monday morning will shed some light...

    Mike

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Brisbane, Down Under
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There was a similar question a couple of days back and there was a link to another site for an add on - may be of use to you.

    http://www.mrexcel.com/board/viewtop...c=4142&forum=2

  8. #8
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If I understand what you want:

    Use the chart wizard, select the first example for XY(Scatter). Then for Data Range, select all of your data. For Series, select the range with your state names for both the "X values" and "Y values"

    Under Data Labels, you need to check "Show Label" and not "Show Value".


  9. #9
    Board Regular
    Join Date
    Mar 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't think this does exactly what I want, although I may be misinterpreting what you have written. Apologies if so, but could you make it a bit clearer.

    To restate the issue:
    the graph is an x-y chart, for example plotting Texas(3,4), New York(5,1), Mississippi(2,7). I want points shown at (3,4), (5,1) and (2,7) called Texas, New York, Mississippi.

  10. #10
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-05 06:46, eliW wrote:
    Just to bring attention to this tough question.
    Is there any way to attach automatically text labels to each points in x,y chart ?



    [ This Message was edited by: eliW on 2002-04-06 10:49 ]
    Hi All,

    Yes it can be done. The best way is to download Rob Bovey's Chart Labeler add-in from the Free Utilities section on his website

    http://www.appspro.com/

    This will do what you wish automatically.

    Bye,
    Jay

    Edit: I see that Sam S has already mentioned this and John W.'s option in the PUP2000. Sorry for the duplication.

    [ This Message was edited by: Jay Petrulis on 2002-04-08 07:49 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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