Hello,
I'm trying to figure out if I can have a chart detect when and where I draw a trendline with my mouse, and then annotate some text near that point based on the (x2,y2) (x1,y1) position. I would like, for instance to plot some text stating the percentage change from one point to the other and how long it took.
In this picture example, I would draw the trendline as shown but the text would appear naturally after calculating the trendline data:
I couldn't find any reference to anyone doing this.
Thanks!
Mike