+ Reply to Thread
Results 1 to 2 of 2

Mobile Data Labels in Line Graphs

  1. #1
    Registered User
    Join Date
    03-11-2009
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    1

    Mobile Data Labels in Line Graphs

    Is there any way to attach data labels in a line graph where there are lines attached to the text boxes of the data labels that point to/are attached to the corresponding data point, and also will move with the text box if I need to move the box to an area that won't cover up the line? I've seen templates using error labels, but they only offer horizontal or vertical lines, and I was hoping to get mobile lines. Basically, when I am annotating a stock price chart with text on events on certain dates, I would like a text box w/a black border with the text inside, and a line coming from the box to the price point on that date (and have it move automatically within the graph if I update with more recent pricing). Since sometimes the amount of text will cover the original line of the graph, I'd like to be able to move the box around the graph manually, and have the attached line follow automatically while remaining attached to its datapoint.

    Thanks in advance for any help!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Mobile Data Labels in Line Graphs

    No simple solution.

    You would need code to determine positions in order to draw the lines with either shapes or data series.

    If you used data labels for annotation and these were positioned above a know xy point then you could use more xy series to draw lines. But dragging the annotation label AND updating the leader line would not be possible without code
    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