Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Springdale, Arkansas
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text Linked to Series Point (2000 SR1)

    Is there a way to link a text box to a series point in an Excel Chart? If I add a text box and add new data all of the text boxes with comments have to be rearranged and there are several data points in each chart.

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Linked to Series Point (2000 SR1)

    I'm working in 97 SR2, so 2000 might have fixed this but...

    I don't know about linking a text box to a point, but you can modify the data labels for a series. It is a bit laborious as you have to change all of them.

    What you do is right click on the particular series, and select Format Data Series.
    Click on the Data Labels tab, and click on Show label.

    This will show the x-axis value for each point next to it. You can then click on a point, pause and then click again (ie two left clicks as opposed to a double-click). This will let you edit each data label. The formatting is non-existent and you have no control over the line wrapping, but it is linked to the data point.

    HTH

    Jon

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Springdale, Arkansas
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Linked to Series Point (2000 SR1)

    This works great. THANKS!!!

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Linked to Series Point (2000 SR1)

    There is always the possibility to make your own data labeler add-in. You can find some free downloads on the web e.g. <A target="_blank" HREF=http://archive.baarns.com/excel/free/Exceluts.asp> Baarns' website </A>

Posting Permissions

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