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!
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks